Notebbok-3-yaml-files-additional-variables-create.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv('IPL_Analysis_Version_2_1_Homeground_Net_Run_Rate_Sorted.csv',sep='|')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Unnamed: 0', '5_Over_Wicket', '5_Over_score', 'First_Innings',\n",
       "       'Last_5_Over_Score', 'Last_5_Over_Wicket', 'Match_City', 'Match_Number',\n",
       "       'Match_Stadium', 'Match_Teams',\n",
       "       ...\n",
       "       'Over_5_extra_del_wkts', 'Team', 'Toss_Won', 'Total_Overs',\n",
       "       'Total_Score', 'Total_Wickets', 'Home Ground', 'Prev_Run_Score_Rate',\n",
       "       'Prev_Run_Concede_Rate', 'Team_Codes'],\n",
       "      dtype='object', length=127)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#df1=df[['5_Over_Wicket','5_Over_score','First_Innings','Last_5_Over_Score','Last_5_Over_Wicket','Match_Number','Match_Stadium','Match_Teams','Match_Weekday','Match_Year','Net_Run_Rate','Team','Toss_Won','Total_Overs','Total_Score','Total_Wickets','Home Ground','Prev_Run_Score_Rate','Prev_Run_Concede_Rate','Team_Codes']]\n",
    "df1=df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Unnamed: 0', '5_Over_Wicket', '5_Over_score', 'First_Innings',\n",
       "       'Last_5_Over_Score', 'Last_5_Over_Wicket', 'Match_City', 'Match_Number',\n",
       "       'Match_Stadium', 'Match_Teams',\n",
       "       ...\n",
       "       'Over_5_extra_del_wkts', 'Team', 'Toss_Won', 'Total_Overs',\n",
       "       'Total_Score', 'Total_Wickets', 'Home Ground', 'Prev_Run_Score_Rate',\n",
       "       'Prev_Run_Concede_Rate', 'Team_Codes'],\n",
       "      dtype='object', length=127)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2008\n"
     ]
    }
   ],
   "source": [
    "for row in df1.loc[19:19,'Match_Year']:\n",
    "    print(row)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "dict_2008_First_Inn={}\n",
    "dict_2009_First_Inn={}\n",
    "dict_2010_First_Inn={}\n",
    "dict_2011_First_Inn={}\n",
    "dict_2012_First_Inn={}\n",
    "dict_2013_First_Inn={}\n",
    "dict_2014_First_Inn={}\n",
    "dict_2015_First_Inn={}\n",
    "dict_2016_First_Inn={}\n",
    "dict_2017_First_Inn={}\n",
    "dict_2018_First_Inn={}\n",
    "dict_2019_First_Inn={}\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "dict_2008_Sec_Inn={}\n",
    "dict_2009_Sec_Inn={}\n",
    "dict_2010_Sec_Inn={}\n",
    "dict_2011_Sec_Inn={}\n",
    "dict_2012_Sec_Inn={}\n",
    "dict_2013_Sec_Inn={}\n",
    "dict_2014_Sec_Inn={}\n",
    "dict_2015_Sec_Inn={}\n",
    "dict_2016_Sec_Inn={}\n",
    "dict_2017_Sec_Inn={}\n",
    "dict_2018_Sec_Inn={}\n",
    "dict_2019_Sec_Inn={}\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(len(df1)):\n",
    "    myear=df1.loc[i:i, 'Match_Year'].values[0]\n",
    "    mnum=df1.loc[i:i, 'Match_Number'].values[0]\n",
    "    minns= df1.loc[i:i, 'First_Innings'].values[0]\n",
    "    tc=df1.loc[i:i, 'Team_Codes'].values[0]\n",
    "    #print(myear)\n",
    "    if(myear==2008 and minns==1 ):\n",
    "        if(tc in dict_2008_First_Inn):\n",
    "            dict_2008_First_Inn[tc].append(mnum)\n",
    "        else:\n",
    "            dict_2008_First_Inn[tc]=[mnum]\n",
    "    elif (myear==2008 and minns==0):\n",
    "        if(tc in dict_2008_Sec_Inn):\n",
    "            dict_2008_Sec_Inn[tc].append(mnum)\n",
    "        else:\n",
    "            dict_2008_Sec_Inn[tc]=[mnum]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'CSK': [2, 8, 15, 20, 24, 26, 32, 37, 58],\n",
       " 'DC': [5, 7, 9, 18, 21, 30, 49, 55],\n",
       " 'DD': [14, 17, 28, 34, 39, 41],\n",
       " 'KKR': [1, 12, 16, 29, 33, 36, 40, 44, 46],\n",
       " 'KXIP': [6, 10, 22, 38, 47, 53, 57],\n",
       " 'MI': [4, 13, 23, 43, 50, 54],\n",
       " 'RCB': [11, 25, 31, 35, 45, 48, 52],\n",
       " 'RR': [3, 19, 27, 42, 51, 56]}"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dict_2008_First_Inn"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'CSK': [12, 28, 44, 48, 51, 55, 57],\n",
       " 'DC': [13, 26, 33, 39, 43, 52],\n",
       " 'DD': [3, 7, 20, 23, 36, 45, 50, 56],\n",
       " 'KKR': [5, 19, 22, 53],\n",
       " 'KXIP': [2, 14, 18, 25, 32, 35, 41, 49],\n",
       " 'MI': [8, 10, 16, 27, 31, 37, 40, 47],\n",
       " 'RCB': [1, 4, 15, 17, 21, 29, 42],\n",
       " 'RR': [6, 9, 11, 24, 30, 34, 38, 46, 54, 58]}"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dict_2008_Sec_Inn"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "df['Bowling_Team_Codes']=''\n",
    "df1['Bowling_Team_Codes']=''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "11.33"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1[(df1.Match_Year==2008) & (df1.Team_Codes=='KKR') & (df1.Match_Number==1)].loc[:,'Net_Run_Rate'].values[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(len(df1)):   \n",
    "    myear=df1.loc[i:i, 'Match_Year'].values[0]\n",
    "    mnum=df1.loc[i:i, 'Match_Number'].values[0]\n",
    "    minns= df1.loc[i:i, 'First_Innings'].values[0]\n",
    "    tc=df1.loc[i:i, 'Team_Codes'].values[0]\n",
    "    if(minns==1):\n",
    "        bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "    if(minns==0):\n",
    "        bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "    df1.loc[i:i, 'Bowling_Team_Codes']=bwl_tc\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": false
   },
   "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>5_Over_Wicket</th>\n",
       "      <th>5_Over_score</th>\n",
       "      <th>First_Innings</th>\n",
       "      <th>Last_5_Over_Score</th>\n",
       "      <th>Last_5_Over_Wicket</th>\n",
       "      <th>Match_Number</th>\n",
       "      <th>Match_Stadium</th>\n",
       "      <th>Match_Teams</th>\n",
       "      <th>Match_Weekday</th>\n",
       "      <th>Match_Year</th>\n",
       "      <th>...</th>\n",
       "      <th>Team</th>\n",
       "      <th>Toss_Won</th>\n",
       "      <th>Total_Overs</th>\n",
       "      <th>Total_Score</th>\n",
       "      <th>Total_Wickets</th>\n",
       "      <th>Home Ground</th>\n",
       "      <th>Prev_Run_Score_Rate</th>\n",
       "      <th>Prev_Run_Concede_Rate</th>\n",
       "      <th>Team_Codes</th>\n",
       "      <th>Bowling_Team_Codes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>60</td>\n",
       "      <td>1</td>\n",
       "      <td>68</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Kolkata Knight R...</td>\n",
       "      <td>4</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>222</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KKR</td>\n",
       "      <td>RCB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Kolkata Knight R...</td>\n",
       "      <td>4</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>15.2</td>\n",
       "      <td>82</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RCB</td>\n",
       "      <td>KKR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>79</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Punjab Cricket Association Stadium, Mohali</td>\n",
       "      <td>Kings XI Punjab - Chennai Super Kings</td>\n",
       "      <td>5</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>240</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CSK</td>\n",
       "      <td>KXIP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Punjab Cricket Association Stadium, Mohali</td>\n",
       "      <td>Kings XI Punjab - Chennai Super Kings</td>\n",
       "      <td>5</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>207</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>CSK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>Delhi Daredevils - Rajasthan Royals</td>\n",
       "      <td>5</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>129</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RR</td>\n",
       "      <td>DD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>Delhi Daredevils - Rajasthan Royals</td>\n",
       "      <td>5</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>0</td>\n",
       "      <td>15.1</td>\n",
       "      <td>132</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DD</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>1</td>\n",
       "      <td>60</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>Wankhede Stadium</td>\n",
       "      <td>Mumbai Indians - Royal Challengers Bangalore</td>\n",
       "      <td>6</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>165</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MI</td>\n",
       "      <td>RCB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>48</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>Wankhede Stadium</td>\n",
       "      <td>Mumbai Indians - Royal Challengers Bangalore</td>\n",
       "      <td>6</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>19.5</td>\n",
       "      <td>166</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RCB</td>\n",
       "      <td>MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>33</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>Kolkata Knight Riders - Deccan Chargers</td>\n",
       "      <td>6</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>1</td>\n",
       "      <td>18.4</td>\n",
       "      <td>110</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DC</td>\n",
       "      <td>KKR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>3</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>Kolkata Knight Riders - Deccan Chargers</td>\n",
       "      <td>6</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>18.6</td>\n",
       "      <td>112</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KKR</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>51</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>1</td>\n",
       "      <td>19.7</td>\n",
       "      <td>166</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>3</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>0</td>\n",
       "      <td>18.1</td>\n",
       "      <td>168</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RR</td>\n",
       "      <td>KXIP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>69</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Deccan Chargers - Delhi Daredevils</td>\n",
       "      <td>1</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>1</td>\n",
       "      <td>19.7</td>\n",
       "      <td>142</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DC</td>\n",
       "      <td>DD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Deccan Chargers - Delhi Daredevils</td>\n",
       "      <td>1</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>0</td>\n",
       "      <td>13.1</td>\n",
       "      <td>143</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DD</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>65</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Mumbai Indians</td>\n",
       "      <td>2</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>208</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CSK</td>\n",
       "      <td>MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>68</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Mumbai Indians</td>\n",
       "      <td>2</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>1</td>\n",
       "      <td>19.7</td>\n",
       "      <td>202</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MI</td>\n",
       "      <td>CSK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2</td>\n",
       "      <td>48</td>\n",
       "      <td>1</td>\n",
       "      <td>66</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Deccan Chargers - Rajasthan Royals</td>\n",
       "      <td>3</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>0</td>\n",
       "      <td>19.7</td>\n",
       "      <td>214</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DC</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1</td>\n",
       "      <td>57</td>\n",
       "      <td>0</td>\n",
       "      <td>58</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Deccan Chargers - Rajasthan Royals</td>\n",
       "      <td>3</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>19.5</td>\n",
       "      <td>217</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RR</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>Punjab Cricket Association Stadium, Mohali</td>\n",
       "      <td>Kings XI Punjab - Mumbai Indians</td>\n",
       "      <td>4</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>182</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>Punjab Cricket Association Stadium, Mohali</td>\n",
       "      <td>Kings XI Punjab - Mumbai Indians</td>\n",
       "      <td>4</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>116</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MI</td>\n",
       "      <td>KXIP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Rajasthan Royals</td>\n",
       "      <td>5</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>19.7</td>\n",
       "      <td>135</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RCB</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Rajasthan Royals</td>\n",
       "      <td>5</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>17.1</td>\n",
       "      <td>138</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RR</td>\n",
       "      <td>RCB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Kolkata Knight Riders</td>\n",
       "      <td>5</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>1</td>\n",
       "      <td>19.7</td>\n",
       "      <td>147</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KKR</td>\n",
       "      <td>CSK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Kolkata Knight Riders</td>\n",
       "      <td>5</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>0</td>\n",
       "      <td>16.6</td>\n",
       "      <td>152</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CSK</td>\n",
       "      <td>KKR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>55</td>\n",
       "      <td>2</td>\n",
       "      <td>13</td>\n",
       "      <td>Dr DY Patil Sports Academy</td>\n",
       "      <td>Mumbai Indians - Deccan Chargers</td>\n",
       "      <td>6</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>154</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MI</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0</td>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>Dr DY Patil Sports Academy</td>\n",
       "      <td>Mumbai Indians - Deccan Chargers</td>\n",
       "      <td>6</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>1</td>\n",
       "      <td>11.6</td>\n",
       "      <td>155</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DC</td>\n",
       "      <td>MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>51</td>\n",
       "      <td>3</td>\n",
       "      <td>14</td>\n",
       "      <td>Punjab Cricket Association Stadium, Mohali</td>\n",
       "      <td>Kings XI Punjab - Delhi Daredevils</td>\n",
       "      <td>6</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>158</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DD</td>\n",
       "      <td>KXIP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "      <td>2</td>\n",
       "      <td>14</td>\n",
       "      <td>Punjab Cricket Association Stadium, Mohali</td>\n",
       "      <td>Kings XI Punjab - Delhi Daredevils</td>\n",
       "      <td>6</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>19.3</td>\n",
       "      <td>162</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>DD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>76</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Chennai Super Kings</td>\n",
       "      <td>0</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>178</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CSK</td>\n",
       "      <td>RCB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>7</td>\n",
       "      <td>15</td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Chennai Super Kings</td>\n",
       "      <td>0</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>19.4</td>\n",
       "      <td>165</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RCB</td>\n",
       "      <td>CSK</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>1458</th>\n",
       "      <td>1</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>49</td>\n",
       "      <td>2</td>\n",
       "      <td>36</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Mumbai Indians</td>\n",
       "      <td>5</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>161</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MI</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1459</th>\n",
       "      <td>1</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>2</td>\n",
       "      <td>36</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Mumbai Indians</td>\n",
       "      <td>5</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>19.1</td>\n",
       "      <td>162</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RR</td>\n",
       "      <td>MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1460</th>\n",
       "      <td>2</td>\n",
       "      <td>46</td>\n",
       "      <td>1</td>\n",
       "      <td>45</td>\n",
       "      <td>2</td>\n",
       "      <td>37</td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>Delhi Capitals - Kings XI Punjab</td>\n",
       "      <td>5</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>163</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>DD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1461</th>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>3</td>\n",
       "      <td>37</td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>Delhi Capitals - Kings XI Punjab</td>\n",
       "      <td>5</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>1</td>\n",
       "      <td>19.4</td>\n",
       "      <td>166</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DD</td>\n",
       "      <td>KXIP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1462</th>\n",
       "      <td>2</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>4</td>\n",
       "      <td>38</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Sunrisers Hyderabad - Kolkata Knight Riders</td>\n",
       "      <td>6</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>159</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KKR</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1463</th>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Sunrisers Hyderabad - Kolkata Knight Riders</td>\n",
       "      <td>6</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>14.6</td>\n",
       "      <td>161</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DC</td>\n",
       "      <td>KKR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1464</th>\n",
       "      <td>1</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>4</td>\n",
       "      <td>39</td>\n",
       "      <td>M.Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Chennai Super Kings</td>\n",
       "      <td>6</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>161</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RCB</td>\n",
       "      <td>CSK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1465</th>\n",
       "      <td>3</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>68</td>\n",
       "      <td>3</td>\n",
       "      <td>39</td>\n",
       "      <td>M.Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Chennai Super Kings</td>\n",
       "      <td>6</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>160</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CSK</td>\n",
       "      <td>RCB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1466</th>\n",
       "      <td>1</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>4</td>\n",
       "      <td>40</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Delhi Capitals</td>\n",
       "      <td>0</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>0</td>\n",
       "      <td>19.7</td>\n",
       "      <td>191</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RR</td>\n",
       "      <td>DD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1467</th>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>51</td>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Delhi Capitals</td>\n",
       "      <td>0</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>1</td>\n",
       "      <td>19.2</td>\n",
       "      <td>193</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DD</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1468</th>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>175</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DC</td>\n",
       "      <td>CSK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1469</th>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>41</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>1</td>\n",
       "      <td>19.5</td>\n",
       "      <td>176</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CSK</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1470</th>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>M.Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Kings XI Punjab</td>\n",
       "      <td>2</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>202</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RCB</td>\n",
       "      <td>KXIP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1471</th>\n",
       "      <td>1</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>4</td>\n",
       "      <td>42</td>\n",
       "      <td>M.Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Kings XI Punjab</td>\n",
       "      <td>2</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>185</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>RCB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1472</th>\n",
       "      <td>2</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>75</td>\n",
       "      <td>2</td>\n",
       "      <td>43</td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>Kolkata Knight Riders - Rajasthan Royals</td>\n",
       "      <td>3</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>175</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KKR</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1473</th>\n",
       "      <td>0</td>\n",
       "      <td>53</td>\n",
       "      <td>0</td>\n",
       "      <td>55</td>\n",
       "      <td>2</td>\n",
       "      <td>43</td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>Kolkata Knight Riders - Rajasthan Royals</td>\n",
       "      <td>3</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>19.2</td>\n",
       "      <td>177</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RR</td>\n",
       "      <td>KKR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1474</th>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>1</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Mumbai Indians</td>\n",
       "      <td>4</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>155</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MI</td>\n",
       "      <td>CSK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1475</th>\n",
       "      <td>3</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>4</td>\n",
       "      <td>44</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Mumbai Indians</td>\n",
       "      <td>4</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>1</td>\n",
       "      <td>17.4</td>\n",
       "      <td>109</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CSK</td>\n",
       "      <td>MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1476</th>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>1</td>\n",
       "      <td>39</td>\n",
       "      <td>5</td>\n",
       "      <td>45</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Sunrisers Hyderabad</td>\n",
       "      <td>5</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>0</td>\n",
       "      <td>19.7</td>\n",
       "      <td>160</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DC</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1477</th>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>45</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Sunrisers Hyderabad</td>\n",
       "      <td>5</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>19.1</td>\n",
       "      <td>161</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RR</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1478</th>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>1</td>\n",
       "      <td>60</td>\n",
       "      <td>2</td>\n",
       "      <td>46</td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>Delhi Capitals - Royal Challengers Bangalore</td>\n",
       "      <td>6</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>187</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DD</td>\n",
       "      <td>RCB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1479</th>\n",
       "      <td>0</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>2</td>\n",
       "      <td>46</td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>Delhi Capitals - Royal Challengers Bangalore</td>\n",
       "      <td>6</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>19.7</td>\n",
       "      <td>171</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RCB</td>\n",
       "      <td>DD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1480</th>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "      <td>1</td>\n",
       "      <td>75</td>\n",
       "      <td>1</td>\n",
       "      <td>47</td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>Kolkata Knight Riders - Mumbai Indians</td>\n",
       "      <td>6</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>232</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KKR</td>\n",
       "      <td>MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1481</th>\n",
       "      <td>2</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>58</td>\n",
       "      <td>2</td>\n",
       "      <td>47</td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>Kolkata Knight Riders - Mumbai Indians</td>\n",
       "      <td>6</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>198</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MI</td>\n",
       "      <td>KKR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1482</th>\n",
       "      <td>0</td>\n",
       "      <td>66</td>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>5</td>\n",
       "      <td>48</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Sunrisers Hyderabad - Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>0</td>\n",
       "      <td>19.7</td>\n",
       "      <td>212</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DC</td>\n",
       "      <td>KXIP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1483</th>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>44</td>\n",
       "      <td>3</td>\n",
       "      <td>48</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Sunrisers Hyderabad - Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>167</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1484</th>\n",
       "      <td>7</td>\n",
       "      <td>62</td>\n",
       "      <td>1</td>\n",
       "      <td>62</td>\n",
       "      <td>7</td>\n",
       "      <td>49</td>\n",
       "      <td>M.Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>62</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RCB</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1485</th>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>41</td>\n",
       "      <td>1</td>\n",
       "      <td>49</td>\n",
       "      <td>M.Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>41</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RR</td>\n",
       "      <td>RCB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1486</th>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>77</td>\n",
       "      <td>1</td>\n",
       "      <td>50</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Delhi Capitals</td>\n",
       "      <td>2</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>0</td>\n",
       "      <td>19.7</td>\n",
       "      <td>179</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CSK</td>\n",
       "      <td>DD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1487</th>\n",
       "      <td>1</td>\n",
       "      <td>49</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>50</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Delhi Capitals</td>\n",
       "      <td>2</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>1</td>\n",
       "      <td>16.2</td>\n",
       "      <td>99</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DD</td>\n",
       "      <td>CSK</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1488 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      5_Over_Wicket  5_Over_score  First_Innings  Last_5_Over_Score  \\\n",
       "0                 0            60              1                 68   \n",
       "1                 3            24              0                  1   \n",
       "2                 1            42              1                 79   \n",
       "3                 0            47              0                 42   \n",
       "4                 2            37              1                 33   \n",
       "5                 1            48              0                  4   \n",
       "6                 2            41              1                 60   \n",
       "7                 1            37              0                 48   \n",
       "8                 2            23              1                 33   \n",
       "9                 3            23              0                 31   \n",
       "10                1            38              1                 51   \n",
       "11                3            48              0                 26   \n",
       "12                1            23              1                 69   \n",
       "13                1            37              0                  0   \n",
       "14                2            40              1                 65   \n",
       "15                2            50              0                 68   \n",
       "16                2            48              1                 66   \n",
       "17                1            57              0                 58   \n",
       "18                1            43              1                 44   \n",
       "19                2            34              0                 15   \n",
       "20                2            42              1                 40   \n",
       "21                2            39              0                 17   \n",
       "22                2            50              1                 43   \n",
       "23                0            35              0                 31   \n",
       "24                2            22              1                 55   \n",
       "25                0            47              0                  0   \n",
       "26                2            40              1                 51   \n",
       "27                2            43              0                 39   \n",
       "28                1            25              1                 76   \n",
       "29                1            32              0                 33   \n",
       "...             ...           ...            ...                ...   \n",
       "1458              1            38              1                 49   \n",
       "1459              1            48              0                 34   \n",
       "1460              2            46              1                 45   \n",
       "1461              1            52              0                 38   \n",
       "1462              2            53              1                 43   \n",
       "1463              0            52              0                  0   \n",
       "1464              1            33              1                 43   \n",
       "1465              3            23              0                 68   \n",
       "1466              1            38              1                 41   \n",
       "1467              0            45              0                 51   \n",
       "1468              1            43              1                 41   \n",
       "1469              1            27              0                 41   \n",
       "1470              1            52              1                 80   \n",
       "1471              1            56              0                 42   \n",
       "1472              2            31              1                 75   \n",
       "1473              0            53              0                 55   \n",
       "1474              1            41              1                 50   \n",
       "1475              3            35              0                 21   \n",
       "1476              1            41              1                 39   \n",
       "1477              0            40              0                 29   \n",
       "1478              1            52              1                 60   \n",
       "1479              0            56              0                 45   \n",
       "1480              0            39              1                 75   \n",
       "1481              2            29              0                 58   \n",
       "1482              0            66              1                 53   \n",
       "1483              1            40              0                 44   \n",
       "1484              7            62              1                 62   \n",
       "1485              1            41              0                 41   \n",
       "1486              1            17              1                 77   \n",
       "1487              1            49              0                  7   \n",
       "\n",
       "      Last_5_Over_Wicket  Match_Number  \\\n",
       "0                      1             1   \n",
       "1                      1             1   \n",
       "2                      1             2   \n",
       "3                      1             2   \n",
       "4                      1             3   \n",
       "5                      0             3   \n",
       "6                      3             4   \n",
       "7                      1             4   \n",
       "8                      4             5   \n",
       "9                      1             5   \n",
       "10                     4             6   \n",
       "11                     0             6   \n",
       "12                     3             7   \n",
       "13                     0             7   \n",
       "14                     2             8   \n",
       "15                     2             8   \n",
       "16                     2             9   \n",
       "17                     4             9   \n",
       "18                     6            10   \n",
       "19                     2            10   \n",
       "20                     1            11   \n",
       "21                     1            11   \n",
       "22                     3            12   \n",
       "23                     0            12   \n",
       "24                     2            13   \n",
       "25                     0            13   \n",
       "26                     3            14   \n",
       "27                     2            14   \n",
       "28                     2            15   \n",
       "29                     7            15   \n",
       "...                  ...           ...   \n",
       "1458                   2            36   \n",
       "1459                   2            36   \n",
       "1460                   2            37   \n",
       "1461                   3            37   \n",
       "1462                   4            38   \n",
       "1463                   0            38   \n",
       "1464                   4            39   \n",
       "1465                   3            39   \n",
       "1466                   4            40   \n",
       "1467                   2            40   \n",
       "1468                   1            41   \n",
       "1469                   2            41   \n",
       "1470                   0            42   \n",
       "1471                   4            42   \n",
       "1472                   2            43   \n",
       "1473                   2            43   \n",
       "1474                   1            44   \n",
       "1475                   4            44   \n",
       "1476                   5            45   \n",
       "1477                   1            45   \n",
       "1478                   2            46   \n",
       "1479                   2            46   \n",
       "1480                   1            47   \n",
       "1481                   2            47   \n",
       "1482                   5            48   \n",
       "1483                   3            48   \n",
       "1484                   7            49   \n",
       "1485                   1            49   \n",
       "1486                   1            50   \n",
       "1487                   2            50   \n",
       "\n",
       "                                   Match_Stadium  \\\n",
       "0                          M Chinnaswamy Stadium   \n",
       "1                          M Chinnaswamy Stadium   \n",
       "2     Punjab Cricket Association Stadium, Mohali   \n",
       "3     Punjab Cricket Association Stadium, Mohali   \n",
       "4                               Feroz Shah Kotla   \n",
       "5                               Feroz Shah Kotla   \n",
       "6                               Wankhede Stadium   \n",
       "7                               Wankhede Stadium   \n",
       "8                                   Eden Gardens   \n",
       "9                                   Eden Gardens   \n",
       "10                        Sawai Mansingh Stadium   \n",
       "11                        Sawai Mansingh Stadium   \n",
       "12     Rajiv Gandhi International Stadium, Uppal   \n",
       "13     Rajiv Gandhi International Stadium, Uppal   \n",
       "14               MA Chidambaram Stadium, Chepauk   \n",
       "15               MA Chidambaram Stadium, Chepauk   \n",
       "16     Rajiv Gandhi International Stadium, Uppal   \n",
       "17     Rajiv Gandhi International Stadium, Uppal   \n",
       "18    Punjab Cricket Association Stadium, Mohali   \n",
       "19    Punjab Cricket Association Stadium, Mohali   \n",
       "20                         M Chinnaswamy Stadium   \n",
       "21                         M Chinnaswamy Stadium   \n",
       "22               MA Chidambaram Stadium, Chepauk   \n",
       "23               MA Chidambaram Stadium, Chepauk   \n",
       "24                    Dr DY Patil Sports Academy   \n",
       "25                    Dr DY Patil Sports Academy   \n",
       "26    Punjab Cricket Association Stadium, Mohali   \n",
       "27    Punjab Cricket Association Stadium, Mohali   \n",
       "28                         M Chinnaswamy Stadium   \n",
       "29                         M Chinnaswamy Stadium   \n",
       "...                                          ...   \n",
       "1458                      Sawai Mansingh Stadium   \n",
       "1459                      Sawai Mansingh Stadium   \n",
       "1460                            Feroz Shah Kotla   \n",
       "1461                            Feroz Shah Kotla   \n",
       "1462   Rajiv Gandhi International Stadium, Uppal   \n",
       "1463   Rajiv Gandhi International Stadium, Uppal   \n",
       "1464                       M.Chinnaswamy Stadium   \n",
       "1465                       M.Chinnaswamy Stadium   \n",
       "1466                      Sawai Mansingh Stadium   \n",
       "1467                      Sawai Mansingh Stadium   \n",
       "1468             MA Chidambaram Stadium, Chepauk   \n",
       "1469             MA Chidambaram Stadium, Chepauk   \n",
       "1470                       M.Chinnaswamy Stadium   \n",
       "1471                       M.Chinnaswamy Stadium   \n",
       "1472                                Eden Gardens   \n",
       "1473                                Eden Gardens   \n",
       "1474             MA Chidambaram Stadium, Chepauk   \n",
       "1475             MA Chidambaram Stadium, Chepauk   \n",
       "1476                      Sawai Mansingh Stadium   \n",
       "1477                      Sawai Mansingh Stadium   \n",
       "1478                            Feroz Shah Kotla   \n",
       "1479                            Feroz Shah Kotla   \n",
       "1480                                Eden Gardens   \n",
       "1481                                Eden Gardens   \n",
       "1482   Rajiv Gandhi International Stadium, Uppal   \n",
       "1483   Rajiv Gandhi International Stadium, Uppal   \n",
       "1484                       M.Chinnaswamy Stadium   \n",
       "1485                       M.Chinnaswamy Stadium   \n",
       "1486             MA Chidambaram Stadium, Chepauk   \n",
       "1487             MA Chidambaram Stadium, Chepauk   \n",
       "\n",
       "                                            Match_Teams  Match_Weekday  \\\n",
       "0     Royal Challengers Bangalore - Kolkata Knight R...              4   \n",
       "1     Royal Challengers Bangalore - Kolkata Knight R...              4   \n",
       "2                 Kings XI Punjab - Chennai Super Kings              5   \n",
       "3                 Kings XI Punjab - Chennai Super Kings              5   \n",
       "4                   Delhi Daredevils - Rajasthan Royals              5   \n",
       "5                   Delhi Daredevils - Rajasthan Royals              5   \n",
       "6          Mumbai Indians - Royal Challengers Bangalore              6   \n",
       "7          Mumbai Indians - Royal Challengers Bangalore              6   \n",
       "8               Kolkata Knight Riders - Deccan Chargers              6   \n",
       "9               Kolkata Knight Riders - Deccan Chargers              6   \n",
       "10                   Rajasthan Royals - Kings XI Punjab              0   \n",
       "11                   Rajasthan Royals - Kings XI Punjab              0   \n",
       "12                   Deccan Chargers - Delhi Daredevils              1   \n",
       "13                   Deccan Chargers - Delhi Daredevils              1   \n",
       "14                 Chennai Super Kings - Mumbai Indians              2   \n",
       "15                 Chennai Super Kings - Mumbai Indians              2   \n",
       "16                   Deccan Chargers - Rajasthan Royals              3   \n",
       "17                   Deccan Chargers - Rajasthan Royals              3   \n",
       "18                     Kings XI Punjab - Mumbai Indians              4   \n",
       "19                     Kings XI Punjab - Mumbai Indians              4   \n",
       "20       Royal Challengers Bangalore - Rajasthan Royals              5   \n",
       "21       Royal Challengers Bangalore - Rajasthan Royals              5   \n",
       "22          Chennai Super Kings - Kolkata Knight Riders              5   \n",
       "23          Chennai Super Kings - Kolkata Knight Riders              5   \n",
       "24                     Mumbai Indians - Deccan Chargers              6   \n",
       "25                     Mumbai Indians - Deccan Chargers              6   \n",
       "26                   Kings XI Punjab - Delhi Daredevils              6   \n",
       "27                   Kings XI Punjab - Delhi Daredevils              6   \n",
       "28    Royal Challengers Bangalore - Chennai Super Kings              0   \n",
       "29    Royal Challengers Bangalore - Chennai Super Kings              0   \n",
       "...                                                 ...            ...   \n",
       "1458                  Rajasthan Royals - Mumbai Indians              5   \n",
       "1459                  Rajasthan Royals - Mumbai Indians              5   \n",
       "1460                   Delhi Capitals - Kings XI Punjab              5   \n",
       "1461                   Delhi Capitals - Kings XI Punjab              5   \n",
       "1462        Sunrisers Hyderabad - Kolkata Knight Riders              6   \n",
       "1463        Sunrisers Hyderabad - Kolkata Knight Riders              6   \n",
       "1464  Royal Challengers Bangalore - Chennai Super Kings              6   \n",
       "1465  Royal Challengers Bangalore - Chennai Super Kings              6   \n",
       "1466                  Rajasthan Royals - Delhi Capitals              0   \n",
       "1467                  Rajasthan Royals - Delhi Capitals              0   \n",
       "1468          Chennai Super Kings - Sunrisers Hyderabad              1   \n",
       "1469          Chennai Super Kings - Sunrisers Hyderabad              1   \n",
       "1470      Royal Challengers Bangalore - Kings XI Punjab              2   \n",
       "1471      Royal Challengers Bangalore - Kings XI Punjab              2   \n",
       "1472           Kolkata Knight Riders - Rajasthan Royals              3   \n",
       "1473           Kolkata Knight Riders - Rajasthan Royals              3   \n",
       "1474               Chennai Super Kings - Mumbai Indians              4   \n",
       "1475               Chennai Super Kings - Mumbai Indians              4   \n",
       "1476             Rajasthan Royals - Sunrisers Hyderabad              5   \n",
       "1477             Rajasthan Royals - Sunrisers Hyderabad              5   \n",
       "1478       Delhi Capitals - Royal Challengers Bangalore              6   \n",
       "1479       Delhi Capitals - Royal Challengers Bangalore              6   \n",
       "1480             Kolkata Knight Riders - Mumbai Indians              6   \n",
       "1481             Kolkata Knight Riders - Mumbai Indians              6   \n",
       "1482              Sunrisers Hyderabad - Kings XI Punjab              0   \n",
       "1483              Sunrisers Hyderabad - Kings XI Punjab              0   \n",
       "1484     Royal Challengers Bangalore - Rajasthan Royals              1   \n",
       "1485     Royal Challengers Bangalore - Rajasthan Royals              1   \n",
       "1486               Chennai Super Kings - Delhi Capitals              2   \n",
       "1487               Chennai Super Kings - Delhi Capitals              2   \n",
       "\n",
       "      Match_Year        ...                                 Team Toss_Won  \\\n",
       "0           2008        ...                Kolkata Knight Riders        0   \n",
       "1           2008        ...          Royal Challengers Bangalore        1   \n",
       "2           2008        ...                  Chennai Super Kings        1   \n",
       "3           2008        ...                      Kings XI Punjab        0   \n",
       "4           2008        ...                     Rajasthan Royals        1   \n",
       "5           2008        ...                     Delhi Daredevils        0   \n",
       "6           2008        ...                       Mumbai Indians        1   \n",
       "7           2008        ...          Royal Challengers Bangalore        0   \n",
       "8           2008        ...                      Deccan Chargers        1   \n",
       "9           2008        ...                Kolkata Knight Riders        0   \n",
       "10          2008        ...                      Kings XI Punjab        1   \n",
       "11          2008        ...                     Rajasthan Royals        0   \n",
       "12          2008        ...                      Deccan Chargers        1   \n",
       "13          2008        ...                     Delhi Daredevils        0   \n",
       "14          2008        ...                  Chennai Super Kings        0   \n",
       "15          2008        ...                       Mumbai Indians        1   \n",
       "16          2008        ...                      Deccan Chargers        0   \n",
       "17          2008        ...                     Rajasthan Royals        1   \n",
       "18          2008        ...                      Kings XI Punjab        0   \n",
       "19          2008        ...                       Mumbai Indians        1   \n",
       "20          2008        ...          Royal Challengers Bangalore        0   \n",
       "21          2008        ...                     Rajasthan Royals        1   \n",
       "22          2008        ...                Kolkata Knight Riders        1   \n",
       "23          2008        ...                  Chennai Super Kings        0   \n",
       "24          2008        ...                       Mumbai Indians        0   \n",
       "25          2008        ...                      Deccan Chargers        1   \n",
       "26          2008        ...                     Delhi Daredevils        1   \n",
       "27          2008        ...                      Kings XI Punjab        0   \n",
       "28          2008        ...                  Chennai Super Kings        1   \n",
       "29          2008        ...          Royal Challengers Bangalore        0   \n",
       "...          ...        ...                                  ...      ...   \n",
       "1458        2019        ...                       Mumbai Indians        0   \n",
       "1459        2019        ...                     Rajasthan Royals        1   \n",
       "1460        2019        ...                      Kings XI Punjab        0   \n",
       "1461        2019        ...                       Delhi Capitals        1   \n",
       "1462        2019        ...                Kolkata Knight Riders        0   \n",
       "1463        2019        ...                  Sunrisers Hyderabad        1   \n",
       "1464        2019        ...          Royal Challengers Bangalore        0   \n",
       "1465        2019        ...                  Chennai Super Kings        1   \n",
       "1466        2019        ...                     Rajasthan Royals        0   \n",
       "1467        2019        ...                       Delhi Capitals        1   \n",
       "1468        2019        ...                  Sunrisers Hyderabad        0   \n",
       "1469        2019        ...                  Chennai Super Kings        1   \n",
       "1470        2019        ...          Royal Challengers Bangalore        0   \n",
       "1471        2019        ...                      Kings XI Punjab        1   \n",
       "1472        2019        ...                Kolkata Knight Riders        0   \n",
       "1473        2019        ...                     Rajasthan Royals        1   \n",
       "1474        2019        ...                       Mumbai Indians        0   \n",
       "1475        2019        ...                  Chennai Super Kings        1   \n",
       "1476        2019        ...                  Sunrisers Hyderabad        0   \n",
       "1477        2019        ...                     Rajasthan Royals        1   \n",
       "1478        2019        ...                       Delhi Capitals        1   \n",
       "1479        2019        ...          Royal Challengers Bangalore        0   \n",
       "1480        2019        ...                Kolkata Knight Riders        0   \n",
       "1481        2019        ...                       Mumbai Indians        1   \n",
       "1482        2019        ...                  Sunrisers Hyderabad        0   \n",
       "1483        2019        ...                      Kings XI Punjab        1   \n",
       "1484        2019        ...          Royal Challengers Bangalore        0   \n",
       "1485        2019        ...                     Rajasthan Royals        1   \n",
       "1486        2019        ...                  Chennai Super Kings        0   \n",
       "1487        2019        ...                       Delhi Capitals        1   \n",
       "\n",
       "      Total_Overs  Total_Score  Total_Wickets  Home Ground  \\\n",
       "0            19.6          222              3            0   \n",
       "1            15.2           82             10            1   \n",
       "2            19.6          240              5            0   \n",
       "3            19.6          207              4            1   \n",
       "4            19.6          129              8            0   \n",
       "5            15.1          132              1            1   \n",
       "6            19.6          165              7            1   \n",
       "7            19.5          166              5            0   \n",
       "8            18.4          110             10            0   \n",
       "9            18.6          112              5            1   \n",
       "10           19.7          166              8            0   \n",
       "11           18.1          168              4            1   \n",
       "12           19.7          142              8            1   \n",
       "13           13.1          143              1            0   \n",
       "14           19.6          208              5            1   \n",
       "15           19.7          202              7            0   \n",
       "16           19.7          214              5            1   \n",
       "17           19.5          217              7            0   \n",
       "18           19.6          182             10            1   \n",
       "19           19.6          116              9            0   \n",
       "20           19.7          135              8            1   \n",
       "21           17.1          138              3            0   \n",
       "22           19.7          147              9            0   \n",
       "23           16.6          152              1            1   \n",
       "24           19.6          154              7            1   \n",
       "25           11.6          155              0            0   \n",
       "26           19.6          158              8            0   \n",
       "27           19.3          162              6            1   \n",
       "28           19.6          178              5            0   \n",
       "29           19.4          165             10            1   \n",
       "...           ...          ...            ...          ...   \n",
       "1458         19.6          161              5            0   \n",
       "1459         19.1          162              5            1   \n",
       "1460         19.6          163              7            0   \n",
       "1461         19.4          166              5            1   \n",
       "1462         19.6          159              8            0   \n",
       "1463         14.6          161              1            1   \n",
       "1464         19.6          161              7            1   \n",
       "1465         19.6          160              8            0   \n",
       "1466         19.7          191              6            1   \n",
       "1467         19.2          193              4            0   \n",
       "1468         19.6          175              3            0   \n",
       "1469         19.5          176              4            1   \n",
       "1470         19.6          202              4            1   \n",
       "1471         19.6          185              7            0   \n",
       "1472         19.6          175              6            1   \n",
       "1473         19.2          177              7            0   \n",
       "1474         19.6          155              4            0   \n",
       "1475         17.4          109             10            1   \n",
       "1476         19.7          160              8            0   \n",
       "1477         19.1          161              3            1   \n",
       "1478         19.6          187              5            1   \n",
       "1479         19.7          171              7            0   \n",
       "1480         19.6          232              2            1   \n",
       "1481         19.6          198              7            0   \n",
       "1482         19.7          212              6            1   \n",
       "1483         19.6          167              8            0   \n",
       "1484          4.7           62              7            1   \n",
       "1485          3.2           41              1            0   \n",
       "1486         19.7          179              4            1   \n",
       "1487         16.2           99             10            0   \n",
       "\n",
       "      Prev_Run_Score_Rate  Prev_Run_Concede_Rate  Team_Codes  \\\n",
       "0                     NaN                    NaN         KKR   \n",
       "1                     NaN                    NaN         RCB   \n",
       "2                     NaN                    NaN         CSK   \n",
       "3                     NaN                    NaN        KXIP   \n",
       "4                     NaN                    NaN          RR   \n",
       "5                     NaN                    NaN          DD   \n",
       "6                     NaN                    NaN          MI   \n",
       "7                     NaN                    NaN         RCB   \n",
       "8                     NaN                    NaN          DC   \n",
       "9                     NaN                    NaN         KKR   \n",
       "10                    NaN                    NaN        KXIP   \n",
       "11                    NaN                    NaN          RR   \n",
       "12                    NaN                    NaN          DC   \n",
       "13                    NaN                    NaN          DD   \n",
       "14                    NaN                    NaN         CSK   \n",
       "15                    NaN                    NaN          MI   \n",
       "16                    NaN                    NaN          DC   \n",
       "17                    NaN                    NaN          RR   \n",
       "18                    NaN                    NaN        KXIP   \n",
       "19                    NaN                    NaN          MI   \n",
       "20                    NaN                    NaN         RCB   \n",
       "21                    NaN                    NaN          RR   \n",
       "22                    NaN                    NaN         KKR   \n",
       "23                    NaN                    NaN         CSK   \n",
       "24                    NaN                    NaN          MI   \n",
       "25                    NaN                    NaN          DC   \n",
       "26                    NaN                    NaN          DD   \n",
       "27                    NaN                    NaN        KXIP   \n",
       "28                    NaN                    NaN         CSK   \n",
       "29                    NaN                    NaN         RCB   \n",
       "...                   ...                    ...         ...   \n",
       "1458                  NaN                    NaN          MI   \n",
       "1459                  NaN                    NaN          RR   \n",
       "1460                  NaN                    NaN        KXIP   \n",
       "1461                  NaN                    NaN          DD   \n",
       "1462                  NaN                    NaN         KKR   \n",
       "1463                  NaN                    NaN          DC   \n",
       "1464                  NaN                    NaN         RCB   \n",
       "1465                  NaN                    NaN         CSK   \n",
       "1466                  NaN                    NaN          RR   \n",
       "1467                  NaN                    NaN          DD   \n",
       "1468                  NaN                    NaN          DC   \n",
       "1469                  NaN                    NaN         CSK   \n",
       "1470                  NaN                    NaN         RCB   \n",
       "1471                  NaN                    NaN        KXIP   \n",
       "1472                  NaN                    NaN         KKR   \n",
       "1473                  NaN                    NaN          RR   \n",
       "1474                  NaN                    NaN          MI   \n",
       "1475                  NaN                    NaN         CSK   \n",
       "1476                  NaN                    NaN          DC   \n",
       "1477                  NaN                    NaN          RR   \n",
       "1478                  NaN                    NaN          DD   \n",
       "1479                  NaN                    NaN         RCB   \n",
       "1480                  NaN                    NaN         KKR   \n",
       "1481                  NaN                    NaN          MI   \n",
       "1482                  NaN                    NaN          DC   \n",
       "1483                  NaN                    NaN        KXIP   \n",
       "1484                  NaN                    NaN         RCB   \n",
       "1485                  NaN                    NaN          RR   \n",
       "1486                  NaN                    NaN         CSK   \n",
       "1487                  NaN                    NaN          DD   \n",
       "\n",
       "     Bowling_Team_Codes  \n",
       "0                   RCB  \n",
       "1                   KKR  \n",
       "2                  KXIP  \n",
       "3                   CSK  \n",
       "4                    DD  \n",
       "5                    RR  \n",
       "6                   RCB  \n",
       "7                    MI  \n",
       "8                   KKR  \n",
       "9                    DC  \n",
       "10                   RR  \n",
       "11                 KXIP  \n",
       "12                   DD  \n",
       "13                   DC  \n",
       "14                   MI  \n",
       "15                  CSK  \n",
       "16                   RR  \n",
       "17                   DC  \n",
       "18                   MI  \n",
       "19                 KXIP  \n",
       "20                   RR  \n",
       "21                  RCB  \n",
       "22                  CSK  \n",
       "23                  KKR  \n",
       "24                   DC  \n",
       "25                   MI  \n",
       "26                 KXIP  \n",
       "27                   DD  \n",
       "28                  RCB  \n",
       "29                  CSK  \n",
       "...                 ...  \n",
       "1458                 RR  \n",
       "1459                 MI  \n",
       "1460                 DD  \n",
       "1461               KXIP  \n",
       "1462                 DC  \n",
       "1463                KKR  \n",
       "1464                CSK  \n",
       "1465                RCB  \n",
       "1466                 DD  \n",
       "1467                 RR  \n",
       "1468                CSK  \n",
       "1469                 DC  \n",
       "1470               KXIP  \n",
       "1471                RCB  \n",
       "1472                 RR  \n",
       "1473                KKR  \n",
       "1474                CSK  \n",
       "1475                 MI  \n",
       "1476                 RR  \n",
       "1477                 DC  \n",
       "1478                RCB  \n",
       "1479                 DD  \n",
       "1480                 MI  \n",
       "1481                KKR  \n",
       "1482               KXIP  \n",
       "1483                 DC  \n",
       "1484                 RR  \n",
       "1485                RCB  \n",
       "1486                 DD  \n",
       "1487                CSK  \n",
       "\n",
       "[1488 rows x 21 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "###  FUntion to define dictionary\n",
    "def Year_Dict_Teams(datadf,year, Inns):\n",
    "    dictteam={}\n",
    "    for i in range(len(datadf)):\n",
    "        myear=datadf.loc[i:i, 'Match_Year'].values[0]\n",
    "        mnum=datadf.loc[i:i, 'Match_Number'].values[0]\n",
    "        minns= datadf.loc[i:i, 'First_Innings'].values[0]\n",
    "        tc=datadf.loc[i:i, 'Team_Codes'].values[0]\n",
    "        #print(myear)\n",
    "        if(myear==year and minns==Inns ):\n",
    "            if(tc in dictteam):\n",
    "                dictteam[tc].append(mnum)\n",
    "            else:\n",
    "                dictteam[tc]=[mnum]\n",
    "    return(dictteam)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "dict_2008_First_Inn=Year_Dict_Teams(df1,2008,1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'CSK': [2, 8, 15, 20, 24, 26, 32, 37, 58],\n",
       " 'DC': [5, 7, 9, 18, 21, 30, 49, 55],\n",
       " 'DD': [14, 17, 28, 34, 39, 41],\n",
       " 'KKR': [1, 12, 16, 29, 33, 36, 40, 44, 46],\n",
       " 'KXIP': [6, 10, 22, 38, 47, 53, 57],\n",
       " 'MI': [4, 13, 23, 43, 50, 54],\n",
       " 'RCB': [11, 25, 31, 35, 45, 48, 52],\n",
       " 'RR': [3, 19, 27, 42, 51, 56]}"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dict_2008_First_Inn"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "dict_2008_First_Inn=Year_Dict_Teams(df1,2008,1)\n",
    "dict_2009_First_Inn=Year_Dict_Teams(df1,2009,1)\n",
    "dict_2010_First_Inn=Year_Dict_Teams(df1,2010,1)\n",
    "dict_2011_First_Inn=Year_Dict_Teams(df1,2011,1)\n",
    "dict_2012_First_Inn=Year_Dict_Teams(df1,2012,1)\n",
    "dict_2013_First_Inn=Year_Dict_Teams(df1,2013,1)\n",
    "dict_2014_First_Inn=Year_Dict_Teams(df1,2014,1)\n",
    "dict_2015_First_Inn=Year_Dict_Teams(df1,2015,1)\n",
    "dict_2016_First_Inn=Year_Dict_Teams(df1,2016,1)\n",
    "dict_2017_First_Inn=Year_Dict_Teams(df1,2017,1)\n",
    "dict_2018_First_Inn=Year_Dict_Teams(df1,2018,1)\n",
    "dict_2019_First_Inn=Year_Dict_Teams(df1,2019,1)\n",
    "dict_2008_Sec_Inn=Year_Dict_Teams(df1,2008,0)\n",
    "dict_2009_Sec_Inn=Year_Dict_Teams(df1,2009,0)\n",
    "dict_2010_Sec_Inn=Year_Dict_Teams(df1,2010,0)\n",
    "dict_2011_Sec_Inn=Year_Dict_Teams(df1,2011,0)\n",
    "dict_2012_Sec_Inn=Year_Dict_Teams(df1,2012,0)\n",
    "dict_2013_Sec_Inn=Year_Dict_Teams(df1,2013,0)\n",
    "dict_2014_Sec_Inn=Year_Dict_Teams(df1,2014,0)\n",
    "dict_2015_Sec_Inn=Year_Dict_Teams(df1,2015,0)\n",
    "dict_2016_Sec_Inn=Year_Dict_Teams(df1,2016,0)\n",
    "dict_2017_Sec_Inn=Year_Dict_Teams(df1,2017,0)\n",
    "dict_2018_Sec_Inn=Year_Dict_Teams(df1,2018,0)\n",
    "dict_2019_Sec_Inn=Year_Dict_Teams(df1,2019,0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Not Available'"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import numpy as np\n",
    "def get_Last_match_num(dict1,matchnum,tm):\n",
    "    matchlist=dict1[tm]\n",
    "    previous_matches=[]\n",
    "    for m in matchlist:\n",
    "        if(matchnum > m):\n",
    "            previous_matches.append(m)\n",
    "    if(len(previous_matches)!=0):\n",
    "        return(np.max(previous_matches))\n",
    "    else:\n",
    "        return('Not Available')\n",
    "    \n",
    "    \n",
    "get_Last_match_num(dict_2008_First_Inn,1,'KKR')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Rows-Processed, 0\n",
      "Rows-Processed, 100\n",
      "Rows-Processed, 200\n",
      "Rows-Processed, 300\n",
      "Rows-Processed, 400\n",
      "Rows-Processed, 500\n",
      "Rows-Processed, 600\n",
      "Rows-Processed, 700\n",
      "Rows-Processed, 800\n",
      "Rows-Processed, 900\n",
      "Rows-Processed, 1000\n",
      "Rows-Processed, 1100\n",
      "Rows-Processed, 1200\n",
      "Rows-Processed, 1300\n",
      "Rows-Processed, 1400\n"
     ]
    }
   ],
   "source": [
    "for i in range(len(df1)):   \n",
    "    myear=df1.loc[i:i, 'Match_Year'].values[0]\n",
    "    mnum=df1.loc[i:i, 'Match_Number'].values[0]\n",
    "    minns= df1.loc[i:i, 'First_Innings'].values[0]\n",
    "    tc=df1.loc[i:i, 'Team_Codes'].values[0]\n",
    "    bowltc=df1.loc[i:i, 'Bowling_Team_Codes'].values[0]\n",
    "# 2008\n",
    "    if(minns==1 and myear==2008):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2008_First_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2008_Sec_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "        \n",
    "    if(minns==0 and myear==2008):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2008_Sec_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2008_First_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "\n",
    "# 2009\n",
    "\n",
    "    if(minns==1 and myear==2009):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2009_First_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2009_Sec_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "        \n",
    "    if(minns==0 and myear==2009):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2009_Sec_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2009_First_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "\n",
    "\n",
    "# 2010\n",
    "\n",
    "    if(minns==1 and myear==2010):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2010_First_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2010_Sec_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "        \n",
    "    if(minns==0 and myear==2010):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2010_Sec_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2010_First_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "\n",
    "\n",
    "# 2011\n",
    "\n",
    "    if(minns==1 and myear==2011):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2011_First_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2011_Sec_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "        \n",
    "    if(minns==0 and myear==2011):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2011_Sec_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2011_First_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "\n",
    "\n",
    "# 2012\n",
    "\n",
    "    if(minns==1 and myear==2012):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2012_First_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2012_Sec_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "        \n",
    "    if(minns==0 and myear==2012):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2012_Sec_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2012_First_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "\n",
    "\n",
    "# 2013\n",
    "\n",
    "    if(minns==1 and myear==2013):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2013_First_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2013_Sec_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "        \n",
    "    if(minns==0 and myear==2013):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2013_Sec_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2013_First_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "\n",
    "\n",
    "# 2014\n",
    "\n",
    "    if(minns==1 and myear==2014):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2014_First_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2014_Sec_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "        \n",
    "    if(minns==0 and myear==2014):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2014_Sec_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2014_First_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "\n",
    "\n",
    "# 2015\n",
    "\n",
    "    if(minns==1 and myear==2015):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2015_First_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2015_Sec_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "        \n",
    "    if(minns==0 and myear==2015):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2015_Sec_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2015_First_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "\n",
    "\n",
    "# 2016\n",
    "\n",
    "    if(minns==1 and myear==2016):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2016_First_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2016_Sec_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "        \n",
    "    if(minns==0 and myear==2016):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2016_Sec_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2016_First_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "\n",
    "\n",
    "# 2017\n",
    "    if(minns==1 and myear==2017):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2017_First_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2017_Sec_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "        \n",
    "    if(minns==0 and myear==2017):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2017_Sec_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2017_First_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "\n",
    "\n",
    "# 2018\n",
    "    if(minns==1 and myear==2018):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2018_First_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2018_Sec_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "        \n",
    "    if(minns==0 and myear==2018):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2018_Sec_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2018_First_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "\n",
    "# 2019\n",
    "\n",
    "    if(minns==1 and myear==2019):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2019_First_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2019_Sec_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==1) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "        \n",
    "    if(minns==0 and myear==2019):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        prev_match_num_batting_team=get_Last_match_num(dict_2019_Sec_Inn,mnum,tc)\n",
    "        prev_match_num_bowling_team=get_Last_match_num(dict_2019_First_Inn,mnum,bowltc)\n",
    "        if(prev_match_num_batting_team!='Not Available'):\n",
    "            prev_match_score_rate_batting_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_batting_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_score_rate_batting_team=0\n",
    "        if(prev_match_num_bowling_team!='Not Available'):\n",
    "            prev_match_concede_rate_bowling_team=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) &(df1.Match_Number==prev_match_num_bowling_team)].loc[:,'Net_Run_Rate'].values[0]\n",
    "        else:\n",
    "            prev_match_concede_rate_bowling_team=0\n",
    "        df1.loc[i:i, 'Prev_Run_Score_Rate']=prev_match_score_rate_batting_team\n",
    "        df1.loc[i:i, 'Prev_Run_Concede_Rate']=prev_match_concede_rate_bowling_team\n",
    "    if(i%100==0):\n",
    "        print('Rows-Processed, '+str(i))\n",
    "\n",
    "   "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "10%5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "7\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "7"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(get_Last_match_num(dict_2008_First_Inn,9,'DC'))\n",
    "matchnum=9\n",
    "matchlist=dict_2008_First_Inn['DC']\n",
    "previous_matches_dc=[]\n",
    "for m in matchlist:\n",
    "    if(matchnum > m):\n",
    "        previous_matches_dc.append(m)\n",
    "previous_matches_dc\n",
    "np.max(previous_matches_dc)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>5_Over_Wicket</th>\n",
       "      <th>5_Over_score</th>\n",
       "      <th>First_Innings</th>\n",
       "      <th>Last_5_Over_Score</th>\n",
       "      <th>Last_5_Over_Wicket</th>\n",
       "      <th>Match_Number</th>\n",
       "      <th>Match_Stadium</th>\n",
       "      <th>Match_Teams</th>\n",
       "      <th>Match_Weekday</th>\n",
       "      <th>Match_Year</th>\n",
       "      <th>...</th>\n",
       "      <th>Team</th>\n",
       "      <th>Toss_Won</th>\n",
       "      <th>Total_Overs</th>\n",
       "      <th>Total_Score</th>\n",
       "      <th>Total_Wickets</th>\n",
       "      <th>Home Ground</th>\n",
       "      <th>Prev_Run_Score_Rate</th>\n",
       "      <th>Prev_Run_Concede_Rate</th>\n",
       "      <th>Team_Codes</th>\n",
       "      <th>Bowling_Team_Codes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>69</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Deccan Chargers - Delhi Daredevils</td>\n",
       "      <td>1</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>1</td>\n",
       "      <td>19.7</td>\n",
       "      <td>142</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>5.98</td>\n",
       "      <td>6.58</td>\n",
       "      <td>DC</td>\n",
       "      <td>DD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Deccan Chargers - Delhi Daredevils</td>\n",
       "      <td>1</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>0</td>\n",
       "      <td>13.1</td>\n",
       "      <td>143</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>8.74</td>\n",
       "      <td>6.02</td>\n",
       "      <td>DD</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2</td>\n",
       "      <td>48</td>\n",
       "      <td>1</td>\n",
       "      <td>66</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Deccan Chargers - Rajasthan Royals</td>\n",
       "      <td>3</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>0</td>\n",
       "      <td>19.7</td>\n",
       "      <td>214</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>7.21</td>\n",
       "      <td>8.43</td>\n",
       "      <td>DC</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1</td>\n",
       "      <td>57</td>\n",
       "      <td>0</td>\n",
       "      <td>58</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Deccan Chargers - Rajasthan Royals</td>\n",
       "      <td>3</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>19.5</td>\n",
       "      <td>217</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>9.28</td>\n",
       "      <td>10.92</td>\n",
       "      <td>RR</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>Punjab Cricket Association Stadium, Mohali</td>\n",
       "      <td>Kings XI Punjab - Mumbai Indians</td>\n",
       "      <td>4</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>182</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>8.43</td>\n",
       "      <td>10.61</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>Punjab Cricket Association Stadium, Mohali</td>\n",
       "      <td>Kings XI Punjab - Mumbai Indians</td>\n",
       "      <td>4</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>116</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>10.25</td>\n",
       "      <td>9.28</td>\n",
       "      <td>MI</td>\n",
       "      <td>KXIP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>76</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Chennai Super Kings</td>\n",
       "      <td>0</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>178</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>10.61</td>\n",
       "      <td>8.42</td>\n",
       "      <td>CSK</td>\n",
       "      <td>RCB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>7</td>\n",
       "      <td>15</td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Chennai Super Kings</td>\n",
       "      <td>0</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>19.4</td>\n",
       "      <td>165</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>8.51</td>\n",
       "      <td>10.25</td>\n",
       "      <td>RCB</td>\n",
       "      <td>CSK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>Kolkata Knight Riders - Mumbai Indians</td>\n",
       "      <td>1</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>1</td>\n",
       "      <td>19.7</td>\n",
       "      <td>137</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>7.46</td>\n",
       "      <td>9.29</td>\n",
       "      <td>KKR</td>\n",
       "      <td>MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>3</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>Kolkata Knight Riders - Mumbai Indians</td>\n",
       "      <td>1</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>0</td>\n",
       "      <td>18.4</td>\n",
       "      <td>138</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>5.92</td>\n",
       "      <td>9.16</td>\n",
       "      <td>MI</td>\n",
       "      <td>KKR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>17</td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>Delhi Daredevils - Royal Challengers Bangalore</td>\n",
       "      <td>2</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>191</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>8.06</td>\n",
       "      <td>9.08</td>\n",
       "      <td>DD</td>\n",
       "      <td>RCB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>3</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>47</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>Delhi Daredevils - Royal Challengers Bangalore</td>\n",
       "      <td>2</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>181</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>8.51</td>\n",
       "      <td>8.39</td>\n",
       "      <td>RCB</td>\n",
       "      <td>DD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>1</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>2</td>\n",
       "      <td>18</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Deccan Chargers - Kings XI Punjab</td>\n",
       "      <td>3</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>164</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>10.86</td>\n",
       "      <td>8.06</td>\n",
       "      <td>DC</td>\n",
       "      <td>KXIP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>0</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Deccan Chargers - Kings XI Punjab</td>\n",
       "      <td>3</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>1</td>\n",
       "      <td>18.6</td>\n",
       "      <td>167</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>8.39</td>\n",
       "      <td>11.13</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>1</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>54</td>\n",
       "      <td>3</td>\n",
       "      <td>19</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Kolkata Knight Riders</td>\n",
       "      <td>3</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>19.7</td>\n",
       "      <td>196</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>6.58</td>\n",
       "      <td>5.98</td>\n",
       "      <td>RR</td>\n",
       "      <td>KKR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>5</td>\n",
       "      <td>19</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Kolkata Knight Riders</td>\n",
       "      <td>3</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>19.1</td>\n",
       "      <td>151</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>6.02</td>\n",
       "      <td>8.74</td>\n",
       "      <td>KKR</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>1</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>3</td>\n",
       "      <td>20</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Delhi Daredevils</td>\n",
       "      <td>4</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>169</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>9.08</td>\n",
       "      <td>7.21</td>\n",
       "      <td>CSK</td>\n",
       "      <td>DD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>0</td>\n",
       "      <td>54</td>\n",
       "      <td>0</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Delhi Daredevils</td>\n",
       "      <td>4</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>0</td>\n",
       "      <td>18.7</td>\n",
       "      <td>172</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>10.92</td>\n",
       "      <td>8.51</td>\n",
       "      <td>DD</td>\n",
       "      <td>CSK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>6</td>\n",
       "      <td>21</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Deccan Chargers - Royal Challengers Bangalore</td>\n",
       "      <td>6</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>165</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>8.37</td>\n",
       "      <td>9.74</td>\n",
       "      <td>DC</td>\n",
       "      <td>RCB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>1</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>65</td>\n",
       "      <td>2</td>\n",
       "      <td>21</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Deccan Chargers - Royal Challengers Bangalore</td>\n",
       "      <td>6</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>18.6</td>\n",
       "      <td>171</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>9.23</td>\n",
       "      <td>8.98</td>\n",
       "      <td>RCB</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "      <td>1</td>\n",
       "      <td>59</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>Punjab Cricket Association Stadium, Mohali</td>\n",
       "      <td>Kings XI Punjab - Kolkata Knight Riders</td>\n",
       "      <td>5</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>178</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>9.29</td>\n",
       "      <td>9.95</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>KKR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>4</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>68</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>Punjab Cricket Association Stadium, Mohali</td>\n",
       "      <td>Kings XI Punjab - Kolkata Knight Riders</td>\n",
       "      <td>5</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>169</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>7.91</td>\n",
       "      <td>5.92</td>\n",
       "      <td>KKR</td>\n",
       "      <td>KXIP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>23</td>\n",
       "      <td>Dr DY Patil Sports Academy</td>\n",
       "      <td>Mumbai Indians - Delhi Daredevils</td>\n",
       "      <td>6</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>162</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>7.86</td>\n",
       "      <td>8.62</td>\n",
       "      <td>MI</td>\n",
       "      <td>DD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>5</td>\n",
       "      <td>23</td>\n",
       "      <td>Dr DY Patil Sports Academy</td>\n",
       "      <td>Mumbai Indians - Delhi Daredevils</td>\n",
       "      <td>6</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>1</td>\n",
       "      <td>18.5</td>\n",
       "      <td>133</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>9.20</td>\n",
       "      <td>13.36</td>\n",
       "      <td>DD</td>\n",
       "      <td>MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>3</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>3</td>\n",
       "      <td>24</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Chennai Super Kings</td>\n",
       "      <td>6</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>1</td>\n",
       "      <td>18.6</td>\n",
       "      <td>109</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>8.62</td>\n",
       "      <td>6.85</td>\n",
       "      <td>CSK</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Chennai Super Kings</td>\n",
       "      <td>6</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>0</td>\n",
       "      <td>14.2</td>\n",
       "      <td>110</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>8.07</td>\n",
       "      <td>9.20</td>\n",
       "      <td>RR</td>\n",
       "      <td>CSK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>3</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>6</td>\n",
       "      <td>25</td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>19.2</td>\n",
       "      <td>126</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>6.85</td>\n",
       "      <td>8.37</td>\n",
       "      <td>RCB</td>\n",
       "      <td>KXIP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>1</td>\n",
       "      <td>18.3</td>\n",
       "      <td>127</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>8.98</td>\n",
       "      <td>8.07</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>RCB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>58</td>\n",
       "      <td>1</td>\n",
       "      <td>26</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Deccan Chargers</td>\n",
       "      <td>1</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>144</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>5.86</td>\n",
       "      <td>7.86</td>\n",
       "      <td>CSK</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>26</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Deccan Chargers</td>\n",
       "      <td>1</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>1</td>\n",
       "      <td>17.6</td>\n",
       "      <td>148</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>13.36</td>\n",
       "      <td>7.75</td>\n",
       "      <td>DC</td>\n",
       "      <td>CSK</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>1458</th>\n",
       "      <td>1</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>49</td>\n",
       "      <td>2</td>\n",
       "      <td>36</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Mumbai Indians</td>\n",
       "      <td>5</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>161</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>8.48</td>\n",
       "      <td>9.29</td>\n",
       "      <td>MI</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1459</th>\n",
       "      <td>1</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>2</td>\n",
       "      <td>36</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Mumbai Indians</td>\n",
       "      <td>5</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>19.1</td>\n",
       "      <td>162</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>8.67</td>\n",
       "      <td>6.53</td>\n",
       "      <td>RR</td>\n",
       "      <td>MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1460</th>\n",
       "      <td>2</td>\n",
       "      <td>46</td>\n",
       "      <td>1</td>\n",
       "      <td>45</td>\n",
       "      <td>2</td>\n",
       "      <td>37</td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>Delhi Capitals - Kings XI Punjab</td>\n",
       "      <td>5</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>163</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>9.29</td>\n",
       "      <td>8.48</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>DD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1461</th>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>3</td>\n",
       "      <td>37</td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>Delhi Capitals - Kings XI Punjab</td>\n",
       "      <td>5</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>1</td>\n",
       "      <td>19.4</td>\n",
       "      <td>166</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>6.53</td>\n",
       "      <td>8.67</td>\n",
       "      <td>DD</td>\n",
       "      <td>KXIP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1462</th>\n",
       "      <td>2</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>4</td>\n",
       "      <td>38</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Sunrisers Hyderabad - Kolkata Knight Riders</td>\n",
       "      <td>6</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>159</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>8.17</td>\n",
       "      <td>6.73</td>\n",
       "      <td>KKR</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1463</th>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Sunrisers Hyderabad - Kolkata Knight Riders</td>\n",
       "      <td>6</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>14.6</td>\n",
       "      <td>161</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8.30</td>\n",
       "      <td>8.35</td>\n",
       "      <td>DC</td>\n",
       "      <td>KKR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1464</th>\n",
       "      <td>1</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>4</td>\n",
       "      <td>39</td>\n",
       "      <td>M.Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Chennai Super Kings</td>\n",
       "      <td>6</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>161</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>10.87</td>\n",
       "      <td>8.17</td>\n",
       "      <td>RCB</td>\n",
       "      <td>CSK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1465</th>\n",
       "      <td>3</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>68</td>\n",
       "      <td>3</td>\n",
       "      <td>39</td>\n",
       "      <td>M.Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Chennai Super Kings</td>\n",
       "      <td>6</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>160</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>8.35</td>\n",
       "      <td>10.36</td>\n",
       "      <td>CSK</td>\n",
       "      <td>RCB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1466</th>\n",
       "      <td>1</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>4</td>\n",
       "      <td>40</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Delhi Capitals</td>\n",
       "      <td>0</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>0</td>\n",
       "      <td>19.7</td>\n",
       "      <td>191</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>7.70</td>\n",
       "      <td>8.32</td>\n",
       "      <td>RR</td>\n",
       "      <td>DD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1467</th>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>51</td>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Delhi Capitals</td>\n",
       "      <td>0</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>1</td>\n",
       "      <td>19.2</td>\n",
       "      <td>193</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>8.56</td>\n",
       "      <td>7.83</td>\n",
       "      <td>DD</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1468</th>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>175</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>7.65</td>\n",
       "      <td>8.21</td>\n",
       "      <td>DC</td>\n",
       "      <td>CSK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1469</th>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>41</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>1</td>\n",
       "      <td>19.5</td>\n",
       "      <td>176</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>8.16</td>\n",
       "      <td>7.74</td>\n",
       "      <td>CSK</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1470</th>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>M.Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Kings XI Punjab</td>\n",
       "      <td>2</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>202</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>8.21</td>\n",
       "      <td>7.65</td>\n",
       "      <td>RCB</td>\n",
       "      <td>KXIP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1471</th>\n",
       "      <td>1</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>4</td>\n",
       "      <td>42</td>\n",
       "      <td>M.Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Kings XI Punjab</td>\n",
       "      <td>2</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>185</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>7.74</td>\n",
       "      <td>8.16</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>RCB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1472</th>\n",
       "      <td>2</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>75</td>\n",
       "      <td>2</td>\n",
       "      <td>43</td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>Kolkata Knight Riders - Rajasthan Royals</td>\n",
       "      <td>3</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>175</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>8.11</td>\n",
       "      <td>8.21</td>\n",
       "      <td>KKR</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1473</th>\n",
       "      <td>0</td>\n",
       "      <td>53</td>\n",
       "      <td>0</td>\n",
       "      <td>55</td>\n",
       "      <td>2</td>\n",
       "      <td>43</td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>Kolkata Knight Riders - Rajasthan Royals</td>\n",
       "      <td>3</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>19.2</td>\n",
       "      <td>177</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>8.48</td>\n",
       "      <td>11.03</td>\n",
       "      <td>RR</td>\n",
       "      <td>KKR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1474</th>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>1</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Mumbai Indians</td>\n",
       "      <td>4</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>155</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>8.21</td>\n",
       "      <td>8.93</td>\n",
       "      <td>MI</td>\n",
       "      <td>CSK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1475</th>\n",
       "      <td>3</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>4</td>\n",
       "      <td>44</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Mumbai Indians</td>\n",
       "      <td>4</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>1</td>\n",
       "      <td>17.4</td>\n",
       "      <td>109</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>9.03</td>\n",
       "      <td>8.48</td>\n",
       "      <td>CSK</td>\n",
       "      <td>MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1476</th>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>1</td>\n",
       "      <td>39</td>\n",
       "      <td>5</td>\n",
       "      <td>45</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Sunrisers Hyderabad</td>\n",
       "      <td>5</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>0</td>\n",
       "      <td>19.7</td>\n",
       "      <td>160</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>8.93</td>\n",
       "      <td>8.93</td>\n",
       "      <td>DC</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1477</th>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>45</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>Rajasthan Royals - Sunrisers Hyderabad</td>\n",
       "      <td>5</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>19.1</td>\n",
       "      <td>161</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>9.22</td>\n",
       "      <td>9.03</td>\n",
       "      <td>RR</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1478</th>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>1</td>\n",
       "      <td>60</td>\n",
       "      <td>2</td>\n",
       "      <td>46</td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>Delhi Capitals - Royal Challengers Bangalore</td>\n",
       "      <td>6</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>187</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>7.87</td>\n",
       "      <td>8.83</td>\n",
       "      <td>DD</td>\n",
       "      <td>RCB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1479</th>\n",
       "      <td>0</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>2</td>\n",
       "      <td>46</td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>Delhi Capitals - Royal Challengers Bangalore</td>\n",
       "      <td>6</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>19.7</td>\n",
       "      <td>171</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>9.06</td>\n",
       "      <td>6.24</td>\n",
       "      <td>RCB</td>\n",
       "      <td>DD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1480</th>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "      <td>1</td>\n",
       "      <td>75</td>\n",
       "      <td>1</td>\n",
       "      <td>47</td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>Kolkata Knight Riders - Mumbai Indians</td>\n",
       "      <td>6</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>232</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>8.93</td>\n",
       "      <td>8.72</td>\n",
       "      <td>KKR</td>\n",
       "      <td>MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1481</th>\n",
       "      <td>2</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>58</td>\n",
       "      <td>2</td>\n",
       "      <td>47</td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>Kolkata Knight Riders - Mumbai Indians</td>\n",
       "      <td>6</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>198</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>9.20</td>\n",
       "      <td>9.22</td>\n",
       "      <td>MI</td>\n",
       "      <td>KKR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1482</th>\n",
       "      <td>0</td>\n",
       "      <td>66</td>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>5</td>\n",
       "      <td>48</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Sunrisers Hyderabad - Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>0</td>\n",
       "      <td>19.7</td>\n",
       "      <td>212</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>8.12</td>\n",
       "      <td>10.31</td>\n",
       "      <td>DC</td>\n",
       "      <td>KXIP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1483</th>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>44</td>\n",
       "      <td>3</td>\n",
       "      <td>48</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>Sunrisers Hyderabad - Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>167</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>9.44</td>\n",
       "      <td>8.43</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1484</th>\n",
       "      <td>7</td>\n",
       "      <td>62</td>\n",
       "      <td>1</td>\n",
       "      <td>62</td>\n",
       "      <td>7</td>\n",
       "      <td>49</td>\n",
       "      <td>M.Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>62</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>10.31</td>\n",
       "      <td>8.12</td>\n",
       "      <td>RCB</td>\n",
       "      <td>RR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1485</th>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>41</td>\n",
       "      <td>1</td>\n",
       "      <td>49</td>\n",
       "      <td>M.Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore - Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>41</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>8.43</td>\n",
       "      <td>9.44</td>\n",
       "      <td>RR</td>\n",
       "      <td>RCB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1486</th>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>77</td>\n",
       "      <td>1</td>\n",
       "      <td>50</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Delhi Capitals</td>\n",
       "      <td>2</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>0</td>\n",
       "      <td>19.7</td>\n",
       "      <td>179</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>6.73</td>\n",
       "      <td>9.70</td>\n",
       "      <td>CSK</td>\n",
       "      <td>DD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1487</th>\n",
       "      <td>1</td>\n",
       "      <td>49</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>50</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>Chennai Super Kings - Delhi Capitals</td>\n",
       "      <td>2</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>1</td>\n",
       "      <td>16.2</td>\n",
       "      <td>99</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>10.05</td>\n",
       "      <td>8.30</td>\n",
       "      <td>DD</td>\n",
       "      <td>CSK</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1228 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      5_Over_Wicket  5_Over_score  First_Innings  Last_5_Over_Score  \\\n",
       "12                1            23              1                 69   \n",
       "13                1            37              0                  0   \n",
       "16                2            48              1                 66   \n",
       "17                1            57              0                 58   \n",
       "18                1            43              1                 44   \n",
       "19                2            34              0                 15   \n",
       "28                1            25              1                 76   \n",
       "29                1            32              0                 33   \n",
       "30                2            38              1                 50   \n",
       "31                3            29              0                 28   \n",
       "32                1            53              1                 40   \n",
       "33                3            48              0                 47   \n",
       "34                1            38              1                 53   \n",
       "35                0            37              0                 38   \n",
       "36                1            38              1                 54   \n",
       "37                2            44              0                 23   \n",
       "38                1            37              1                 43   \n",
       "39                0            54              0                 30   \n",
       "40                0            34              1                 42   \n",
       "41                1            36              0                 65   \n",
       "42                1            44              1                 59   \n",
       "43                4            29              0                 68   \n",
       "44                0            35              1                 50   \n",
       "45                2            29              0                 19   \n",
       "46                3            30              1                 18   \n",
       "47                0            34              0                  0   \n",
       "48                3            19              1                 29   \n",
       "49                1            44              0                 18   \n",
       "50                2            31              1                 58   \n",
       "51                1            30              0                 33   \n",
       "...             ...           ...            ...                ...   \n",
       "1458              1            38              1                 49   \n",
       "1459              1            48              0                 34   \n",
       "1460              2            46              1                 45   \n",
       "1461              1            52              0                 38   \n",
       "1462              2            53              1                 43   \n",
       "1463              0            52              0                  0   \n",
       "1464              1            33              1                 43   \n",
       "1465              3            23              0                 68   \n",
       "1466              1            38              1                 41   \n",
       "1467              0            45              0                 51   \n",
       "1468              1            43              1                 41   \n",
       "1469              1            27              0                 41   \n",
       "1470              1            52              1                 80   \n",
       "1471              1            56              0                 42   \n",
       "1472              2            31              1                 75   \n",
       "1473              0            53              0                 55   \n",
       "1474              1            41              1                 50   \n",
       "1475              3            35              0                 21   \n",
       "1476              1            41              1                 39   \n",
       "1477              0            40              0                 29   \n",
       "1478              1            52              1                 60   \n",
       "1479              0            56              0                 45   \n",
       "1480              0            39              1                 75   \n",
       "1481              2            29              0                 58   \n",
       "1482              0            66              1                 53   \n",
       "1483              1            40              0                 44   \n",
       "1484              7            62              1                 62   \n",
       "1485              1            41              0                 41   \n",
       "1486              1            17              1                 77   \n",
       "1487              1            49              0                  7   \n",
       "\n",
       "      Last_5_Over_Wicket  Match_Number  \\\n",
       "12                     3             7   \n",
       "13                     0             7   \n",
       "16                     2             9   \n",
       "17                     4             9   \n",
       "18                     6            10   \n",
       "19                     2            10   \n",
       "28                     2            15   \n",
       "29                     7            15   \n",
       "30                     2            16   \n",
       "31                     0            16   \n",
       "32                     3            17   \n",
       "33                     2            17   \n",
       "34                     2            18   \n",
       "35                     0            18   \n",
       "36                     3            19   \n",
       "37                     5            19   \n",
       "38                     3            20   \n",
       "39                     0            20   \n",
       "40                     6            21   \n",
       "41                     2            21   \n",
       "42                     1            22   \n",
       "43                     1            22   \n",
       "44                     3            23   \n",
       "45                     5            23   \n",
       "46                     3            24   \n",
       "47                     0            24   \n",
       "48                     6            25   \n",
       "49                     0            25   \n",
       "50                     1            26   \n",
       "51                     1            26   \n",
       "...                  ...           ...   \n",
       "1458                   2            36   \n",
       "1459                   2            36   \n",
       "1460                   2            37   \n",
       "1461                   3            37   \n",
       "1462                   4            38   \n",
       "1463                   0            38   \n",
       "1464                   4            39   \n",
       "1465                   3            39   \n",
       "1466                   4            40   \n",
       "1467                   2            40   \n",
       "1468                   1            41   \n",
       "1469                   2            41   \n",
       "1470                   0            42   \n",
       "1471                   4            42   \n",
       "1472                   2            43   \n",
       "1473                   2            43   \n",
       "1474                   1            44   \n",
       "1475                   4            44   \n",
       "1476                   5            45   \n",
       "1477                   1            45   \n",
       "1478                   2            46   \n",
       "1479                   2            46   \n",
       "1480                   1            47   \n",
       "1481                   2            47   \n",
       "1482                   5            48   \n",
       "1483                   3            48   \n",
       "1484                   7            49   \n",
       "1485                   1            49   \n",
       "1486                   1            50   \n",
       "1487                   2            50   \n",
       "\n",
       "                                   Match_Stadium  \\\n",
       "12     Rajiv Gandhi International Stadium, Uppal   \n",
       "13     Rajiv Gandhi International Stadium, Uppal   \n",
       "16     Rajiv Gandhi International Stadium, Uppal   \n",
       "17     Rajiv Gandhi International Stadium, Uppal   \n",
       "18    Punjab Cricket Association Stadium, Mohali   \n",
       "19    Punjab Cricket Association Stadium, Mohali   \n",
       "28                         M Chinnaswamy Stadium   \n",
       "29                         M Chinnaswamy Stadium   \n",
       "30                                  Eden Gardens   \n",
       "31                                  Eden Gardens   \n",
       "32                              Feroz Shah Kotla   \n",
       "33                              Feroz Shah Kotla   \n",
       "34     Rajiv Gandhi International Stadium, Uppal   \n",
       "35     Rajiv Gandhi International Stadium, Uppal   \n",
       "36                        Sawai Mansingh Stadium   \n",
       "37                        Sawai Mansingh Stadium   \n",
       "38               MA Chidambaram Stadium, Chepauk   \n",
       "39               MA Chidambaram Stadium, Chepauk   \n",
       "40     Rajiv Gandhi International Stadium, Uppal   \n",
       "41     Rajiv Gandhi International Stadium, Uppal   \n",
       "42    Punjab Cricket Association Stadium, Mohali   \n",
       "43    Punjab Cricket Association Stadium, Mohali   \n",
       "44                    Dr DY Patil Sports Academy   \n",
       "45                    Dr DY Patil Sports Academy   \n",
       "46                        Sawai Mansingh Stadium   \n",
       "47                        Sawai Mansingh Stadium   \n",
       "48                         M Chinnaswamy Stadium   \n",
       "49                         M Chinnaswamy Stadium   \n",
       "50               MA Chidambaram Stadium, Chepauk   \n",
       "51               MA Chidambaram Stadium, Chepauk   \n",
       "...                                          ...   \n",
       "1458                      Sawai Mansingh Stadium   \n",
       "1459                      Sawai Mansingh Stadium   \n",
       "1460                            Feroz Shah Kotla   \n",
       "1461                            Feroz Shah Kotla   \n",
       "1462   Rajiv Gandhi International Stadium, Uppal   \n",
       "1463   Rajiv Gandhi International Stadium, Uppal   \n",
       "1464                       M.Chinnaswamy Stadium   \n",
       "1465                       M.Chinnaswamy Stadium   \n",
       "1466                      Sawai Mansingh Stadium   \n",
       "1467                      Sawai Mansingh Stadium   \n",
       "1468             MA Chidambaram Stadium, Chepauk   \n",
       "1469             MA Chidambaram Stadium, Chepauk   \n",
       "1470                       M.Chinnaswamy Stadium   \n",
       "1471                       M.Chinnaswamy Stadium   \n",
       "1472                                Eden Gardens   \n",
       "1473                                Eden Gardens   \n",
       "1474             MA Chidambaram Stadium, Chepauk   \n",
       "1475             MA Chidambaram Stadium, Chepauk   \n",
       "1476                      Sawai Mansingh Stadium   \n",
       "1477                      Sawai Mansingh Stadium   \n",
       "1478                            Feroz Shah Kotla   \n",
       "1479                            Feroz Shah Kotla   \n",
       "1480                                Eden Gardens   \n",
       "1481                                Eden Gardens   \n",
       "1482   Rajiv Gandhi International Stadium, Uppal   \n",
       "1483   Rajiv Gandhi International Stadium, Uppal   \n",
       "1484                       M.Chinnaswamy Stadium   \n",
       "1485                       M.Chinnaswamy Stadium   \n",
       "1486             MA Chidambaram Stadium, Chepauk   \n",
       "1487             MA Chidambaram Stadium, Chepauk   \n",
       "\n",
       "                                            Match_Teams  Match_Weekday  \\\n",
       "12                   Deccan Chargers - Delhi Daredevils              1   \n",
       "13                   Deccan Chargers - Delhi Daredevils              1   \n",
       "16                   Deccan Chargers - Rajasthan Royals              3   \n",
       "17                   Deccan Chargers - Rajasthan Royals              3   \n",
       "18                     Kings XI Punjab - Mumbai Indians              4   \n",
       "19                     Kings XI Punjab - Mumbai Indians              4   \n",
       "28    Royal Challengers Bangalore - Chennai Super Kings              0   \n",
       "29    Royal Challengers Bangalore - Chennai Super Kings              0   \n",
       "30               Kolkata Knight Riders - Mumbai Indians              1   \n",
       "31               Kolkata Knight Riders - Mumbai Indians              1   \n",
       "32       Delhi Daredevils - Royal Challengers Bangalore              2   \n",
       "33       Delhi Daredevils - Royal Challengers Bangalore              2   \n",
       "34                    Deccan Chargers - Kings XI Punjab              3   \n",
       "35                    Deccan Chargers - Kings XI Punjab              3   \n",
       "36             Rajasthan Royals - Kolkata Knight Riders              3   \n",
       "37             Rajasthan Royals - Kolkata Knight Riders              3   \n",
       "38               Chennai Super Kings - Delhi Daredevils              4   \n",
       "39               Chennai Super Kings - Delhi Daredevils              4   \n",
       "40        Deccan Chargers - Royal Challengers Bangalore              6   \n",
       "41        Deccan Chargers - Royal Challengers Bangalore              6   \n",
       "42              Kings XI Punjab - Kolkata Knight Riders              5   \n",
       "43              Kings XI Punjab - Kolkata Knight Riders              5   \n",
       "44                    Mumbai Indians - Delhi Daredevils              6   \n",
       "45                    Mumbai Indians - Delhi Daredevils              6   \n",
       "46               Rajasthan Royals - Chennai Super Kings              6   \n",
       "47               Rajasthan Royals - Chennai Super Kings              6   \n",
       "48        Royal Challengers Bangalore - Kings XI Punjab              0   \n",
       "49        Royal Challengers Bangalore - Kings XI Punjab              0   \n",
       "50                Chennai Super Kings - Deccan Chargers              1   \n",
       "51                Chennai Super Kings - Deccan Chargers              1   \n",
       "...                                                 ...            ...   \n",
       "1458                  Rajasthan Royals - Mumbai Indians              5   \n",
       "1459                  Rajasthan Royals - Mumbai Indians              5   \n",
       "1460                   Delhi Capitals - Kings XI Punjab              5   \n",
       "1461                   Delhi Capitals - Kings XI Punjab              5   \n",
       "1462        Sunrisers Hyderabad - Kolkata Knight Riders              6   \n",
       "1463        Sunrisers Hyderabad - Kolkata Knight Riders              6   \n",
       "1464  Royal Challengers Bangalore - Chennai Super Kings              6   \n",
       "1465  Royal Challengers Bangalore - Chennai Super Kings              6   \n",
       "1466                  Rajasthan Royals - Delhi Capitals              0   \n",
       "1467                  Rajasthan Royals - Delhi Capitals              0   \n",
       "1468          Chennai Super Kings - Sunrisers Hyderabad              1   \n",
       "1469          Chennai Super Kings - Sunrisers Hyderabad              1   \n",
       "1470      Royal Challengers Bangalore - Kings XI Punjab              2   \n",
       "1471      Royal Challengers Bangalore - Kings XI Punjab              2   \n",
       "1472           Kolkata Knight Riders - Rajasthan Royals              3   \n",
       "1473           Kolkata Knight Riders - Rajasthan Royals              3   \n",
       "1474               Chennai Super Kings - Mumbai Indians              4   \n",
       "1475               Chennai Super Kings - Mumbai Indians              4   \n",
       "1476             Rajasthan Royals - Sunrisers Hyderabad              5   \n",
       "1477             Rajasthan Royals - Sunrisers Hyderabad              5   \n",
       "1478       Delhi Capitals - Royal Challengers Bangalore              6   \n",
       "1479       Delhi Capitals - Royal Challengers Bangalore              6   \n",
       "1480             Kolkata Knight Riders - Mumbai Indians              6   \n",
       "1481             Kolkata Knight Riders - Mumbai Indians              6   \n",
       "1482              Sunrisers Hyderabad - Kings XI Punjab              0   \n",
       "1483              Sunrisers Hyderabad - Kings XI Punjab              0   \n",
       "1484     Royal Challengers Bangalore - Rajasthan Royals              1   \n",
       "1485     Royal Challengers Bangalore - Rajasthan Royals              1   \n",
       "1486               Chennai Super Kings - Delhi Capitals              2   \n",
       "1487               Chennai Super Kings - Delhi Capitals              2   \n",
       "\n",
       "      Match_Year        ...                                 Team Toss_Won  \\\n",
       "12          2008        ...                      Deccan Chargers        1   \n",
       "13          2008        ...                     Delhi Daredevils        0   \n",
       "16          2008        ...                      Deccan Chargers        0   \n",
       "17          2008        ...                     Rajasthan Royals        1   \n",
       "18          2008        ...                      Kings XI Punjab        0   \n",
       "19          2008        ...                       Mumbai Indians        1   \n",
       "28          2008        ...                  Chennai Super Kings        1   \n",
       "29          2008        ...          Royal Challengers Bangalore        0   \n",
       "30          2008        ...                Kolkata Knight Riders        1   \n",
       "31          2008        ...                       Mumbai Indians        0   \n",
       "32          2008        ...                     Delhi Daredevils        0   \n",
       "33          2008        ...          Royal Challengers Bangalore        1   \n",
       "34          2008        ...                      Deccan Chargers        0   \n",
       "35          2008        ...                      Kings XI Punjab        1   \n",
       "36          2008        ...                     Rajasthan Royals        1   \n",
       "37          2008        ...                Kolkata Knight Riders        0   \n",
       "38          2008        ...                  Chennai Super Kings        1   \n",
       "39          2008        ...                     Delhi Daredevils        0   \n",
       "40          2008        ...                      Deccan Chargers        1   \n",
       "41          2008        ...          Royal Challengers Bangalore        0   \n",
       "42          2008        ...                      Kings XI Punjab        1   \n",
       "43          2008        ...                Kolkata Knight Riders        0   \n",
       "44          2008        ...                       Mumbai Indians        0   \n",
       "45          2008        ...                     Delhi Daredevils        1   \n",
       "46          2008        ...                  Chennai Super Kings        1   \n",
       "47          2008        ...                     Rajasthan Royals        0   \n",
       "48          2008        ...          Royal Challengers Bangalore        0   \n",
       "49          2008        ...                      Kings XI Punjab        1   \n",
       "50          2008        ...                  Chennai Super Kings        0   \n",
       "51          2008        ...                      Deccan Chargers        1   \n",
       "...          ...        ...                                  ...      ...   \n",
       "1458        2019        ...                       Mumbai Indians        0   \n",
       "1459        2019        ...                     Rajasthan Royals        1   \n",
       "1460        2019        ...                      Kings XI Punjab        0   \n",
       "1461        2019        ...                       Delhi Capitals        1   \n",
       "1462        2019        ...                Kolkata Knight Riders        0   \n",
       "1463        2019        ...                  Sunrisers Hyderabad        1   \n",
       "1464        2019        ...          Royal Challengers Bangalore        0   \n",
       "1465        2019        ...                  Chennai Super Kings        1   \n",
       "1466        2019        ...                     Rajasthan Royals        0   \n",
       "1467        2019        ...                       Delhi Capitals        1   \n",
       "1468        2019        ...                  Sunrisers Hyderabad        0   \n",
       "1469        2019        ...                  Chennai Super Kings        1   \n",
       "1470        2019        ...          Royal Challengers Bangalore        0   \n",
       "1471        2019        ...                      Kings XI Punjab        1   \n",
       "1472        2019        ...                Kolkata Knight Riders        0   \n",
       "1473        2019        ...                     Rajasthan Royals        1   \n",
       "1474        2019        ...                       Mumbai Indians        0   \n",
       "1475        2019        ...                  Chennai Super Kings        1   \n",
       "1476        2019        ...                  Sunrisers Hyderabad        0   \n",
       "1477        2019        ...                     Rajasthan Royals        1   \n",
       "1478        2019        ...                       Delhi Capitals        1   \n",
       "1479        2019        ...          Royal Challengers Bangalore        0   \n",
       "1480        2019        ...                Kolkata Knight Riders        0   \n",
       "1481        2019        ...                       Mumbai Indians        1   \n",
       "1482        2019        ...                  Sunrisers Hyderabad        0   \n",
       "1483        2019        ...                      Kings XI Punjab        1   \n",
       "1484        2019        ...          Royal Challengers Bangalore        0   \n",
       "1485        2019        ...                     Rajasthan Royals        1   \n",
       "1486        2019        ...                  Chennai Super Kings        0   \n",
       "1487        2019        ...                       Delhi Capitals        1   \n",
       "\n",
       "      Total_Overs  Total_Score  Total_Wickets  Home Ground  \\\n",
       "12           19.7          142              8            1   \n",
       "13           13.1          143              1            0   \n",
       "16           19.7          214              5            1   \n",
       "17           19.5          217              7            0   \n",
       "18           19.6          182             10            1   \n",
       "19           19.6          116              9            0   \n",
       "28           19.6          178              5            0   \n",
       "29           19.4          165             10            1   \n",
       "30           19.7          137              8            1   \n",
       "31           18.4          138              3            0   \n",
       "32           19.6          191              5            1   \n",
       "33           19.6          181              5            0   \n",
       "34           19.6          164              8            1   \n",
       "35           18.6          167              3            0   \n",
       "36           19.7          196              7            1   \n",
       "37           19.1          151             10            0   \n",
       "38           19.6          169              6            1   \n",
       "39           18.7          172              2            0   \n",
       "40           19.6          165             10            1   \n",
       "41           18.6          171              5            0   \n",
       "42           19.6          178              6            1   \n",
       "43           19.6          169              6            0   \n",
       "44           19.6          162              8            1   \n",
       "45           18.5          133             10            0   \n",
       "46           18.6          109             10            0   \n",
       "47           14.2          110              2            1   \n",
       "48           19.2          126             10            1   \n",
       "49           18.3          127              4            0   \n",
       "50           19.6          144              7            1   \n",
       "51           17.6          148              3            0   \n",
       "...           ...          ...            ...          ...   \n",
       "1458         19.6          161              5            0   \n",
       "1459         19.1          162              5            1   \n",
       "1460         19.6          163              7            0   \n",
       "1461         19.4          166              5            1   \n",
       "1462         19.6          159              8            0   \n",
       "1463         14.6          161              1            1   \n",
       "1464         19.6          161              7            1   \n",
       "1465         19.6          160              8            0   \n",
       "1466         19.7          191              6            1   \n",
       "1467         19.2          193              4            0   \n",
       "1468         19.6          175              3            0   \n",
       "1469         19.5          176              4            1   \n",
       "1470         19.6          202              4            1   \n",
       "1471         19.6          185              7            0   \n",
       "1472         19.6          175              6            1   \n",
       "1473         19.2          177              7            0   \n",
       "1474         19.6          155              4            0   \n",
       "1475         17.4          109             10            1   \n",
       "1476         19.7          160              8            0   \n",
       "1477         19.1          161              3            1   \n",
       "1478         19.6          187              5            1   \n",
       "1479         19.7          171              7            0   \n",
       "1480         19.6          232              2            1   \n",
       "1481         19.6          198              7            0   \n",
       "1482         19.7          212              6            1   \n",
       "1483         19.6          167              8            0   \n",
       "1484          4.7           62              7            1   \n",
       "1485          3.2           41              1            0   \n",
       "1486         19.7          179              4            1   \n",
       "1487         16.2           99             10            0   \n",
       "\n",
       "      Prev_Run_Score_Rate  Prev_Run_Concede_Rate  Team_Codes  \\\n",
       "12                   5.98                   6.58          DC   \n",
       "13                   8.74                   6.02          DD   \n",
       "16                   7.21                   8.43          DC   \n",
       "17                   9.28                  10.92          RR   \n",
       "18                   8.43                  10.61        KXIP   \n",
       "19                  10.25                   9.28          MI   \n",
       "28                  10.61                   8.42         CSK   \n",
       "29                   8.51                  10.25         RCB   \n",
       "30                   7.46                   9.29         KKR   \n",
       "31                   5.92                   9.16          MI   \n",
       "32                   8.06                   9.08          DD   \n",
       "33                   8.51                   8.39         RCB   \n",
       "34                  10.86                   8.06          DC   \n",
       "35                   8.39                  11.13        KXIP   \n",
       "36                   6.58                   5.98          RR   \n",
       "37                   6.02                   8.74         KKR   \n",
       "38                   9.08                   7.21         CSK   \n",
       "39                  10.92                   8.51          DD   \n",
       "40                   8.37                   9.74          DC   \n",
       "41                   9.23                   8.98         RCB   \n",
       "42                   9.29                   9.95        KXIP   \n",
       "43                   7.91                   5.92         KKR   \n",
       "44                   7.86                   8.62          MI   \n",
       "45                   9.20                  13.36          DD   \n",
       "46                   8.62                   6.85         CSK   \n",
       "47                   8.07                   9.20          RR   \n",
       "48                   6.85                   8.37         RCB   \n",
       "49                   8.98                   8.07        KXIP   \n",
       "50                   5.86                   7.86         CSK   \n",
       "51                  13.36                   7.75          DC   \n",
       "...                   ...                    ...         ...   \n",
       "1458                 8.48                   9.29          MI   \n",
       "1459                 8.67                   6.53          RR   \n",
       "1460                 9.29                   8.48        KXIP   \n",
       "1461                 6.53                   8.67          DD   \n",
       "1462                 8.17                   6.73         KKR   \n",
       "1463                 8.30                   8.35          DC   \n",
       "1464                10.87                   8.17         RCB   \n",
       "1465                 8.35                  10.36         CSK   \n",
       "1466                 7.70                   8.32          RR   \n",
       "1467                 8.56                   7.83          DD   \n",
       "1468                 7.65                   8.21          DC   \n",
       "1469                 8.16                   7.74         CSK   \n",
       "1470                 8.21                   7.65         RCB   \n",
       "1471                 7.74                   8.16        KXIP   \n",
       "1472                 8.11                   8.21         KKR   \n",
       "1473                 8.48                  11.03          RR   \n",
       "1474                 8.21                   8.93          MI   \n",
       "1475                 9.03                   8.48         CSK   \n",
       "1476                 8.93                   8.93          DC   \n",
       "1477                 9.22                   9.03          RR   \n",
       "1478                 7.87                   8.83          DD   \n",
       "1479                 9.06                   6.24         RCB   \n",
       "1480                 8.93                   8.72         KKR   \n",
       "1481                 9.20                   9.22          MI   \n",
       "1482                 8.12                  10.31          DC   \n",
       "1483                 9.44                   8.43        KXIP   \n",
       "1484                10.31                   8.12         RCB   \n",
       "1485                 8.43                   9.44          RR   \n",
       "1486                 6.73                   9.70         CSK   \n",
       "1487                10.05                   8.30          DD   \n",
       "\n",
       "     Bowling_Team_Codes  \n",
       "12                   DD  \n",
       "13                   DC  \n",
       "16                   RR  \n",
       "17                   DC  \n",
       "18                   MI  \n",
       "19                 KXIP  \n",
       "28                  RCB  \n",
       "29                  CSK  \n",
       "30                   MI  \n",
       "31                  KKR  \n",
       "32                  RCB  \n",
       "33                   DD  \n",
       "34                 KXIP  \n",
       "35                   DC  \n",
       "36                  KKR  \n",
       "37                   RR  \n",
       "38                   DD  \n",
       "39                  CSK  \n",
       "40                  RCB  \n",
       "41                   DC  \n",
       "42                  KKR  \n",
       "43                 KXIP  \n",
       "44                   DD  \n",
       "45                   MI  \n",
       "46                   RR  \n",
       "47                  CSK  \n",
       "48                 KXIP  \n",
       "49                  RCB  \n",
       "50                   DC  \n",
       "51                  CSK  \n",
       "...                 ...  \n",
       "1458                 RR  \n",
       "1459                 MI  \n",
       "1460                 DD  \n",
       "1461               KXIP  \n",
       "1462                 DC  \n",
       "1463                KKR  \n",
       "1464                CSK  \n",
       "1465                RCB  \n",
       "1466                 DD  \n",
       "1467                 RR  \n",
       "1468                CSK  \n",
       "1469                 DC  \n",
       "1470               KXIP  \n",
       "1471                RCB  \n",
       "1472                 RR  \n",
       "1473                KKR  \n",
       "1474                CSK  \n",
       "1475                 MI  \n",
       "1476                 RR  \n",
       "1477                 DC  \n",
       "1478                RCB  \n",
       "1479                 DD  \n",
       "1480                 MI  \n",
       "1481                KKR  \n",
       "1482               KXIP  \n",
       "1483                 DC  \n",
       "1484                 RR  \n",
       "1485                RCB  \n",
       "1486                 DD  \n",
       "1487                CSK  \n",
       "\n",
       "[1228 rows x 21 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1[(df1.Prev_Run_Score_Rate > 0) & (df1.Prev_Run_Concede_Rate > 0)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1.to_csv('Prev_Run_Rates_Runs_Conceded_IPL_Analysis_Version_2_1_condensed_Sorted.csv', sep='|')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Last 3 Matches "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "###  FUntion to define dictionary\n",
    "def Year_Dict(datadf,year):\n",
    "    dictteam={}\n",
    "    for i in range(len(datadf)):\n",
    "        myear=datadf.loc[i:i, 'Match_Year'].values[0]\n",
    "        mnum=datadf.loc[i:i, 'Match_Number'].values[0]\n",
    "        #minns= datadf.loc[i:i, 'First_Innings'].values[0]\n",
    "        tc=datadf.loc[i:i, 'Team_Codes'].values[0]\n",
    "        #print(myear)\n",
    "        if(myear==year):\n",
    "            if(tc in dictteam):\n",
    "                dictteam[tc].append(mnum)\n",
    "            else:\n",
    "                dictteam[tc]=[mnum]\n",
    "    return(dictteam)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'CSK': [2, 8, 12, 15, 20, 24, 26, 28, 32, 37, 44, 48, 51, 55, 57, 58],\n",
       " 'DC': [5, 7, 9, 13, 18, 21, 26, 30, 33, 39, 43, 49, 52, 55],\n",
       " 'DD': [3, 7, 14, 17, 20, 23, 28, 34, 36, 39, 41, 45, 50, 56],\n",
       " 'KKR': [1, 5, 12, 16, 19, 22, 29, 33, 36, 40, 44, 46, 53],\n",
       " 'KXIP': [2, 6, 10, 14, 18, 22, 25, 32, 35, 38, 41, 47, 49, 53, 57],\n",
       " 'MI': [4, 8, 10, 13, 16, 23, 27, 31, 37, 40, 43, 47, 50, 54],\n",
       " 'RCB': [1, 4, 11, 15, 17, 21, 25, 29, 31, 35, 42, 45, 48, 52],\n",
       " 'RR': [3, 6, 9, 11, 19, 24, 27, 30, 34, 38, 42, 46, 51, 54, 56, 58]}"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dict_2008=Year_Dict(df1,2008)\n",
    "dict_2008"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "dict_2008=Year_Dict(df1,2008)\n",
    "dict_2009=Year_Dict(df1,2009)\n",
    "dict_2010=Year_Dict(df1,2010)\n",
    "dict_2011=Year_Dict(df1,2011)\n",
    "dict_2012=Year_Dict(df1,2012)\n",
    "dict_2013=Year_Dict(df1,2013)\n",
    "dict_2014=Year_Dict(df1,2014)\n",
    "dict_2015=Year_Dict(df1,2015)\n",
    "dict_2016=Year_Dict(df1,2016)\n",
    "dict_2017=Year_Dict(df1,2017)\n",
    "dict_2018=Year_Dict(df1,2018)\n",
    "dict_2019=Year_Dict(df1,2019)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_Last_three_matches_num(dict1,matchnum,tm):\n",
    "    matchlist=dict1[tm]\n",
    "    previous_matches=[]\n",
    "    for m in matchlist:\n",
    "        if(matchnum > m):\n",
    "            previous_matches.append(m)\n",
    "    if(len(previous_matches)>=3):\n",
    "        return(previous_matches[:3])\n",
    "    elif(len(previous_matches)>0 and len(previous_matches)<3):\n",
    "        return(previous_matches)\n",
    "    elif(len(previous_matches)==0):\n",
    "        return('Not Available')\n",
    "\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[5, 1]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a=get_Last_three_matches_num(dict_2008,9,'KKR')\n",
    "a.sort(reverse=True)\n",
    "a"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a,b,c,d=[0,0,0,5]\n",
    "d"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1['Prev_Run_Score_Rate']=''\n",
    "df1['Prev_2_Run_Score_Rate']=''\n",
    "df1['Prev_3_Run_Score_Rate']=''\n",
    "df1['Prev_Run_Concede_Rate']=''\n",
    "df1['Prev_2_Run_Concede_Rate']=''\n",
    "df1['Prev_2_Run_Concede_Rate']=''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Rows-Processed, 0\n",
      "Rows-Processed, 100\n",
      "Rows-Processed, 200\n",
      "Rows-Processed, 300\n",
      "Rows-Processed, 400\n",
      "Rows-Processed, 500\n",
      "Rows-Processed, 600\n",
      "Rows-Processed, 700\n",
      "Rows-Processed, 800\n",
      "Rows-Processed, 900\n",
      "Rows-Processed, 1000\n",
      "Rows-Processed, 1100\n",
      "Rows-Processed, 1200\n",
      "Rows-Processed, 1300\n",
      "Rows-Processed, 1400\n"
     ]
    }
   ],
   "source": [
    "for i in range(len(df1)):   \n",
    "    myear=df1.loc[i:i, 'Match_Year'].values[0]\n",
    "    mnum=df1.loc[i:i, 'Match_Number'].values[0]\n",
    "    minns= df1.loc[i:i, 'First_Innings'].values[0]\n",
    "    tc=df1.loc[i:i, 'Team_Codes'].values[0]\n",
    "    bowltc=df1.loc[i:i, 'Bowling_Team_Codes'].values[0]\n",
    "# 2008\n",
    "    if(myear==2008):\n",
    "        #bwl_tc=df1[(df1.Match_Year==myear) & (df1.First_Innings==0) & (df1.Match_Number==mnum)].loc[:,'Team_Codes'].values[0]\n",
    "        dict_yr_tm=dict_2008\n",
    "    elif(myear==2009):\n",
    "        dict_yr_tm=dict_2009\n",
    "    elif(myear==2010):\n",
    "        dict_yr_tm=dict_2010\n",
    "    elif(myear==2011):\n",
    "        dict_yr_tm=dict_2011\n",
    "    elif(myear==2012):\n",
    "        dict_yr_tm=dict_2012\n",
    "    elif(myear==2013):\n",
    "        dict_yr_tm=dict_2013\n",
    "    elif(myear==2014):\n",
    "        dict_yr_tm=dict_2014\n",
    "    elif(myear==2015):\n",
    "        dict_yr_tm=dict_2015\n",
    "    elif(myear==2016):\n",
    "        dict_yr_tm=dict_2016\n",
    "    elif(myear==2017):\n",
    "        dict_yr_tm=dict_2017\n",
    "    elif(myear==2018):\n",
    "        dict_yr_tm=dict_2018\n",
    "    elif(myear==2019):\n",
    "        dict_yr_tm=dict_2019\n",
    "\n",
    "\n",
    "    \n",
    "    prev_3matches_num_batting_team=get_Last_three_matches_num(dict_yr_tm,mnum,tc)\n",
    "    prev_3matches_num_bowling_team=get_Last_three_matches_num(dict_yr_tm,mnum,bowltc)\n",
    "    if(prev_3matches_num_batting_team!='Not Available'):\n",
    "        a,b,c=[0,0,0]\n",
    "        if(len(prev_3matches_num_batting_team)==3):\n",
    "            prev_3matches_num_batting_team.sort(reverse=True)\n",
    "            a,b,c=[df1[(df1.Match_Year==myear) & (df1.Team_Codes==tc) &(df1.Match_Number==j)].loc[:,'Net_Run_Rate'].values[0] for j in prev_3matches_num_batting_team]\n",
    "        elif(len(prev_3matches_num_batting_team)==2):\n",
    "            prev_3matches_num_batting_team.sort(reverse=True)\n",
    "            c=0\n",
    "            a,b=[df1[(df1.Match_Year==myear) & (df1.Team_Codes==tc) &(df1.Match_Number==j)].loc[:,'Net_Run_Rate'].values[0] for j in prev_3matches_num_batting_team]\n",
    "        elif(len(prev_3matches_num_batting_team)==1):\n",
    "            b=0\n",
    "            c=0\n",
    "            a=[df1[(df1.Match_Year==myear) & (df1.Team_Codes==tc) &(df1.Match_Number==j)].loc[:,'Net_Run_Rate'].values[0] for j in prev_3matches_num_batting_team]\n",
    "    else:\n",
    "        a,b,c=[0,0,0]\n",
    "    if(prev_3matches_num_bowling_team!='Not Available'):\n",
    "        d,e,f=[0,0,0]\n",
    "        if(len(prev_3matches_num_bowling_team)==3):\n",
    "            prev_3matches_num_bowling_team.sort(reverse=True)\n",
    "            d,e,f=[df1[(df1.Match_Year==myear) & (df1.Bowling_Team_Codes==bowltc) &(df1.Match_Number==j)].loc[:,'Net_Run_Rate'].values[0] for j in prev_3matches_num_bowling_team]\n",
    "        elif(len(prev_3matches_num_bowling_team)==2):\n",
    "            prev_3matches_num_bowling_team.sort(reverse=True)\n",
    "            f=0\n",
    "            d,e=[df1[(df1.Match_Year==myear) & (df1.Bowling_Team_Codes==bowltc) &(df1.Match_Number==j)].loc[:,'Net_Run_Rate'].values[0] for j in prev_3matches_num_bowling_team]\n",
    "        elif(len(prev_3matches_num_bowling_team)==1):\n",
    "            e=0\n",
    "            f=0\n",
    "            d=[df1[(df1.Match_Year==myear) & (df1.Bowling_Team_Codes==bowltc) &(df1.Match_Number==j)].loc[:,'Net_Run_Rate'].values[0] for j in prev_3matches_num_bowling_team]\n",
    "    else:\n",
    "        d,e,f=[0,0,0]\n",
    "\n",
    "    df1.loc[i:i, 'Prev_Run_Score_Rate']=a\n",
    "    df1.loc[i:i, 'Prev_2_Run_Score_Rate']=b\n",
    "    df1.loc[i:i, 'Prev_3_Run_Score_Rate']=c\n",
    "    df1.loc[i:i, 'Prev_Run_Concede_Rate']=d\n",
    "    df1.loc[i:i, 'Prev_2_Run_Concede_Rate']=e\n",
    "    df1.loc[i:i, 'Prev_3_Run_Concede_Rate']=f\n",
    "    if(i%100==0):\n",
    "        print('Rows-Processed, '+str(i))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[1]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prev_3matches_num_bowling_team"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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_Number</th>\n",
       "      <th>Match_Year</th>\n",
       "      <th>Team_Codes</th>\n",
       "      <th>Bowling_Team_Codes</th>\n",
       "      <th>Net_Run_Rate</th>\n",
       "      <th>Prev_Run_Score_Rate</th>\n",
       "      <th>Prev_2_Run_Score_Rate</th>\n",
       "      <th>Prev_3_Run_Score_Rate</th>\n",
       "      <th>Prev_Run_Concede_Rate</th>\n",
       "      <th>Prev_2_Run_Concede_Rate</th>\n",
       "      <th>Prev_3_Run_Concede_Rate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2008</td>\n",
       "      <td>KKR</td>\n",
       "      <td>RCB</td>\n",
       "      <td>11.33</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2008</td>\n",
       "      <td>RCB</td>\n",
       "      <td>KKR</td>\n",
       "      <td>5.39</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2008</td>\n",
       "      <td>CSK</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>12.24</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>2008</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>CSK</td>\n",
       "      <td>10.56</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>2008</td>\n",
       "      <td>RR</td>\n",
       "      <td>DD</td>\n",
       "      <td>6.58</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>3</td>\n",
       "      <td>2008</td>\n",
       "      <td>DD</td>\n",
       "      <td>RR</td>\n",
       "      <td>8.74</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>4</td>\n",
       "      <td>2008</td>\n",
       "      <td>MI</td>\n",
       "      <td>RCB</td>\n",
       "      <td>8.42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11.33</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4</td>\n",
       "      <td>2008</td>\n",
       "      <td>RCB</td>\n",
       "      <td>MI</td>\n",
       "      <td>8.51</td>\n",
       "      <td>5.39</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5</td>\n",
       "      <td>2008</td>\n",
       "      <td>DC</td>\n",
       "      <td>KKR</td>\n",
       "      <td>5.98</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.39</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5</td>\n",
       "      <td>2008</td>\n",
       "      <td>KKR</td>\n",
       "      <td>DC</td>\n",
       "      <td>6.02</td>\n",
       "      <td>11.33</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>6</td>\n",
       "      <td>2008</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>RR</td>\n",
       "      <td>8.43</td>\n",
       "      <td>10.56</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8.74</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>6</td>\n",
       "      <td>2008</td>\n",
       "      <td>RR</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>9.28</td>\n",
       "      <td>6.58</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12.24</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>7</td>\n",
       "      <td>2008</td>\n",
       "      <td>DC</td>\n",
       "      <td>DD</td>\n",
       "      <td>7.21</td>\n",
       "      <td>5.98</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.58</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>7</td>\n",
       "      <td>2008</td>\n",
       "      <td>DD</td>\n",
       "      <td>DC</td>\n",
       "      <td>10.92</td>\n",
       "      <td>8.74</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.02</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>8</td>\n",
       "      <td>2008</td>\n",
       "      <td>CSK</td>\n",
       "      <td>MI</td>\n",
       "      <td>10.61</td>\n",
       "      <td>12.24</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8.51</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>8</td>\n",
       "      <td>2008</td>\n",
       "      <td>MI</td>\n",
       "      <td>CSK</td>\n",
       "      <td>10.25</td>\n",
       "      <td>8.42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10.56</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>9</td>\n",
       "      <td>2008</td>\n",
       "      <td>DC</td>\n",
       "      <td>RR</td>\n",
       "      <td>10.86</td>\n",
       "      <td>7.21</td>\n",
       "      <td>5.98</td>\n",
       "      <td>0</td>\n",
       "      <td>8.43</td>\n",
       "      <td>8.74</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9</td>\n",
       "      <td>2008</td>\n",
       "      <td>RR</td>\n",
       "      <td>DC</td>\n",
       "      <td>11.13</td>\n",
       "      <td>9.28</td>\n",
       "      <td>6.58</td>\n",
       "      <td>0</td>\n",
       "      <td>10.92</td>\n",
       "      <td>6.02</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>10</td>\n",
       "      <td>2008</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>MI</td>\n",
       "      <td>9.29</td>\n",
       "      <td>8.43</td>\n",
       "      <td>10.56</td>\n",
       "      <td>0</td>\n",
       "      <td>10.61</td>\n",
       "      <td>8.51</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>10</td>\n",
       "      <td>2008</td>\n",
       "      <td>MI</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>5.92</td>\n",
       "      <td>10.25</td>\n",
       "      <td>8.42</td>\n",
       "      <td>0</td>\n",
       "      <td>9.28</td>\n",
       "      <td>12.24</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>11</td>\n",
       "      <td>2008</td>\n",
       "      <td>RCB</td>\n",
       "      <td>RR</td>\n",
       "      <td>6.85</td>\n",
       "      <td>8.51</td>\n",
       "      <td>5.39</td>\n",
       "      <td>0</td>\n",
       "      <td>10.86</td>\n",
       "      <td>8.43</td>\n",
       "      <td>8.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>11</td>\n",
       "      <td>2008</td>\n",
       "      <td>RR</td>\n",
       "      <td>RCB</td>\n",
       "      <td>8.07</td>\n",
       "      <td>11.13</td>\n",
       "      <td>9.28</td>\n",
       "      <td>6.58</td>\n",
       "      <td>8.42</td>\n",
       "      <td>11.33</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>12</td>\n",
       "      <td>2008</td>\n",
       "      <td>KKR</td>\n",
       "      <td>CSK</td>\n",
       "      <td>7.46</td>\n",
       "      <td>6.02</td>\n",
       "      <td>11.33</td>\n",
       "      <td>0</td>\n",
       "      <td>10.25</td>\n",
       "      <td>10.56</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>12</td>\n",
       "      <td>2008</td>\n",
       "      <td>CSK</td>\n",
       "      <td>KKR</td>\n",
       "      <td>9.16</td>\n",
       "      <td>10.61</td>\n",
       "      <td>12.24</td>\n",
       "      <td>0</td>\n",
       "      <td>5.98</td>\n",
       "      <td>5.39</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>13</td>\n",
       "      <td>2008</td>\n",
       "      <td>MI</td>\n",
       "      <td>DC</td>\n",
       "      <td>7.86</td>\n",
       "      <td>5.92</td>\n",
       "      <td>10.25</td>\n",
       "      <td>8.42</td>\n",
       "      <td>11.13</td>\n",
       "      <td>10.92</td>\n",
       "      <td>6.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>13</td>\n",
       "      <td>2008</td>\n",
       "      <td>DC</td>\n",
       "      <td>MI</td>\n",
       "      <td>13.36</td>\n",
       "      <td>10.86</td>\n",
       "      <td>7.21</td>\n",
       "      <td>5.98</td>\n",
       "      <td>9.29</td>\n",
       "      <td>10.61</td>\n",
       "      <td>8.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>14</td>\n",
       "      <td>2008</td>\n",
       "      <td>DD</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>8.06</td>\n",
       "      <td>10.92</td>\n",
       "      <td>8.74</td>\n",
       "      <td>0</td>\n",
       "      <td>5.92</td>\n",
       "      <td>9.28</td>\n",
       "      <td>12.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>14</td>\n",
       "      <td>2008</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>DD</td>\n",
       "      <td>8.39</td>\n",
       "      <td>9.29</td>\n",
       "      <td>8.43</td>\n",
       "      <td>10.56</td>\n",
       "      <td>7.21</td>\n",
       "      <td>6.58</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>15</td>\n",
       "      <td>2008</td>\n",
       "      <td>CSK</td>\n",
       "      <td>RCB</td>\n",
       "      <td>9.08</td>\n",
       "      <td>9.16</td>\n",
       "      <td>10.61</td>\n",
       "      <td>12.24</td>\n",
       "      <td>8.07</td>\n",
       "      <td>8.42</td>\n",
       "      <td>11.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>15</td>\n",
       "      <td>2008</td>\n",
       "      <td>RCB</td>\n",
       "      <td>CSK</td>\n",
       "      <td>8.51</td>\n",
       "      <td>6.85</td>\n",
       "      <td>8.51</td>\n",
       "      <td>5.39</td>\n",
       "      <td>7.46</td>\n",
       "      <td>10.25</td>\n",
       "      <td>10.56</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1458</th>\n",
       "      <td>36</td>\n",
       "      <td>2019</td>\n",
       "      <td>MI</td>\n",
       "      <td>RR</td>\n",
       "      <td>8.21</td>\n",
       "      <td>8.98</td>\n",
       "      <td>9.49</td>\n",
       "      <td>9.17</td>\n",
       "      <td>8.84</td>\n",
       "      <td>10.75</td>\n",
       "      <td>9.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1459</th>\n",
       "      <td>36</td>\n",
       "      <td>2019</td>\n",
       "      <td>RR</td>\n",
       "      <td>MI</td>\n",
       "      <td>8.48</td>\n",
       "      <td>8.52</td>\n",
       "      <td>10.05</td>\n",
       "      <td>8.67</td>\n",
       "      <td>9.62</td>\n",
       "      <td>9.23</td>\n",
       "      <td>10.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1460</th>\n",
       "      <td>37</td>\n",
       "      <td>2019</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>DD</td>\n",
       "      <td>8.32</td>\n",
       "      <td>9.62</td>\n",
       "      <td>9.69</td>\n",
       "      <td>9.34</td>\n",
       "      <td>9.44</td>\n",
       "      <td>7.73</td>\n",
       "      <td>9.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1461</th>\n",
       "      <td>37</td>\n",
       "      <td>2019</td>\n",
       "      <td>DD</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>8.56</td>\n",
       "      <td>9.44</td>\n",
       "      <td>7.5</td>\n",
       "      <td>10.87</td>\n",
       "      <td>8.98</td>\n",
       "      <td>11.12</td>\n",
       "      <td>8.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1462</th>\n",
       "      <td>38</td>\n",
       "      <td>2019</td>\n",
       "      <td>KKR</td>\n",
       "      <td>DC</td>\n",
       "      <td>8.11</td>\n",
       "      <td>9.44</td>\n",
       "      <td>11.12</td>\n",
       "      <td>9.38</td>\n",
       "      <td>5.79</td>\n",
       "      <td>10.05</td>\n",
       "      <td>9.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1463</th>\n",
       "      <td>38</td>\n",
       "      <td>2019</td>\n",
       "      <td>DC</td>\n",
       "      <td>KKR</td>\n",
       "      <td>11.03</td>\n",
       "      <td>11.79</td>\n",
       "      <td>10.75</td>\n",
       "      <td>9.23</td>\n",
       "      <td>9.44</td>\n",
       "      <td>9.69</td>\n",
       "      <td>9.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1464</th>\n",
       "      <td>39</td>\n",
       "      <td>2019</td>\n",
       "      <td>RCB</td>\n",
       "      <td>CSK</td>\n",
       "      <td>8.21</td>\n",
       "      <td>5.79</td>\n",
       "      <td>9.23</td>\n",
       "      <td>4.09</td>\n",
       "      <td>8.52</td>\n",
       "      <td>7.5</td>\n",
       "      <td>4.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1465</th>\n",
       "      <td>39</td>\n",
       "      <td>2019</td>\n",
       "      <td>CSK</td>\n",
       "      <td>RCB</td>\n",
       "      <td>8.16</td>\n",
       "      <td>8.84</td>\n",
       "      <td>7.73</td>\n",
       "      <td>4.06</td>\n",
       "      <td>11.79</td>\n",
       "      <td>9.49</td>\n",
       "      <td>4.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1466</th>\n",
       "      <td>40</td>\n",
       "      <td>2019</td>\n",
       "      <td>RR</td>\n",
       "      <td>DD</td>\n",
       "      <td>9.70</td>\n",
       "      <td>8.52</td>\n",
       "      <td>10.05</td>\n",
       "      <td>8.67</td>\n",
       "      <td>9.44</td>\n",
       "      <td>7.73</td>\n",
       "      <td>9.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1467</th>\n",
       "      <td>40</td>\n",
       "      <td>2019</td>\n",
       "      <td>DD</td>\n",
       "      <td>RR</td>\n",
       "      <td>10.05</td>\n",
       "      <td>9.44</td>\n",
       "      <td>7.5</td>\n",
       "      <td>10.87</td>\n",
       "      <td>8.84</td>\n",
       "      <td>10.75</td>\n",
       "      <td>9.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1468</th>\n",
       "      <td>41</td>\n",
       "      <td>2019</td>\n",
       "      <td>DC</td>\n",
       "      <td>CSK</td>\n",
       "      <td>8.93</td>\n",
       "      <td>11.79</td>\n",
       "      <td>10.75</td>\n",
       "      <td>9.23</td>\n",
       "      <td>8.52</td>\n",
       "      <td>7.5</td>\n",
       "      <td>4.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1469</th>\n",
       "      <td>41</td>\n",
       "      <td>2019</td>\n",
       "      <td>CSK</td>\n",
       "      <td>DC</td>\n",
       "      <td>9.03</td>\n",
       "      <td>8.84</td>\n",
       "      <td>7.73</td>\n",
       "      <td>4.06</td>\n",
       "      <td>5.79</td>\n",
       "      <td>10.05</td>\n",
       "      <td>9.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1470</th>\n",
       "      <td>42</td>\n",
       "      <td>2019</td>\n",
       "      <td>RCB</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>10.31</td>\n",
       "      <td>5.79</td>\n",
       "      <td>9.23</td>\n",
       "      <td>4.09</td>\n",
       "      <td>8.98</td>\n",
       "      <td>11.12</td>\n",
       "      <td>8.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1471</th>\n",
       "      <td>42</td>\n",
       "      <td>2019</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>RCB</td>\n",
       "      <td>9.44</td>\n",
       "      <td>9.62</td>\n",
       "      <td>9.69</td>\n",
       "      <td>9.34</td>\n",
       "      <td>11.79</td>\n",
       "      <td>9.49</td>\n",
       "      <td>4.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1472</th>\n",
       "      <td>43</td>\n",
       "      <td>2019</td>\n",
       "      <td>KKR</td>\n",
       "      <td>RR</td>\n",
       "      <td>8.93</td>\n",
       "      <td>9.44</td>\n",
       "      <td>11.12</td>\n",
       "      <td>9.38</td>\n",
       "      <td>8.84</td>\n",
       "      <td>10.75</td>\n",
       "      <td>9.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1473</th>\n",
       "      <td>43</td>\n",
       "      <td>2019</td>\n",
       "      <td>RR</td>\n",
       "      <td>KKR</td>\n",
       "      <td>9.22</td>\n",
       "      <td>8.52</td>\n",
       "      <td>10.05</td>\n",
       "      <td>8.67</td>\n",
       "      <td>9.44</td>\n",
       "      <td>9.69</td>\n",
       "      <td>9.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1474</th>\n",
       "      <td>44</td>\n",
       "      <td>2019</td>\n",
       "      <td>MI</td>\n",
       "      <td>CSK</td>\n",
       "      <td>7.91</td>\n",
       "      <td>8.98</td>\n",
       "      <td>9.49</td>\n",
       "      <td>9.17</td>\n",
       "      <td>8.52</td>\n",
       "      <td>7.5</td>\n",
       "      <td>4.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1475</th>\n",
       "      <td>44</td>\n",
       "      <td>2019</td>\n",
       "      <td>CSK</td>\n",
       "      <td>MI</td>\n",
       "      <td>6.26</td>\n",
       "      <td>8.84</td>\n",
       "      <td>7.73</td>\n",
       "      <td>4.06</td>\n",
       "      <td>9.62</td>\n",
       "      <td>9.23</td>\n",
       "      <td>10.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1476</th>\n",
       "      <td>45</td>\n",
       "      <td>2019</td>\n",
       "      <td>DC</td>\n",
       "      <td>RR</td>\n",
       "      <td>8.12</td>\n",
       "      <td>11.79</td>\n",
       "      <td>10.75</td>\n",
       "      <td>9.23</td>\n",
       "      <td>8.84</td>\n",
       "      <td>10.75</td>\n",
       "      <td>9.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1477</th>\n",
       "      <td>45</td>\n",
       "      <td>2019</td>\n",
       "      <td>RR</td>\n",
       "      <td>DC</td>\n",
       "      <td>8.43</td>\n",
       "      <td>8.52</td>\n",
       "      <td>10.05</td>\n",
       "      <td>8.67</td>\n",
       "      <td>5.79</td>\n",
       "      <td>10.05</td>\n",
       "      <td>9.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1478</th>\n",
       "      <td>46</td>\n",
       "      <td>2019</td>\n",
       "      <td>DD</td>\n",
       "      <td>RCB</td>\n",
       "      <td>9.54</td>\n",
       "      <td>9.44</td>\n",
       "      <td>7.5</td>\n",
       "      <td>10.87</td>\n",
       "      <td>11.79</td>\n",
       "      <td>9.49</td>\n",
       "      <td>4.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1479</th>\n",
       "      <td>46</td>\n",
       "      <td>2019</td>\n",
       "      <td>RCB</td>\n",
       "      <td>DD</td>\n",
       "      <td>8.68</td>\n",
       "      <td>5.79</td>\n",
       "      <td>9.23</td>\n",
       "      <td>4.09</td>\n",
       "      <td>9.44</td>\n",
       "      <td>7.73</td>\n",
       "      <td>9.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1480</th>\n",
       "      <td>47</td>\n",
       "      <td>2019</td>\n",
       "      <td>KKR</td>\n",
       "      <td>MI</td>\n",
       "      <td>11.84</td>\n",
       "      <td>9.44</td>\n",
       "      <td>11.12</td>\n",
       "      <td>9.38</td>\n",
       "      <td>9.62</td>\n",
       "      <td>9.23</td>\n",
       "      <td>10.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1481</th>\n",
       "      <td>47</td>\n",
       "      <td>2019</td>\n",
       "      <td>MI</td>\n",
       "      <td>KKR</td>\n",
       "      <td>10.10</td>\n",
       "      <td>8.98</td>\n",
       "      <td>9.49</td>\n",
       "      <td>9.17</td>\n",
       "      <td>9.44</td>\n",
       "      <td>9.69</td>\n",
       "      <td>9.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1482</th>\n",
       "      <td>48</td>\n",
       "      <td>2019</td>\n",
       "      <td>DC</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>10.76</td>\n",
       "      <td>11.79</td>\n",
       "      <td>10.75</td>\n",
       "      <td>9.23</td>\n",
       "      <td>8.98</td>\n",
       "      <td>11.12</td>\n",
       "      <td>8.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1483</th>\n",
       "      <td>48</td>\n",
       "      <td>2019</td>\n",
       "      <td>KXIP</td>\n",
       "      <td>DC</td>\n",
       "      <td>8.52</td>\n",
       "      <td>9.62</td>\n",
       "      <td>9.69</td>\n",
       "      <td>9.34</td>\n",
       "      <td>5.79</td>\n",
       "      <td>10.05</td>\n",
       "      <td>9.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1484</th>\n",
       "      <td>49</td>\n",
       "      <td>2019</td>\n",
       "      <td>RCB</td>\n",
       "      <td>RR</td>\n",
       "      <td>13.19</td>\n",
       "      <td>5.79</td>\n",
       "      <td>9.23</td>\n",
       "      <td>4.09</td>\n",
       "      <td>8.84</td>\n",
       "      <td>10.75</td>\n",
       "      <td>9.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1485</th>\n",
       "      <td>49</td>\n",
       "      <td>2019</td>\n",
       "      <td>RR</td>\n",
       "      <td>RCB</td>\n",
       "      <td>12.81</td>\n",
       "      <td>8.52</td>\n",
       "      <td>10.05</td>\n",
       "      <td>8.67</td>\n",
       "      <td>11.79</td>\n",
       "      <td>9.49</td>\n",
       "      <td>4.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1486</th>\n",
       "      <td>50</td>\n",
       "      <td>2019</td>\n",
       "      <td>CSK</td>\n",
       "      <td>DD</td>\n",
       "      <td>9.09</td>\n",
       "      <td>8.84</td>\n",
       "      <td>7.73</td>\n",
       "      <td>4.06</td>\n",
       "      <td>9.44</td>\n",
       "      <td>7.73</td>\n",
       "      <td>9.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1487</th>\n",
       "      <td>50</td>\n",
       "      <td>2019</td>\n",
       "      <td>DD</td>\n",
       "      <td>CSK</td>\n",
       "      <td>6.11</td>\n",
       "      <td>9.44</td>\n",
       "      <td>7.5</td>\n",
       "      <td>10.87</td>\n",
       "      <td>8.52</td>\n",
       "      <td>7.5</td>\n",
       "      <td>4.09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1488 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Match_Number  Match_Year Team_Codes Bowling_Team_Codes  Net_Run_Rate  \\\n",
       "0                1        2008        KKR                RCB         11.33   \n",
       "1                1        2008        RCB                KKR          5.39   \n",
       "2                2        2008        CSK               KXIP         12.24   \n",
       "3                2        2008       KXIP                CSK         10.56   \n",
       "4                3        2008         RR                 DD          6.58   \n",
       "5                3        2008         DD                 RR          8.74   \n",
       "6                4        2008         MI                RCB          8.42   \n",
       "7                4        2008        RCB                 MI          8.51   \n",
       "8                5        2008         DC                KKR          5.98   \n",
       "9                5        2008        KKR                 DC          6.02   \n",
       "10               6        2008       KXIP                 RR          8.43   \n",
       "11               6        2008         RR               KXIP          9.28   \n",
       "12               7        2008         DC                 DD          7.21   \n",
       "13               7        2008         DD                 DC         10.92   \n",
       "14               8        2008        CSK                 MI         10.61   \n",
       "15               8        2008         MI                CSK         10.25   \n",
       "16               9        2008         DC                 RR         10.86   \n",
       "17               9        2008         RR                 DC         11.13   \n",
       "18              10        2008       KXIP                 MI          9.29   \n",
       "19              10        2008         MI               KXIP          5.92   \n",
       "20              11        2008        RCB                 RR          6.85   \n",
       "21              11        2008         RR                RCB          8.07   \n",
       "22              12        2008        KKR                CSK          7.46   \n",
       "23              12        2008        CSK                KKR          9.16   \n",
       "24              13        2008         MI                 DC          7.86   \n",
       "25              13        2008         DC                 MI         13.36   \n",
       "26              14        2008         DD               KXIP          8.06   \n",
       "27              14        2008       KXIP                 DD          8.39   \n",
       "28              15        2008        CSK                RCB          9.08   \n",
       "29              15        2008        RCB                CSK          8.51   \n",
       "...            ...         ...        ...                ...           ...   \n",
       "1458            36        2019         MI                 RR          8.21   \n",
       "1459            36        2019         RR                 MI          8.48   \n",
       "1460            37        2019       KXIP                 DD          8.32   \n",
       "1461            37        2019         DD               KXIP          8.56   \n",
       "1462            38        2019        KKR                 DC          8.11   \n",
       "1463            38        2019         DC                KKR         11.03   \n",
       "1464            39        2019        RCB                CSK          8.21   \n",
       "1465            39        2019        CSK                RCB          8.16   \n",
       "1466            40        2019         RR                 DD          9.70   \n",
       "1467            40        2019         DD                 RR         10.05   \n",
       "1468            41        2019         DC                CSK          8.93   \n",
       "1469            41        2019        CSK                 DC          9.03   \n",
       "1470            42        2019        RCB               KXIP         10.31   \n",
       "1471            42        2019       KXIP                RCB          9.44   \n",
       "1472            43        2019        KKR                 RR          8.93   \n",
       "1473            43        2019         RR                KKR          9.22   \n",
       "1474            44        2019         MI                CSK          7.91   \n",
       "1475            44        2019        CSK                 MI          6.26   \n",
       "1476            45        2019         DC                 RR          8.12   \n",
       "1477            45        2019         RR                 DC          8.43   \n",
       "1478            46        2019         DD                RCB          9.54   \n",
       "1479            46        2019        RCB                 DD          8.68   \n",
       "1480            47        2019        KKR                 MI         11.84   \n",
       "1481            47        2019         MI                KKR         10.10   \n",
       "1482            48        2019         DC               KXIP         10.76   \n",
       "1483            48        2019       KXIP                 DC          8.52   \n",
       "1484            49        2019        RCB                 RR         13.19   \n",
       "1485            49        2019         RR                RCB         12.81   \n",
       "1486            50        2019        CSK                 DD          9.09   \n",
       "1487            50        2019         DD                CSK          6.11   \n",
       "\n",
       "     Prev_Run_Score_Rate Prev_2_Run_Score_Rate Prev_3_Run_Score_Rate  \\\n",
       "0                      0                     0                     0   \n",
       "1                      0                     0                     0   \n",
       "2                      0                     0                     0   \n",
       "3                      0                     0                     0   \n",
       "4                      0                     0                     0   \n",
       "5                      0                     0                     0   \n",
       "6                      0                     0                     0   \n",
       "7                   5.39                     0                     0   \n",
       "8                      0                     0                     0   \n",
       "9                  11.33                     0                     0   \n",
       "10                 10.56                     0                     0   \n",
       "11                  6.58                     0                     0   \n",
       "12                  5.98                     0                     0   \n",
       "13                  8.74                     0                     0   \n",
       "14                 12.24                     0                     0   \n",
       "15                  8.42                     0                     0   \n",
       "16                  7.21                  5.98                     0   \n",
       "17                  9.28                  6.58                     0   \n",
       "18                  8.43                 10.56                     0   \n",
       "19                 10.25                  8.42                     0   \n",
       "20                  8.51                  5.39                     0   \n",
       "21                 11.13                  9.28                  6.58   \n",
       "22                  6.02                 11.33                     0   \n",
       "23                 10.61                 12.24                     0   \n",
       "24                  5.92                 10.25                  8.42   \n",
       "25                 10.86                  7.21                  5.98   \n",
       "26                 10.92                  8.74                     0   \n",
       "27                  9.29                  8.43                 10.56   \n",
       "28                  9.16                 10.61                 12.24   \n",
       "29                  6.85                  8.51                  5.39   \n",
       "...                  ...                   ...                   ...   \n",
       "1458                8.98                  9.49                  9.17   \n",
       "1459                8.52                 10.05                  8.67   \n",
       "1460                9.62                  9.69                  9.34   \n",
       "1461                9.44                   7.5                 10.87   \n",
       "1462                9.44                 11.12                  9.38   \n",
       "1463               11.79                 10.75                  9.23   \n",
       "1464                5.79                  9.23                  4.09   \n",
       "1465                8.84                  7.73                  4.06   \n",
       "1466                8.52                 10.05                  8.67   \n",
       "1467                9.44                   7.5                 10.87   \n",
       "1468               11.79                 10.75                  9.23   \n",
       "1469                8.84                  7.73                  4.06   \n",
       "1470                5.79                  9.23                  4.09   \n",
       "1471                9.62                  9.69                  9.34   \n",
       "1472                9.44                 11.12                  9.38   \n",
       "1473                8.52                 10.05                  8.67   \n",
       "1474                8.98                  9.49                  9.17   \n",
       "1475                8.84                  7.73                  4.06   \n",
       "1476               11.79                 10.75                  9.23   \n",
       "1477                8.52                 10.05                  8.67   \n",
       "1478                9.44                   7.5                 10.87   \n",
       "1479                5.79                  9.23                  4.09   \n",
       "1480                9.44                 11.12                  9.38   \n",
       "1481                8.98                  9.49                  9.17   \n",
       "1482               11.79                 10.75                  9.23   \n",
       "1483                9.62                  9.69                  9.34   \n",
       "1484                5.79                  9.23                  4.09   \n",
       "1485                8.52                 10.05                  8.67   \n",
       "1486                8.84                  7.73                  4.06   \n",
       "1487                9.44                   7.5                 10.87   \n",
       "\n",
       "     Prev_Run_Concede_Rate Prev_2_Run_Concede_Rate  Prev_3_Run_Concede_Rate  \n",
       "0                        0                       0                     0.00  \n",
       "1                        0                       0                     0.00  \n",
       "2                        0                       0                     0.00  \n",
       "3                        0                       0                     0.00  \n",
       "4                        0                       0                     0.00  \n",
       "5                        0                       0                     0.00  \n",
       "6                    11.33                       0                     0.00  \n",
       "7                        0                       0                     0.00  \n",
       "8                     5.39                       0                     0.00  \n",
       "9                        0                       0                     0.00  \n",
       "10                    8.74                       0                     0.00  \n",
       "11                   12.24                       0                     0.00  \n",
       "12                    6.58                       0                     0.00  \n",
       "13                    6.02                       0                     0.00  \n",
       "14                    8.51                       0                     0.00  \n",
       "15                   10.56                       0                     0.00  \n",
       "16                    8.43                    8.74                     0.00  \n",
       "17                   10.92                    6.02                     0.00  \n",
       "18                   10.61                    8.51                     0.00  \n",
       "19                    9.28                   12.24                     0.00  \n",
       "20                   10.86                    8.43                     8.74  \n",
       "21                    8.42                   11.33                     0.00  \n",
       "22                   10.25                   10.56                     0.00  \n",
       "23                    5.98                    5.39                     0.00  \n",
       "24                   11.13                   10.92                     6.02  \n",
       "25                    9.29                   10.61                     8.51  \n",
       "26                    5.92                    9.28                    12.24  \n",
       "27                    7.21                    6.58                     0.00  \n",
       "28                    8.07                    8.42                    11.33  \n",
       "29                    7.46                   10.25                    10.56  \n",
       "...                    ...                     ...                      ...  \n",
       "1458                  8.84                   10.75                     9.34  \n",
       "1459                  9.62                    9.23                    10.87  \n",
       "1460                  9.44                    7.73                     9.17  \n",
       "1461                  8.98                   11.12                     8.67  \n",
       "1462                  5.79                   10.05                     9.38  \n",
       "1463                  9.44                    9.69                     9.23  \n",
       "1464                  8.52                     7.5                     4.09  \n",
       "1465                 11.79                    9.49                     4.06  \n",
       "1466                  9.44                    7.73                     9.17  \n",
       "1467                  8.84                   10.75                     9.34  \n",
       "1468                  8.52                     7.5                     4.09  \n",
       "1469                  5.79                   10.05                     9.38  \n",
       "1470                  8.98                   11.12                     8.67  \n",
       "1471                 11.79                    9.49                     4.06  \n",
       "1472                  8.84                   10.75                     9.34  \n",
       "1473                  9.44                    9.69                     9.23  \n",
       "1474                  8.52                     7.5                     4.09  \n",
       "1475                  9.62                    9.23                    10.87  \n",
       "1476                  8.84                   10.75                     9.34  \n",
       "1477                  5.79                   10.05                     9.38  \n",
       "1478                 11.79                    9.49                     4.06  \n",
       "1479                  9.44                    7.73                     9.17  \n",
       "1480                  9.62                    9.23                    10.87  \n",
       "1481                  9.44                    9.69                     9.23  \n",
       "1482                  8.98                   11.12                     8.67  \n",
       "1483                  5.79                   10.05                     9.38  \n",
       "1484                  8.84                   10.75                     9.34  \n",
       "1485                 11.79                    9.49                     4.06  \n",
       "1486                  9.44                    7.73                     9.17  \n",
       "1487                  8.52                     7.5                     4.09  \n",
       "\n",
       "[1488 rows x 11 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1[['Match_Number','Match_Year','Team_Codes','Bowling_Team_Codes','Net_Run_Rate','Prev_Run_Score_Rate','Prev_2_Run_Score_Rate','Prev_3_Run_Score_Rate','Prev_Run_Concede_Rate','Prev_2_Run_Concede_Rate','Prev_3_Run_Concede_Rate']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1.to_csv('Prev_3_Run_Rates_Runs_Conceded_IPL_Analysis_Version_2_1_Sorted_Full.csv', sep='|')"
   ]
  }
 ],
 "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}