Making CSV.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import os\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_l = []"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "for file_name in os.listdir('./processed_data/matches/'):\n",
    "    with open(os.path.join('./processed_data/matches/', file_name)) as f:\n",
    "        s = json.load(f)\n",
    "        df_l.append(s)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame.from_records(df_l)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>city</th>\n",
       "      <th>date</th>\n",
       "      <th>dl_applied</th>\n",
       "      <th>eliminator</th>\n",
       "      <th>id</th>\n",
       "      <th>overs</th>\n",
       "      <th>player_of_match</th>\n",
       "      <th>result</th>\n",
       "      <th>season</th>\n",
       "      <th>team1</th>\n",
       "      <th>team2</th>\n",
       "      <th>toss_decision</th>\n",
       "      <th>toss_winner</th>\n",
       "      <th>umpire1</th>\n",
       "      <th>umpire2</th>\n",
       "      <th>umpire3</th>\n",
       "      <th>venue</th>\n",
       "      <th>win_by_runs</th>\n",
       "      <th>win_by_wickets</th>\n",
       "      <th>winner</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Mumbai</td>\n",
       "      <td>2010-04-24</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>419164</td>\n",
       "      <td>20</td>\n",
       "      <td>A Kumble</td>\n",
       "      <td></td>\n",
       "      <td>2010</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>bat</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>RE Koertzen</td>\n",
       "      <td>SJA Taufel</td>\n",
       "      <td></td>\n",
       "      <td>Dr DY Patil Sports Academy</td>\n",
       "      <td></td>\n",
       "      <td>9</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Delhi</td>\n",
       "      <td>2010-03-29</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>419131</td>\n",
       "      <td>20</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td></td>\n",
       "      <td>2010</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>bat</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>SS Hazare</td>\n",
       "      <td>SJA Taufel</td>\n",
       "      <td></td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>40</td>\n",
       "      <td></td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mumbai</td>\n",
       "      <td>2008-05-16</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>336021</td>\n",
       "      <td>20</td>\n",
       "      <td>SM Pollock</td>\n",
       "      <td></td>\n",
       "      <td>2008</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>field</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>BR Doctrove</td>\n",
       "      <td>DJ Harper</td>\n",
       "      <td></td>\n",
       "      <td>Wankhede Stadium</td>\n",
       "      <td></td>\n",
       "      <td>8</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Pune</td>\n",
       "      <td>2016-04-22</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>980931</td>\n",
       "      <td>20</td>\n",
       "      <td>AB de Villiers</td>\n",
       "      <td></td>\n",
       "      <td>2016</td>\n",
       "      <td>Rising Pune Supergiants</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>field</td>\n",
       "      <td>Rising Pune Supergiants</td>\n",
       "      <td>CB Gaffaney</td>\n",
       "      <td>VK Sharma</td>\n",
       "      <td></td>\n",
       "      <td>Maharashtra Cricket Association Stadium</td>\n",
       "      <td>13</td>\n",
       "      <td></td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Mumbai</td>\n",
       "      <td>2010-04-22</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>419163</td>\n",
       "      <td>20</td>\n",
       "      <td>DE Bollinger</td>\n",
       "      <td></td>\n",
       "      <td>2010</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>bat</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>BR Doctrove</td>\n",
       "      <td>RB Tiffin</td>\n",
       "      <td></td>\n",
       "      <td>Dr DY Patil Sports Academy</td>\n",
       "      <td>38</td>\n",
       "      <td></td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>2010-04-02</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>419136</td>\n",
       "      <td>20</td>\n",
       "      <td>KP Pietersen</td>\n",
       "      <td></td>\n",
       "      <td>2010</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>bat</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>BF Bowden</td>\n",
       "      <td>M Erasmus</td>\n",
       "      <td></td>\n",
       "      <td>Punjab Cricket Association Stadium, Mohali</td>\n",
       "      <td></td>\n",
       "      <td>6</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Bangalore</td>\n",
       "      <td>2008-05-19</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>336026</td>\n",
       "      <td>20</td>\n",
       "      <td>SP Goswami</td>\n",
       "      <td></td>\n",
       "      <td>2008</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>field</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>SJ Davis</td>\n",
       "      <td>GA Pratapkumar</td>\n",
       "      <td></td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td></td>\n",
       "      <td>5</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Kolkata</td>\n",
       "      <td>2016-05-04</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>980963</td>\n",
       "      <td>20</td>\n",
       "      <td>AD Russell</td>\n",
       "      <td></td>\n",
       "      <td>2016</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>field</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>AK Chaudhary</td>\n",
       "      <td>HDPK Dharmasena</td>\n",
       "      <td></td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>7</td>\n",
       "      <td></td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Chennai</td>\n",
       "      <td>2011-05-01</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>501236</td>\n",
       "      <td>20</td>\n",
       "      <td>JA Morkel</td>\n",
       "      <td></td>\n",
       "      <td>2011</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>bat</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Aleem Dar</td>\n",
       "      <td>RB Tiffin</td>\n",
       "      <td></td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>19</td>\n",
       "      <td></td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Mumbai</td>\n",
       "      <td>2011-05-20</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>501263</td>\n",
       "      <td>20</td>\n",
       "      <td>SR Watson</td>\n",
       "      <td></td>\n",
       "      <td>2011</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>bat</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>RE Koertzen</td>\n",
       "      <td>PR Reiffel</td>\n",
       "      <td></td>\n",
       "      <td>Wankhede Stadium</td>\n",
       "      <td></td>\n",
       "      <td>10</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Mumbai</td>\n",
       "      <td>2014-05-30</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>734047</td>\n",
       "      <td>20</td>\n",
       "      <td>V Sehwag</td>\n",
       "      <td></td>\n",
       "      <td>2014</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>field</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>HDPK Dharmasena</td>\n",
       "      <td>RJ Tucker</td>\n",
       "      <td></td>\n",
       "      <td>Wankhede Stadium</td>\n",
       "      <td>24</td>\n",
       "      <td></td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>2008-04-19</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>335983</td>\n",
       "      <td>20</td>\n",
       "      <td>MEK Hussey</td>\n",
       "      <td></td>\n",
       "      <td>2008</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>bat</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>MR Benson</td>\n",
       "      <td>SL Shastri</td>\n",
       "      <td></td>\n",
       "      <td>Punjab Cricket Association Stadium, Mohali</td>\n",
       "      <td>33</td>\n",
       "      <td></td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>2017-04-19</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1082611</td>\n",
       "      <td>20</td>\n",
       "      <td>KS Williamson</td>\n",
       "      <td></td>\n",
       "      <td>2017</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>bat</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>CB Gaffaney</td>\n",
       "      <td>NJ Llong</td>\n",
       "      <td></td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>15</td>\n",
       "      <td></td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Kolkata</td>\n",
       "      <td>2017-05-13</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1082644</td>\n",
       "      <td>20</td>\n",
       "      <td>AT Rayudu</td>\n",
       "      <td></td>\n",
       "      <td>2017</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>field</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>A Nand Kishore</td>\n",
       "      <td>S Ravi</td>\n",
       "      <td></td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>9</td>\n",
       "      <td></td>\n",
       "      <td>Mumbai Indians</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Chennai</td>\n",
       "      <td>2015-04-09</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>829707</td>\n",
       "      <td>20</td>\n",
       "      <td>A Nehra</td>\n",
       "      <td></td>\n",
       "      <td>2015</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>field</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>RK Illingworth</td>\n",
       "      <td>VA Kulkarni</td>\n",
       "      <td></td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>1</td>\n",
       "      <td></td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Jaipur</td>\n",
       "      <td>2011-04-29</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>501231</td>\n",
       "      <td>20</td>\n",
       "      <td>J Botha</td>\n",
       "      <td></td>\n",
       "      <td>2011</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>field</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>Asad Rauf</td>\n",
       "      <td>SK Tarapore</td>\n",
       "      <td></td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td></td>\n",
       "      <td>7</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Dharamsala</td>\n",
       "      <td>2011-05-21</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>501264</td>\n",
       "      <td>20</td>\n",
       "      <td>S Dhawan</td>\n",
       "      <td></td>\n",
       "      <td>2011</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>field</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Asad Rauf</td>\n",
       "      <td>AM Saheba</td>\n",
       "      <td></td>\n",
       "      <td>Himachal Pradesh Cricket Association Stadium</td>\n",
       "      <td>82</td>\n",
       "      <td></td>\n",
       "      <td>Deccan Chargers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>2014-05-18</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>734015</td>\n",
       "      <td>20</td>\n",
       "      <td>UT Yadav</td>\n",
       "      <td></td>\n",
       "      <td>2014</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>bat</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>NJ Llong</td>\n",
       "      <td>CK Nandan</td>\n",
       "      <td></td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td></td>\n",
       "      <td>7</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>2012-04-12</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>548319</td>\n",
       "      <td>20</td>\n",
       "      <td>AD Mascarenhas</td>\n",
       "      <td></td>\n",
       "      <td>2012</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Pune Warriors</td>\n",
       "      <td>field</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>VA Kulkarni</td>\n",
       "      <td>SK Tarapore</td>\n",
       "      <td></td>\n",
       "      <td>Punjab Cricket Association Stadium, Mohali</td>\n",
       "      <td></td>\n",
       "      <td>7</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Rajkot</td>\n",
       "      <td>2017-04-23</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1082616</td>\n",
       "      <td>20</td>\n",
       "      <td>HM Amla</td>\n",
       "      <td></td>\n",
       "      <td>2017</td>\n",
       "      <td>Gujarat Lions</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>field</td>\n",
       "      <td>Gujarat Lions</td>\n",
       "      <td>AK Chaudhary</td>\n",
       "      <td>M Erasmus</td>\n",
       "      <td></td>\n",
       "      <td>Saurashtra Cricket Association Stadium</td>\n",
       "      <td>26</td>\n",
       "      <td></td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Kanpur</td>\n",
       "      <td>2017-05-13</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1082643</td>\n",
       "      <td>20</td>\n",
       "      <td>Mohammed Siraj</td>\n",
       "      <td></td>\n",
       "      <td>2017</td>\n",
       "      <td>Gujarat Lions</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>field</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>AK Chaudhary</td>\n",
       "      <td>Nitin Menon</td>\n",
       "      <td></td>\n",
       "      <td>Green Park</td>\n",
       "      <td></td>\n",
       "      <td>8</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Delhi</td>\n",
       "      <td>2008-04-19</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>335984</td>\n",
       "      <td>20</td>\n",
       "      <td>MF Maharoof</td>\n",
       "      <td></td>\n",
       "      <td>2008</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>bat</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>Aleem Dar</td>\n",
       "      <td>GA Pratapkumar</td>\n",
       "      <td></td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td></td>\n",
       "      <td>9</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Johannesburg</td>\n",
       "      <td>2009-05-16</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>392228</td>\n",
       "      <td>20</td>\n",
       "      <td>RG Sharma</td>\n",
       "      <td></td>\n",
       "      <td>2009</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>field</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>RE Koertzen</td>\n",
       "      <td>S Ravi</td>\n",
       "      <td></td>\n",
       "      <td>New Wanderers Stadium</td>\n",
       "      <td></td>\n",
       "      <td>6</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>2016-04-18</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>980923</td>\n",
       "      <td>20</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td></td>\n",
       "      <td>2016</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>field</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>HDPK Dharmasena</td>\n",
       "      <td>VK Sharma</td>\n",
       "      <td></td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td></td>\n",
       "      <td>7</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Kolkata</td>\n",
       "      <td>2016-05-14</td>\n",
       "      <td>D/L</td>\n",
       "      <td></td>\n",
       "      <td>980989</td>\n",
       "      <td>20</td>\n",
       "      <td>YK Pathan</td>\n",
       "      <td></td>\n",
       "      <td>2016</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Rising Pune Supergiants</td>\n",
       "      <td>bat</td>\n",
       "      <td>Rising Pune Supergiants</td>\n",
       "      <td>A Nand Kishore</td>\n",
       "      <td>BNJ Oxenford</td>\n",
       "      <td></td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td></td>\n",
       "      <td>8</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Rajkot</td>\n",
       "      <td>2017-04-07</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1082593</td>\n",
       "      <td>20</td>\n",
       "      <td>CA Lynn</td>\n",
       "      <td></td>\n",
       "      <td>2017</td>\n",
       "      <td>Gujarat Lions</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>field</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Nitin Menon</td>\n",
       "      <td>CK Nandan</td>\n",
       "      <td></td>\n",
       "      <td>Saurashtra Cricket Association Stadium</td>\n",
       "      <td></td>\n",
       "      <td>10</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Chennai</td>\n",
       "      <td>2008-05-24</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>336033</td>\n",
       "      <td>20</td>\n",
       "      <td>JA Morkel</td>\n",
       "      <td></td>\n",
       "      <td>2008</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>bat</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>DJ Harper</td>\n",
       "      <td>SL Shastri</td>\n",
       "      <td></td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>10</td>\n",
       "      <td></td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Kolkata</td>\n",
       "      <td>2015-05-24</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>829823</td>\n",
       "      <td>20</td>\n",
       "      <td>RG Sharma</td>\n",
       "      <td></td>\n",
       "      <td>2015</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>field</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>HDPK Dharmasena</td>\n",
       "      <td>RK Illingworth</td>\n",
       "      <td></td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>41</td>\n",
       "      <td></td>\n",
       "      <td>Mumbai Indians</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Bangalore</td>\n",
       "      <td>2010-03-23</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>419123</td>\n",
       "      <td>20</td>\n",
       "      <td>RV Uthappa</td>\n",
       "      <td></td>\n",
       "      <td>2010</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>field</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>RE Koertzen</td>\n",
       "      <td>RB Tiffin</td>\n",
       "      <td></td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>36</td>\n",
       "      <td></td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>2016-05-07</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>980971</td>\n",
       "      <td>20</td>\n",
       "      <td>MP Stoinis</td>\n",
       "      <td></td>\n",
       "      <td>2016</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>field</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>HDPK Dharmasena</td>\n",
       "      <td>CK Nandan</td>\n",
       "      <td></td>\n",
       "      <td>Punjab Cricket Association IS Bindra Stadium, ...</td>\n",
       "      <td>9</td>\n",
       "      <td></td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>716</th>\n",
       "      <td>Delhi</td>\n",
       "      <td>2016-04-27</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>980945</td>\n",
       "      <td>20</td>\n",
       "      <td>CH Morris</td>\n",
       "      <td></td>\n",
       "      <td>2016</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>Gujarat Lions</td>\n",
       "      <td>field</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>M Erasmus</td>\n",
       "      <td>S Ravi</td>\n",
       "      <td></td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>1</td>\n",
       "      <td></td>\n",
       "      <td>Gujarat Lions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>717</th>\n",
       "      <td>Rajkot</td>\n",
       "      <td>2017-04-29</td>\n",
       "      <td></td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>1082625</td>\n",
       "      <td>20</td>\n",
       "      <td>KH Pandya</td>\n",
       "      <td>tie</td>\n",
       "      <td>2017</td>\n",
       "      <td>Gujarat Lions</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>bat</td>\n",
       "      <td>Gujarat Lions</td>\n",
       "      <td>AK Chaudhary</td>\n",
       "      <td>CB Gaffaney</td>\n",
       "      <td></td>\n",
       "      <td>Saurashtra Cricket Association Stadium</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>718</th>\n",
       "      <td>Chennai</td>\n",
       "      <td>2012-05-25</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>548380</td>\n",
       "      <td>20</td>\n",
       "      <td>M Vijay</td>\n",
       "      <td></td>\n",
       "      <td>2012</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>field</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>BR Doctrove</td>\n",
       "      <td>SJA Taufel</td>\n",
       "      <td></td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk</td>\n",
       "      <td>86</td>\n",
       "      <td></td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>719</th>\n",
       "      <td>Kolkata</td>\n",
       "      <td>2015-05-07</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>829761</td>\n",
       "      <td>20</td>\n",
       "      <td>PP Chawla</td>\n",
       "      <td></td>\n",
       "      <td>2015</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>bat</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>AK Chaudhary</td>\n",
       "      <td>M Erasmus</td>\n",
       "      <td></td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>13</td>\n",
       "      <td></td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>Dharamsala</td>\n",
       "      <td>2011-05-15</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>501257</td>\n",
       "      <td>20</td>\n",
       "      <td>PP Chawla</td>\n",
       "      <td></td>\n",
       "      <td>2011</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>field</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>Asad Rauf</td>\n",
       "      <td>SL Shastri</td>\n",
       "      <td></td>\n",
       "      <td>Himachal Pradesh Cricket Association Stadium</td>\n",
       "      <td>29</td>\n",
       "      <td></td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>721</th>\n",
       "      <td>Mumbai</td>\n",
       "      <td>2011-04-10</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>501202</td>\n",
       "      <td>20</td>\n",
       "      <td>SB Wagh</td>\n",
       "      <td></td>\n",
       "      <td>2011</td>\n",
       "      <td>Pune Warriors</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>bat</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>BR Doctrove</td>\n",
       "      <td>PR Reiffel</td>\n",
       "      <td></td>\n",
       "      <td>Dr DY Patil Sports Academy</td>\n",
       "      <td></td>\n",
       "      <td>7</td>\n",
       "      <td>Pune Warriors</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>722</th>\n",
       "      <td>Bangalore</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>733999</td>\n",
       "      <td>20</td>\n",
       "      <td>JP Faulkner</td>\n",
       "      <td></td>\n",
       "      <td>2014</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>bat</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>S Ravi</td>\n",
       "      <td>RJ Tucker</td>\n",
       "      <td></td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td></td>\n",
       "      <td>5</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>723</th>\n",
       "      <td>Jaipur</td>\n",
       "      <td>2013-04-17</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>598019</td>\n",
       "      <td>20</td>\n",
       "      <td>AM Rahane</td>\n",
       "      <td></td>\n",
       "      <td>2013</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>bat</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>Aleem Dar</td>\n",
       "      <td>C Shamshuddin</td>\n",
       "      <td></td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>87</td>\n",
       "      <td></td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>724</th>\n",
       "      <td>Kolkata</td>\n",
       "      <td>2017-04-28</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1082622</td>\n",
       "      <td>20</td>\n",
       "      <td>G Gambhir</td>\n",
       "      <td></td>\n",
       "      <td>2017</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>field</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>NJ Llong</td>\n",
       "      <td>S Ravi</td>\n",
       "      <td></td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td></td>\n",
       "      <td>7</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>725</th>\n",
       "      <td>Pune</td>\n",
       "      <td>2012-05-22</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>548378</td>\n",
       "      <td>20</td>\n",
       "      <td>YK Pathan</td>\n",
       "      <td></td>\n",
       "      <td>2012</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>bat</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>BR Doctrove</td>\n",
       "      <td>SJA Taufel</td>\n",
       "      <td></td>\n",
       "      <td>Subrata Roy Sahara Stadium</td>\n",
       "      <td>18</td>\n",
       "      <td></td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>726</th>\n",
       "      <td>Indore</td>\n",
       "      <td>2018-05-14</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1136608</td>\n",
       "      <td>20</td>\n",
       "      <td>UT Yadav</td>\n",
       "      <td></td>\n",
       "      <td>2018</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>field</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>BNJ Oxenford</td>\n",
       "      <td>VK Sharma</td>\n",
       "      <td></td>\n",
       "      <td>Holkar Cricket Stadium</td>\n",
       "      <td></td>\n",
       "      <td>10</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>727</th>\n",
       "      <td>Durban</td>\n",
       "      <td>2009-04-29</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>392199</td>\n",
       "      <td>20</td>\n",
       "      <td>MV Boucher</td>\n",
       "      <td></td>\n",
       "      <td>2009</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>bat</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>MR Benson</td>\n",
       "      <td>TH Wijewardene</td>\n",
       "      <td></td>\n",
       "      <td>Kingsmead</td>\n",
       "      <td></td>\n",
       "      <td>5</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>728</th>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>2014-05-20</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>734021</td>\n",
       "      <td>20</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td></td>\n",
       "      <td>2014</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>bat</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>AK Chaudhary</td>\n",
       "      <td>NJ Llong</td>\n",
       "      <td></td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td></td>\n",
       "      <td>7</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>729</th>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>2015-05-11</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>829799</td>\n",
       "      <td>20</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td></td>\n",
       "      <td>2015</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>bat</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>AK Chaudhary</td>\n",
       "      <td>HDPK Dharmasena</td>\n",
       "      <td></td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>5</td>\n",
       "      <td></td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>730</th>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>2011-05-10</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>501250</td>\n",
       "      <td>20</td>\n",
       "      <td>MR Marsh</td>\n",
       "      <td></td>\n",
       "      <td>2011</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>Pune Warriors</td>\n",
       "      <td>bat</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>Asad Rauf</td>\n",
       "      <td>AM Saheba</td>\n",
       "      <td></td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td></td>\n",
       "      <td>6</td>\n",
       "      <td>Pune Warriors</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>731</th>\n",
       "      <td>Pune</td>\n",
       "      <td>2015-04-18</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>829733</td>\n",
       "      <td>20</td>\n",
       "      <td>AD Russell</td>\n",
       "      <td></td>\n",
       "      <td>2015</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>field</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>SD Fry</td>\n",
       "      <td>CK Nandan</td>\n",
       "      <td></td>\n",
       "      <td>Maharashtra Cricket Association Stadium</td>\n",
       "      <td></td>\n",
       "      <td>4</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>732</th>\n",
       "      <td>Bangalore</td>\n",
       "      <td>2011-04-12</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>501205</td>\n",
       "      <td>20</td>\n",
       "      <td>SR Tendulkar</td>\n",
       "      <td></td>\n",
       "      <td>2011</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>field</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>HDPK Dharmasena</td>\n",
       "      <td>AL Hill</td>\n",
       "      <td></td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td></td>\n",
       "      <td>9</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>733</th>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>2016-04-11</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>980905</td>\n",
       "      <td>20</td>\n",
       "      <td>AJ Finch</td>\n",
       "      <td></td>\n",
       "      <td>2016</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Gujarat Lions</td>\n",
       "      <td>field</td>\n",
       "      <td>Gujarat Lions</td>\n",
       "      <td>AK Chaudhary</td>\n",
       "      <td>VA Kulkarni</td>\n",
       "      <td></td>\n",
       "      <td>Punjab Cricket Association IS Bindra Stadium, ...</td>\n",
       "      <td></td>\n",
       "      <td>5</td>\n",
       "      <td>Gujarat Lions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>734</th>\n",
       "      <td>Mumbai</td>\n",
       "      <td>2008-06-01</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>336040</td>\n",
       "      <td>20</td>\n",
       "      <td>YK Pathan</td>\n",
       "      <td></td>\n",
       "      <td>2008</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>field</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>BF Bowden</td>\n",
       "      <td>RE Koertzen</td>\n",
       "      <td></td>\n",
       "      <td>Dr DY Patil Sports Academy</td>\n",
       "      <td></td>\n",
       "      <td>3</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>735</th>\n",
       "      <td>Mumbai</td>\n",
       "      <td>2015-05-14</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>829805</td>\n",
       "      <td>20</td>\n",
       "      <td>HH Pandya</td>\n",
       "      <td></td>\n",
       "      <td>2015</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>field</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>RK Illingworth</td>\n",
       "      <td>VA Kulkarni</td>\n",
       "      <td></td>\n",
       "      <td>Wankhede Stadium</td>\n",
       "      <td>5</td>\n",
       "      <td></td>\n",
       "      <td>Mumbai Indians</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>736</th>\n",
       "      <td>Jaipur</td>\n",
       "      <td>2008-05-11</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>336015</td>\n",
       "      <td>20</td>\n",
       "      <td>SR Watson</td>\n",
       "      <td></td>\n",
       "      <td>2008</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>field</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>SJ Davis</td>\n",
       "      <td>RE Koertzen</td>\n",
       "      <td></td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td></td>\n",
       "      <td>3</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>737</th>\n",
       "      <td>Jaipur</td>\n",
       "      <td>2010-04-11</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>419150</td>\n",
       "      <td>20</td>\n",
       "      <td>SR Tendulkar</td>\n",
       "      <td></td>\n",
       "      <td>2010</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>field</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>BR Doctrove</td>\n",
       "      <td>SK Tarapore</td>\n",
       "      <td></td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>37</td>\n",
       "      <td></td>\n",
       "      <td>Mumbai Indians</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>738</th>\n",
       "      <td>Pune</td>\n",
       "      <td>2016-05-01</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>980957</td>\n",
       "      <td>20</td>\n",
       "      <td>RG Sharma</td>\n",
       "      <td></td>\n",
       "      <td>2016</td>\n",
       "      <td>Rising Pune Supergiants</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>field</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>AY Dandekar</td>\n",
       "      <td>RJ Tucker</td>\n",
       "      <td></td>\n",
       "      <td>Maharashtra Cricket Association Stadium</td>\n",
       "      <td></td>\n",
       "      <td>8</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>739</th>\n",
       "      <td>Indore</td>\n",
       "      <td>2018-05-06</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1136598</td>\n",
       "      <td>20</td>\n",
       "      <td>Mujeeb Ur Rahman</td>\n",
       "      <td></td>\n",
       "      <td>2018</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>field</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>C Shamshuddin</td>\n",
       "      <td>S Ravi</td>\n",
       "      <td></td>\n",
       "      <td>Holkar Cricket Stadium</td>\n",
       "      <td></td>\n",
       "      <td>6</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>740</th>\n",
       "      <td>Kolkata</td>\n",
       "      <td>2016-05-22</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>981009</td>\n",
       "      <td>20</td>\n",
       "      <td>YK Pathan</td>\n",
       "      <td></td>\n",
       "      <td>2016</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>field</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>KN Ananthapadmanabhan</td>\n",
       "      <td>M Erasmus</td>\n",
       "      <td></td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>22</td>\n",
       "      <td></td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>741</th>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>2018-04-12</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1136567</td>\n",
       "      <td>20</td>\n",
       "      <td>Rashid Khan</td>\n",
       "      <td></td>\n",
       "      <td>2018</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>field</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>NJ Llong</td>\n",
       "      <td>CK Nandan</td>\n",
       "      <td></td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>742</th>\n",
       "      <td>East London</td>\n",
       "      <td>2009-05-04</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>392209</td>\n",
       "      <td>20</td>\n",
       "      <td>MS Dhoni</td>\n",
       "      <td></td>\n",
       "      <td>2009</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>bat</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>BR Doctrove</td>\n",
       "      <td>M Erasmus</td>\n",
       "      <td></td>\n",
       "      <td>Buffalo Park</td>\n",
       "      <td>78</td>\n",
       "      <td></td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>743</th>\n",
       "      <td>Bangalore</td>\n",
       "      <td>2008-05-28</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>336012</td>\n",
       "      <td>20</td>\n",
       "      <td>CRD Fernando</td>\n",
       "      <td></td>\n",
       "      <td>2008</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>field</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>BF Bowden</td>\n",
       "      <td>AV Jayaprakash</td>\n",
       "      <td></td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td></td>\n",
       "      <td>9</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td></td>\n",
       "      <td>2014-04-28</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>729313</td>\n",
       "      <td>20</td>\n",
       "      <td>Sandeep Sharma</td>\n",
       "      <td></td>\n",
       "      <td>2014</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>field</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>BF Bowden</td>\n",
       "      <td>S Ravi</td>\n",
       "      <td></td>\n",
       "      <td>Dubai International Cricket Stadium</td>\n",
       "      <td></td>\n",
       "      <td>5</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>745</th>\n",
       "      <td>Bangalore</td>\n",
       "      <td>2010-04-17</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>419157</td>\n",
       "      <td>20</td>\n",
       "      <td>R McLaren</td>\n",
       "      <td></td>\n",
       "      <td>2010</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>field</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>HDPK Dharmasena</td>\n",
       "      <td>SJA Taufel</td>\n",
       "      <td></td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>57</td>\n",
       "      <td></td>\n",
       "      <td>Mumbai Indians</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>746 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             city        date dl_applied      eliminator       id  overs  \\\n",
       "0          Mumbai  2010-04-24                              419164     20   \n",
       "1           Delhi  2010-03-29                              419131     20   \n",
       "2          Mumbai  2008-05-16                              336021     20   \n",
       "3            Pune  2016-04-22                              980931     20   \n",
       "4          Mumbai  2010-04-22                              419163     20   \n",
       "5      Chandigarh  2010-04-02                              419136     20   \n",
       "6       Bangalore  2008-05-19                              336026     20   \n",
       "7         Kolkata  2016-05-04                              980963     20   \n",
       "8         Chennai  2011-05-01                              501236     20   \n",
       "9          Mumbai  2011-05-20                              501263     20   \n",
       "10         Mumbai  2014-05-30                              734047     20   \n",
       "11     Chandigarh  2008-04-19                              335983     20   \n",
       "12      Hyderabad  2017-04-19                             1082611     20   \n",
       "13        Kolkata  2017-05-13                             1082644     20   \n",
       "14        Chennai  2015-04-09                              829707     20   \n",
       "15         Jaipur  2011-04-29                              501231     20   \n",
       "16     Dharamsala  2011-05-21                              501264     20   \n",
       "17      Hyderabad  2014-05-18                              734015     20   \n",
       "18     Chandigarh  2012-04-12                              548319     20   \n",
       "19         Rajkot  2017-04-23                             1082616     20   \n",
       "20         Kanpur  2017-05-13                             1082643     20   \n",
       "21          Delhi  2008-04-19                              335984     20   \n",
       "22   Johannesburg  2009-05-16                              392228     20   \n",
       "23      Hyderabad  2016-04-18                              980923     20   \n",
       "24        Kolkata  2016-05-14        D/L                   980989     20   \n",
       "25         Rajkot  2017-04-07                             1082593     20   \n",
       "26        Chennai  2008-05-24                              336033     20   \n",
       "27        Kolkata  2015-05-24                              829823     20   \n",
       "28      Bangalore  2010-03-23                              419123     20   \n",
       "29     Chandigarh  2016-05-07                              980971     20   \n",
       "..            ...         ...        ...             ...      ...    ...   \n",
       "716         Delhi  2016-04-27                              980945     20   \n",
       "717        Rajkot  2017-04-29             Mumbai Indians  1082625     20   \n",
       "718       Chennai  2012-05-25                              548380     20   \n",
       "719       Kolkata  2015-05-07                              829761     20   \n",
       "720    Dharamsala  2011-05-15                              501257     20   \n",
       "721        Mumbai  2011-04-10                              501202     20   \n",
       "722     Bangalore  2014-05-11                              733999     20   \n",
       "723        Jaipur  2013-04-17                              598019     20   \n",
       "724       Kolkata  2017-04-28                             1082622     20   \n",
       "725          Pune  2012-05-22                              548378     20   \n",
       "726        Indore  2018-05-14                             1136608     20   \n",
       "727        Durban  2009-04-29                              392199     20   \n",
       "728     Hyderabad  2014-05-20                              734021     20   \n",
       "729     Hyderabad  2015-05-11                              829799     20   \n",
       "730     Hyderabad  2011-05-10                              501250     20   \n",
       "731          Pune  2015-04-18                              829733     20   \n",
       "732     Bangalore  2011-04-12                              501205     20   \n",
       "733    Chandigarh  2016-04-11                              980905     20   \n",
       "734        Mumbai  2008-06-01                              336040     20   \n",
       "735        Mumbai  2015-05-14                              829805     20   \n",
       "736        Jaipur  2008-05-11                              336015     20   \n",
       "737        Jaipur  2010-04-11                              419150     20   \n",
       "738          Pune  2016-05-01                              980957     20   \n",
       "739        Indore  2018-05-06                             1136598     20   \n",
       "740       Kolkata  2016-05-22                              981009     20   \n",
       "741     Hyderabad  2018-04-12                             1136567     20   \n",
       "742   East London  2009-05-04                              392209     20   \n",
       "743     Bangalore  2008-05-28                              336012     20   \n",
       "744                2014-04-28                              729313     20   \n",
       "745     Bangalore  2010-04-17                              419157     20   \n",
       "\n",
       "      player_of_match result  season                        team1  \\\n",
       "0            A Kumble           2010  Royal Challengers Bangalore   \n",
       "1           DA Warner           2010             Delhi Daredevils   \n",
       "2          SM Pollock           2008               Mumbai Indians   \n",
       "3      AB de Villiers           2016      Rising Pune Supergiants   \n",
       "4        DE Bollinger           2010          Chennai Super Kings   \n",
       "5        KP Pietersen           2010              Kings XI Punjab   \n",
       "6          SP Goswami           2008  Royal Challengers Bangalore   \n",
       "7          AD Russell           2016        Kolkata Knight Riders   \n",
       "8           JA Morkel           2011          Chennai Super Kings   \n",
       "9           SR Watson           2011               Mumbai Indians   \n",
       "10           V Sehwag           2014          Chennai Super Kings   \n",
       "11         MEK Hussey           2008              Kings XI Punjab   \n",
       "12      KS Williamson           2017          Sunrisers Hyderabad   \n",
       "13          AT Rayudu           2017        Kolkata Knight Riders   \n",
       "14            A Nehra           2015          Chennai Super Kings   \n",
       "15            J Botha           2011             Rajasthan Royals   \n",
       "16           S Dhawan           2011              Kings XI Punjab   \n",
       "17           UT Yadav           2014          Sunrisers Hyderabad   \n",
       "18     AD Mascarenhas           2012              Kings XI Punjab   \n",
       "19            HM Amla           2017                Gujarat Lions   \n",
       "20     Mohammed Siraj           2017                Gujarat Lions   \n",
       "21        MF Maharoof           2008             Delhi Daredevils   \n",
       "22          RG Sharma           2009              Deccan Chargers   \n",
       "23          DA Warner           2016          Sunrisers Hyderabad   \n",
       "24          YK Pathan           2016        Kolkata Knight Riders   \n",
       "25            CA Lynn           2017                Gujarat Lions   \n",
       "26          JA Morkel           2008          Chennai Super Kings   \n",
       "27          RG Sharma           2015               Mumbai Indians   \n",
       "28         RV Uthappa           2010  Royal Challengers Bangalore   \n",
       "29         MP Stoinis           2016              Kings XI Punjab   \n",
       "..                ...    ...     ...                          ...   \n",
       "716         CH Morris           2016             Delhi Daredevils   \n",
       "717         KH Pandya    tie    2017                Gujarat Lions   \n",
       "718           M Vijay           2012             Delhi Daredevils   \n",
       "719         PP Chawla           2015        Kolkata Knight Riders   \n",
       "720         PP Chawla           2011              Kings XI Punjab   \n",
       "721           SB Wagh           2011                Pune Warriors   \n",
       "722       JP Faulkner           2014  Royal Challengers Bangalore   \n",
       "723         AM Rahane           2013             Rajasthan Royals   \n",
       "724         G Gambhir           2017        Kolkata Knight Riders   \n",
       "725         YK Pathan           2012             Delhi Daredevils   \n",
       "726          UT Yadav           2018              Kings XI Punjab   \n",
       "727        MV Boucher           2009  Royal Challengers Bangalore   \n",
       "728         DA Warner           2014          Sunrisers Hyderabad   \n",
       "729         DA Warner           2015          Sunrisers Hyderabad   \n",
       "730          MR Marsh           2011              Deccan Chargers   \n",
       "731        AD Russell           2015              Kings XI Punjab   \n",
       "732      SR Tendulkar           2011  Royal Challengers Bangalore   \n",
       "733          AJ Finch           2016              Kings XI Punjab   \n",
       "734         YK Pathan           2008          Chennai Super Kings   \n",
       "735         HH Pandya           2015               Mumbai Indians   \n",
       "736         SR Watson           2008             Rajasthan Royals   \n",
       "737      SR Tendulkar           2010             Rajasthan Royals   \n",
       "738         RG Sharma           2016      Rising Pune Supergiants   \n",
       "739  Mujeeb Ur Rahman           2018              Kings XI Punjab   \n",
       "740         YK Pathan           2016        Kolkata Knight Riders   \n",
       "741       Rashid Khan           2018          Sunrisers Hyderabad   \n",
       "742          MS Dhoni           2009          Chennai Super Kings   \n",
       "743      CRD Fernando           2008  Royal Challengers Bangalore   \n",
       "744    Sandeep Sharma           2014              Kings XI Punjab   \n",
       "745         R McLaren           2010  Royal Challengers Bangalore   \n",
       "\n",
       "                           team2 toss_decision                  toss_winner  \\\n",
       "0                Deccan Chargers           bat              Deccan Chargers   \n",
       "1          Kolkata Knight Riders           bat             Delhi Daredevils   \n",
       "2          Kolkata Knight Riders         field               Mumbai Indians   \n",
       "3    Royal Challengers Bangalore         field      Rising Pune Supergiants   \n",
       "4                Deccan Chargers           bat          Chennai Super Kings   \n",
       "5    Royal Challengers Bangalore           bat              Kings XI Punjab   \n",
       "6               Delhi Daredevils         field             Delhi Daredevils   \n",
       "7                Kings XI Punjab         field              Kings XI Punjab   \n",
       "8                Deccan Chargers           bat          Chennai Super Kings   \n",
       "9               Rajasthan Royals           bat               Mumbai Indians   \n",
       "10               Kings XI Punjab         field          Chennai Super Kings   \n",
       "11           Chennai Super Kings           bat          Chennai Super Kings   \n",
       "12              Delhi Daredevils           bat          Sunrisers Hyderabad   \n",
       "13                Mumbai Indians         field        Kolkata Knight Riders   \n",
       "14              Delhi Daredevils         field             Delhi Daredevils   \n",
       "15                Mumbai Indians         field             Rajasthan Royals   \n",
       "16               Deccan Chargers         field              Kings XI Punjab   \n",
       "17         Kolkata Knight Riders           bat          Sunrisers Hyderabad   \n",
       "18                 Pune Warriors         field              Kings XI Punjab   \n",
       "19               Kings XI Punjab         field                Gujarat Lions   \n",
       "20           Sunrisers Hyderabad         field          Sunrisers Hyderabad   \n",
       "21              Rajasthan Royals           bat             Rajasthan Royals   \n",
       "22         Kolkata Knight Riders         field              Deccan Chargers   \n",
       "23                Mumbai Indians         field          Sunrisers Hyderabad   \n",
       "24       Rising Pune Supergiants           bat      Rising Pune Supergiants   \n",
       "25         Kolkata Knight Riders         field        Kolkata Knight Riders   \n",
       "26              Rajasthan Royals           bat             Rajasthan Royals   \n",
       "27           Chennai Super Kings         field          Chennai Super Kings   \n",
       "28           Chennai Super Kings         field          Chennai Super Kings   \n",
       "29              Delhi Daredevils         field             Delhi Daredevils   \n",
       "..                           ...           ...                          ...   \n",
       "716                Gujarat Lions         field             Delhi Daredevils   \n",
       "717               Mumbai Indians           bat                Gujarat Lions   \n",
       "718          Chennai Super Kings         field             Delhi Daredevils   \n",
       "719             Delhi Daredevils           bat        Kolkata Knight Riders   \n",
       "720             Delhi Daredevils         field             Delhi Daredevils   \n",
       "721              Kings XI Punjab           bat              Kings XI Punjab   \n",
       "722             Rajasthan Royals           bat  Royal Challengers Bangalore   \n",
       "723               Mumbai Indians           bat             Rajasthan Royals   \n",
       "724             Delhi Daredevils         field        Kolkata Knight Riders   \n",
       "725        Kolkata Knight Riders           bat        Kolkata Knight Riders   \n",
       "726  Royal Challengers Bangalore         field  Royal Challengers Bangalore   \n",
       "727        Kolkata Knight Riders           bat        Kolkata Knight Riders   \n",
       "728  Royal Challengers Bangalore           bat  Royal Challengers Bangalore   \n",
       "729              Kings XI Punjab           bat          Sunrisers Hyderabad   \n",
       "730                Pune Warriors           bat              Deccan Chargers   \n",
       "731        Kolkata Knight Riders         field        Kolkata Knight Riders   \n",
       "732               Mumbai Indians         field               Mumbai Indians   \n",
       "733                Gujarat Lions         field                Gujarat Lions   \n",
       "734             Rajasthan Royals         field             Rajasthan Royals   \n",
       "735        Kolkata Knight Riders         field        Kolkata Knight Riders   \n",
       "736             Delhi Daredevils         field             Rajasthan Royals   \n",
       "737               Mumbai Indians         field             Rajasthan Royals   \n",
       "738               Mumbai Indians         field               Mumbai Indians   \n",
       "739             Rajasthan Royals         field              Kings XI Punjab   \n",
       "740          Sunrisers Hyderabad         field          Sunrisers Hyderabad   \n",
       "741               Mumbai Indians         field          Sunrisers Hyderabad   \n",
       "742              Deccan Chargers           bat          Chennai Super Kings   \n",
       "743               Mumbai Indians         field               Mumbai Indians   \n",
       "744  Royal Challengers Bangalore         field              Kings XI Punjab   \n",
       "745               Mumbai Indians         field  Royal Challengers Bangalore   \n",
       "\n",
       "                   umpire1          umpire2 umpire3  \\\n",
       "0              RE Koertzen       SJA Taufel           \n",
       "1                SS Hazare       SJA Taufel           \n",
       "2              BR Doctrove        DJ Harper           \n",
       "3              CB Gaffaney        VK Sharma           \n",
       "4              BR Doctrove        RB Tiffin           \n",
       "5                BF Bowden        M Erasmus           \n",
       "6                 SJ Davis   GA Pratapkumar           \n",
       "7             AK Chaudhary  HDPK Dharmasena           \n",
       "8                Aleem Dar        RB Tiffin           \n",
       "9              RE Koertzen       PR Reiffel           \n",
       "10         HDPK Dharmasena        RJ Tucker           \n",
       "11               MR Benson       SL Shastri           \n",
       "12             CB Gaffaney         NJ Llong           \n",
       "13          A Nand Kishore           S Ravi           \n",
       "14          RK Illingworth      VA Kulkarni           \n",
       "15               Asad Rauf      SK Tarapore           \n",
       "16               Asad Rauf        AM Saheba           \n",
       "17                NJ Llong        CK Nandan           \n",
       "18             VA Kulkarni      SK Tarapore           \n",
       "19            AK Chaudhary        M Erasmus           \n",
       "20            AK Chaudhary      Nitin Menon           \n",
       "21               Aleem Dar   GA Pratapkumar           \n",
       "22             RE Koertzen           S Ravi           \n",
       "23         HDPK Dharmasena        VK Sharma           \n",
       "24          A Nand Kishore     BNJ Oxenford           \n",
       "25             Nitin Menon        CK Nandan           \n",
       "26               DJ Harper       SL Shastri           \n",
       "27         HDPK Dharmasena   RK Illingworth           \n",
       "28             RE Koertzen        RB Tiffin           \n",
       "29         HDPK Dharmasena        CK Nandan           \n",
       "..                     ...              ...     ...   \n",
       "716              M Erasmus           S Ravi           \n",
       "717           AK Chaudhary      CB Gaffaney           \n",
       "718            BR Doctrove       SJA Taufel           \n",
       "719           AK Chaudhary        M Erasmus           \n",
       "720              Asad Rauf       SL Shastri           \n",
       "721            BR Doctrove       PR Reiffel           \n",
       "722                 S Ravi        RJ Tucker           \n",
       "723              Aleem Dar    C Shamshuddin           \n",
       "724               NJ Llong           S Ravi           \n",
       "725            BR Doctrove       SJA Taufel           \n",
       "726           BNJ Oxenford        VK Sharma           \n",
       "727              MR Benson   TH Wijewardene           \n",
       "728           AK Chaudhary         NJ Llong           \n",
       "729           AK Chaudhary  HDPK Dharmasena           \n",
       "730              Asad Rauf        AM Saheba           \n",
       "731                 SD Fry        CK Nandan           \n",
       "732        HDPK Dharmasena          AL Hill           \n",
       "733           AK Chaudhary      VA Kulkarni           \n",
       "734              BF Bowden      RE Koertzen           \n",
       "735         RK Illingworth      VA Kulkarni           \n",
       "736               SJ Davis      RE Koertzen           \n",
       "737            BR Doctrove      SK Tarapore           \n",
       "738            AY Dandekar        RJ Tucker           \n",
       "739          C Shamshuddin           S Ravi           \n",
       "740  KN Ananthapadmanabhan        M Erasmus           \n",
       "741               NJ Llong        CK Nandan           \n",
       "742            BR Doctrove        M Erasmus           \n",
       "743              BF Bowden   AV Jayaprakash           \n",
       "744              BF Bowden           S Ravi           \n",
       "745        HDPK Dharmasena       SJA Taufel           \n",
       "\n",
       "                                                 venue win_by_runs  \\\n",
       "0                           Dr DY Patil Sports Academy               \n",
       "1                                     Feroz Shah Kotla          40   \n",
       "2                                     Wankhede Stadium               \n",
       "3              Maharashtra Cricket Association Stadium          13   \n",
       "4                           Dr DY Patil Sports Academy          38   \n",
       "5           Punjab Cricket Association Stadium, Mohali               \n",
       "6                                M Chinnaswamy Stadium               \n",
       "7                                         Eden Gardens           7   \n",
       "8                      MA Chidambaram Stadium, Chepauk          19   \n",
       "9                                     Wankhede Stadium               \n",
       "10                                    Wankhede Stadium          24   \n",
       "11          Punjab Cricket Association Stadium, Mohali          33   \n",
       "12           Rajiv Gandhi International Stadium, Uppal          15   \n",
       "13                                        Eden Gardens           9   \n",
       "14                     MA Chidambaram Stadium, Chepauk           1   \n",
       "15                              Sawai Mansingh Stadium               \n",
       "16        Himachal Pradesh Cricket Association Stadium          82   \n",
       "17           Rajiv Gandhi International Stadium, Uppal               \n",
       "18          Punjab Cricket Association Stadium, Mohali               \n",
       "19              Saurashtra Cricket Association Stadium          26   \n",
       "20                                          Green Park               \n",
       "21                                    Feroz Shah Kotla               \n",
       "22                               New Wanderers Stadium               \n",
       "23           Rajiv Gandhi International Stadium, Uppal               \n",
       "24                                        Eden Gardens               \n",
       "25              Saurashtra Cricket Association Stadium               \n",
       "26                     MA Chidambaram Stadium, Chepauk          10   \n",
       "27                                        Eden Gardens          41   \n",
       "28                               M Chinnaswamy Stadium          36   \n",
       "29   Punjab Cricket Association IS Bindra Stadium, ...           9   \n",
       "..                                                 ...         ...   \n",
       "716                                   Feroz Shah Kotla           1   \n",
       "717             Saurashtra Cricket Association Stadium               \n",
       "718                    MA Chidambaram Stadium, Chepauk          86   \n",
       "719                                       Eden Gardens          13   \n",
       "720       Himachal Pradesh Cricket Association Stadium          29   \n",
       "721                         Dr DY Patil Sports Academy               \n",
       "722                              M Chinnaswamy Stadium               \n",
       "723                             Sawai Mansingh Stadium          87   \n",
       "724                                       Eden Gardens               \n",
       "725                         Subrata Roy Sahara Stadium          18   \n",
       "726                             Holkar Cricket Stadium               \n",
       "727                                          Kingsmead               \n",
       "728          Rajiv Gandhi International Stadium, Uppal               \n",
       "729          Rajiv Gandhi International Stadium, Uppal           5   \n",
       "730          Rajiv Gandhi International Stadium, Uppal               \n",
       "731            Maharashtra Cricket Association Stadium               \n",
       "732                              M Chinnaswamy Stadium               \n",
       "733  Punjab Cricket Association IS Bindra Stadium, ...               \n",
       "734                         Dr DY Patil Sports Academy               \n",
       "735                                   Wankhede Stadium           5   \n",
       "736                             Sawai Mansingh Stadium               \n",
       "737                             Sawai Mansingh Stadium          37   \n",
       "738            Maharashtra Cricket Association Stadium               \n",
       "739                             Holkar Cricket Stadium               \n",
       "740                                       Eden Gardens          22   \n",
       "741          Rajiv Gandhi International Stadium, Uppal               \n",
       "742                                       Buffalo Park          78   \n",
       "743                              M Chinnaswamy Stadium               \n",
       "744                Dubai International Cricket Stadium               \n",
       "745                              M Chinnaswamy Stadium          57   \n",
       "\n",
       "    win_by_wickets                       winner  \n",
       "0                9  Royal Challengers Bangalore  \n",
       "1                              Delhi Daredevils  \n",
       "2                8               Mumbai Indians  \n",
       "3                   Royal Challengers Bangalore  \n",
       "4                           Chennai Super Kings  \n",
       "5                6  Royal Challengers Bangalore  \n",
       "6                5             Delhi Daredevils  \n",
       "7                         Kolkata Knight Riders  \n",
       "8                           Chennai Super Kings  \n",
       "9               10             Rajasthan Royals  \n",
       "10                              Kings XI Punjab  \n",
       "11                          Chennai Super Kings  \n",
       "12                          Sunrisers Hyderabad  \n",
       "13                               Mumbai Indians  \n",
       "14                          Chennai Super Kings  \n",
       "15               7             Rajasthan Royals  \n",
       "16                              Deccan Chargers  \n",
       "17               7        Kolkata Knight Riders  \n",
       "18               7              Kings XI Punjab  \n",
       "19                              Kings XI Punjab  \n",
       "20               8          Sunrisers Hyderabad  \n",
       "21               9             Delhi Daredevils  \n",
       "22               6              Deccan Chargers  \n",
       "23               7          Sunrisers Hyderabad  \n",
       "24               8        Kolkata Knight Riders  \n",
       "25              10        Kolkata Knight Riders  \n",
       "26                             Rajasthan Royals  \n",
       "27                               Mumbai Indians  \n",
       "28                  Royal Challengers Bangalore  \n",
       "29                              Kings XI Punjab  \n",
       "..             ...                          ...  \n",
       "716                               Gujarat Lions  \n",
       "717                                              \n",
       "718                         Chennai Super Kings  \n",
       "719                       Kolkata Knight Riders  \n",
       "720                             Kings XI Punjab  \n",
       "721              7                Pune Warriors  \n",
       "722              5             Rajasthan Royals  \n",
       "723                            Rajasthan Royals  \n",
       "724              7        Kolkata Knight Riders  \n",
       "725                       Kolkata Knight Riders  \n",
       "726             10  Royal Challengers Bangalore  \n",
       "727              5  Royal Challengers Bangalore  \n",
       "728              7          Sunrisers Hyderabad  \n",
       "729                         Sunrisers Hyderabad  \n",
       "730              6                Pune Warriors  \n",
       "731              4        Kolkata Knight Riders  \n",
       "732              9               Mumbai Indians  \n",
       "733              5                Gujarat Lions  \n",
       "734              3             Rajasthan Royals  \n",
       "735                              Mumbai Indians  \n",
       "736              3             Rajasthan Royals  \n",
       "737                              Mumbai Indians  \n",
       "738              8               Mumbai Indians  \n",
       "739              6              Kings XI Punjab  \n",
       "740                       Kolkata Knight Riders  \n",
       "741              1          Sunrisers Hyderabad  \n",
       "742                         Chennai Super Kings  \n",
       "743              9               Mumbai Indians  \n",
       "744              5              Kings XI Punjab  \n",
       "745                              Mumbai Indians  \n",
       "\n",
       "[746 rows x 20 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('matches.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_i = []"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1178400_1st_inn.json\n",
      "548315_1st_inn.json\n",
      "598064_2nd_inn.json\n",
      "598031_2nd_inn.json\n",
      "829749_2nd_inn.json\n",
      "335988_1st_inn.json\n",
      "734019_1st_inn.json\n",
      "548357_2nd_inn.json\n",
      "1178417_2nd_inn.json\n",
      "501268_1st_inn.json\n",
      "598026_1st_inn.json\n",
      "598073_1st_inn.json\n",
      "1178399_2nd_inn.json\n",
      "548347_1st_inn.json\n",
      "548312_1st_inn.json\n",
      "734009_2nd_inn.json\n",
      "1178407_1st_inn.json\n",
      "598063_2nd_inn.json\n",
      "598036_2nd_inn.json\n",
      "1082648_1st_inn.json\n",
      "1136620_2nd_inn.json\n",
      "1178410_2nd_inn.json\n",
      "548350_2nd_inn.json\n",
      "598021_1st_inn.json\n",
      "829759_1st_inn.json\n",
      "335998_2nd_inn.json\n",
      "392231_1st_inn.json\n",
      "980987_2nd_inn.json\n",
      "392226_2nd_inn.json\n",
      "980997_1st_inn.json\n",
      "392236_1st_inn.json\n",
      "392221_2nd_inn.json\n",
      "1178405_2nd_inn.json\n",
      "548310_2nd_inn.json\n",
      "548345_2nd_inn.json\n",
      "598034_1st_inn.json\n",
      "598061_1st_inn.json\n",
      "829719_1st_inn.json\n",
      "1082608_1st_inn.json\n",
      "734049_2nd_inn.json\n",
      "548352_1st_inn.json\n",
      "548307_1st_inn.json\n",
      "1178412_1st_inn.json\n",
      "501238_2nd_inn.json\n",
      "598023_2nd_inn.json\n",
      "1082618_2nd_inn.json\n",
      "548317_2nd_inn.json\n",
      "548342_2nd_inn.json\n",
      "1178402_2nd_inn.json\n",
      "501228_1st_inn.json\n",
      "598033_1st_inn.json\n",
      "598066_1st_inn.json\n",
      "1178415_1st_inn.json\n",
      "548355_1st_inn.json\n",
      "598071_2nd_inn.json\n",
      "598024_2nd_inn.json\n",
      "829709_2nd_inn.json\n",
      "980995_2nd_inn.json\n",
      "336038_1st_inn.json\n",
      "392234_2nd_inn.json\n",
      "419128_1st_inn.json\n",
      "392223_1st_inn.json\n",
      "1082598_1st_inn.json\n",
      "1175356_1st_inn.json\n",
      "392233_2nd_inn.json\n",
      "597998_1st_inn.json\n",
      "980985_1st_inn.json\n",
      "392224_1st_inn.json\n",
      "336028_2nd_inn.json\n",
      "419138_2nd_inn.json\n",
      "598005_1st_inn.json\n",
      "733985_1st_inn.json\n",
      "598050_1st_inn.json\n",
      "392195_2nd_inn.json\n",
      "1136604_2nd_inn.json\n",
      "548321_2nd_inn.json\n",
      "548374_2nd_inn.json\n",
      "501209_2nd_inn.json\n",
      "392182_1st_inn.json\n",
      "598047_2nd_inn.json\n",
      "598012_2nd_inn.json\n",
      "829795_2nd_inn.json\n",
      "548363_1st_inn.json\n",
      "548336_1st_inn.json\n",
      "1136613_1st_inn.json\n",
      "1178423_1st_inn.json\n",
      "1082639_1st_inn.json\n",
      "501219_1st_inn.json\n",
      "392192_2nd_inn.json\n",
      "829785_1st_inn.json\n",
      "598002_1st_inn.json\n",
      "598057_1st_inn.json\n",
      "548326_2nd_inn.json\n",
      "548373_2nd_inn.json\n",
      "1136603_2nd_inn.json\n",
      "1082629_2nd_inn.json\n",
      "598040_2nd_inn.json\n",
      "733995_2nd_inn.json\n",
      "598015_2nd_inn.json\n",
      "392185_1st_inn.json\n",
      "1136614_1st_inn.json\n",
      "1178424_1st_inn.json\n",
      "548364_1st_inn.json\n",
      "548331_1st_inn.json\n",
      "729297_2nd_inn.json\n",
      "1175370_2nd_inn.json\n",
      "419119_1st_inn.json\n",
      "336009_1st_inn.json\n",
      "829819_1st_inn.json\n",
      "392205_2nd_inn.json\n",
      "981005_2nd_inn.json\n",
      "1136594_2nd_inn.json\n",
      "1175367_1st_inn.json\n",
      "392212_1st_inn.json\n",
      "501199_2nd_inn.json\n",
      "980919_1st_inn.json\n",
      "1136583_1st_inn.json\n",
      "392202_2nd_inn.json\n",
      "1136593_2nd_inn.json\n",
      "980909_2nd_inn.json\n",
      "1175360_1st_inn.json\n",
      "729287_1st_inn.json\n",
      "419109_2nd_inn.json\n",
      "392215_1st_inn.json\n",
      "336019_2nd_inn.json\n",
      "829809_2nd_inn.json\n",
      "981015_1st_inn.json\n",
      "1136584_1st_inn.json\n",
      "598055_2nd_inn.json\n",
      "598000_2nd_inn.json\n",
      "829787_2nd_inn.json\n",
      "392190_1st_inn.json\n",
      "1136601_1st_inn.json\n",
      "548371_1st_inn.json\n",
      "548324_1st_inn.json\n",
      "501259_1st_inn.json\n",
      "598017_1st_inn.json\n",
      "733997_1st_inn.json\n",
      "598042_1st_inn.json\n",
      "548333_2nd_inn.json\n",
      "548366_2nd_inn.json\n",
      "1136616_2nd_inn.json\n",
      "501249_2nd_inn.json\n",
      "392197_1st_inn.json\n",
      "598052_2nd_inn.json\n",
      "733987_2nd_inn.json\n",
      "598007_2nd_inn.json\n",
      "548376_1st_inn.json\n",
      "548323_1st_inn.json\n",
      "1136606_1st_inn.json\n",
      "829797_1st_inn.json\n",
      "598010_1st_inn.json\n",
      "598045_1st_inn.json\n",
      "1178421_2nd_inn.json\n",
      "1136611_2nd_inn.json\n",
      "548334_2nd_inn.json\n",
      "548361_2nd_inn.json\n",
      "392200_1st_inn.json\n",
      "1136591_1st_inn.json\n",
      "419149_2nd_inn.json\n",
      "392217_2nd_inn.json\n",
      "980949_2nd_inn.json\n",
      "1136586_2nd_inn.json\n",
      "981017_2nd_inn.json\n",
      "1136579_2nd_inn.json\n",
      "729285_2nd_inn.json\n",
      "1175362_2nd_inn.json\n",
      "392207_1st_inn.json\n",
      "1136596_1st_inn.json\n",
      "980959_1st_inn.json\n",
      "1136569_1st_inn.json\n",
      "981007_1st_inn.json\n",
      "1175372_1st_inn.json\n",
      "729295_1st_inn.json\n",
      "392210_2nd_inn.json\n",
      "1136581_2nd_inn.json\n",
      "1175365_2nd_inn.json\n",
      "419159_1st_inn.json\n",
      "598025_2nd_inn.json\n",
      "598070_2nd_inn.json\n",
      "548354_1st_inn.json\n",
      "1178414_1st_inn.json\n",
      "598067_1st_inn.json\n",
      "598032_1st_inn.json\n",
      "501229_1st_inn.json\n",
      "1178403_2nd_inn.json\n",
      "548343_2nd_inn.json\n",
      "548316_2nd_inn.json\n",
      "1082609_1st_inn.json\n",
      "598022_2nd_inn.json\n",
      "501239_2nd_inn.json\n",
      "1178413_1st_inn.json\n",
      "548306_1st_inn.json\n",
      "548353_1st_inn.json\n",
      "598060_1st_inn.json\n",
      "598035_1st_inn.json\n",
      "548344_2nd_inn.json\n",
      "548311_2nd_inn.json\n",
      "1178404_2nd_inn.json\n",
      "336029_2nd_inn.json\n",
      "392225_1st_inn.json\n",
      "419139_2nd_inn.json\n",
      "392232_2nd_inn.json\n",
      "980993_2nd_inn.json\n",
      "980939_2nd_inn.json\n",
      "597999_1st_inn.json\n",
      "392222_1st_inn.json\n",
      "980983_1st_inn.json\n",
      "980929_1st_inn.json\n",
      "1175357_1st_inn.json\n",
      "1082599_1st_inn.json\n",
      "392235_2nd_inn.json\n",
      "336039_1st_inn.json\n",
      "419129_1st_inn.json\n",
      "598020_1st_inn.json\n",
      "548351_2nd_inn.json\n",
      "1178411_2nd_inn.json\n",
      "335999_2nd_inn.json\n",
      "598037_2nd_inn.json\n",
      "598062_2nd_inn.json\n",
      "1178406_1st_inn.json\n",
      "548313_1st_inn.json\n",
      "548346_1st_inn.json\n",
      "1082649_1st_inn.json\n",
      "598072_1st_inn.json\n",
      "598027_1st_inn.json\n",
      "501269_1st_inn.json\n",
      "1178416_2nd_inn.json\n",
      "548356_2nd_inn.json\n",
      "1178398_2nd_inn.json\n",
      "598030_2nd_inn.json\n",
      "598065_2nd_inn.json\n",
      "548314_1st_inn.json\n",
      "548341_1st_inn.json\n",
      "1178401_1st_inn.json\n",
      "335989_1st_inn.json\n",
      "392220_2nd_inn.json\n",
      "980981_2nd_inn.json\n",
      "392237_1st_inn.json\n",
      "980969_1st_inn.json\n",
      "392227_2nd_inn.json\n",
      "980979_2nd_inn.json\n",
      "392230_1st_inn.json\n",
      "980991_1st_inn.json\n",
      "548360_2nd_inn.json\n",
      "548335_2nd_inn.json\n",
      "1136610_2nd_inn.json\n",
      "1178420_2nd_inn.json\n",
      "829769_1st_inn.json\n",
      "392181_2nd_inn.json\n",
      "598044_1st_inn.json\n",
      "733991_1st_inn.json\n",
      "598011_1st_inn.json\n",
      "1136607_1st_inn.json\n",
      "548322_1st_inn.json\n",
      "734039_2nd_inn.json\n",
      "548377_1st_inn.json\n",
      "829781_2nd_inn.json\n",
      "598006_2nd_inn.json\n",
      "598053_2nd_inn.json\n",
      "392196_1st_inn.json\n",
      "501248_2nd_inn.json\n",
      "733979_2nd_inn.json\n",
      "1136617_2nd_inn.json\n",
      "548367_2nd_inn.json\n",
      "734029_1st_inn.json\n",
      "548332_2nd_inn.json\n",
      "598043_1st_inn.json\n",
      "598016_1st_inn.json\n",
      "829791_1st_inn.json\n",
      "501258_1st_inn.json\n",
      "392186_2nd_inn.json\n",
      "548325_1st_inn.json\n",
      "548370_1st_inn.json\n",
      "1136600_1st_inn.json\n",
      "392191_1st_inn.json\n",
      "829779_2nd_inn.json\n",
      "598001_2nd_inn.json\n",
      "733981_2nd_inn.json\n",
      "598054_2nd_inn.json\n",
      "1136580_2nd_inn.json\n",
      "981011_2nd_inn.json\n",
      "392211_2nd_inn.json\n",
      "419158_1st_inn.json\n",
      "1175364_2nd_inn.json\n",
      "729283_2nd_inn.json\n",
      "1136568_1st_inn.json\n",
      "1136597_1st_inn.json\n",
      "392206_1st_inn.json\n",
      "1136578_2nd_inn.json\n",
      "1136587_2nd_inn.json\n",
      "392216_2nd_inn.json\n",
      "1175363_2nd_inn.json\n",
      "1136590_1st_inn.json\n",
      "981001_1st_inn.json\n",
      "392201_1st_inn.json\n",
      "419148_2nd_inn.json\n",
      "729293_1st_inn.json\n",
      "548330_1st_inn.json\n",
      "548365_1st_inn.json\n",
      "1178425_1st_inn.json\n",
      "1136615_1st_inn.json\n",
      "829739_2nd_inn.json\n",
      "392184_1st_inn.json\n",
      "829793_2nd_inn.json\n",
      "598014_2nd_inn.json\n",
      "598041_2nd_inn.json\n",
      "1136602_2nd_inn.json\n",
      "548372_2nd_inn.json\n",
      "548327_2nd_inn.json\n",
      "598056_1st_inn.json\n",
      "733983_1st_inn.json\n",
      "598003_1st_inn.json\n",
      "501218_1st_inn.json\n",
      "1082628_2nd_inn.json\n",
      "1178422_1st_inn.json\n",
      "1136612_1st_inn.json\n",
      "548337_1st_inn.json\n",
      "548362_1st_inn.json\n",
      "598013_2nd_inn.json\n",
      "733993_2nd_inn.json\n",
      "598046_2nd_inn.json\n",
      "392183_1st_inn.json\n",
      "501208_2nd_inn.json\n",
      "1082638_1st_inn.json\n",
      "548375_2nd_inn.json\n",
      "548320_2nd_inn.json\n",
      "1136605_2nd_inn.json\n",
      "829729_1st_inn.json\n",
      "392194_2nd_inn.json\n",
      "598051_1st_inn.json\n",
      "598004_1st_inn.json\n",
      "829783_1st_inn.json\n",
      "419108_2nd_inn.json\n",
      "729279_1st_inn.json\n",
      "1175361_1st_inn.json\n",
      "1136585_1st_inn.json\n",
      "336018_2nd_inn.json\n",
      "392214_1st_inn.json\n",
      "729291_2nd_inn.json\n",
      "981003_2nd_inn.json\n",
      "1136592_2nd_inn.json\n",
      "392203_2nd_inn.json\n",
      "729281_1st_inn.json\n",
      "1175366_1st_inn.json\n",
      "981013_1st_inn.json\n",
      "1136582_1st_inn.json\n",
      "501198_2nd_inn.json\n",
      "392213_1st_inn.json\n",
      "419118_1st_inn.json\n",
      "1175371_2nd_inn.json\n",
      "1136595_2nd_inn.json\n",
      "729309_1st_inn.json\n",
      "392204_2nd_inn.json\n",
      "336008_1st_inn.json\n",
      "1082625_2nd_inn.json\n",
      "829789_1st_inn.json\n",
      "501240_1st_inn.json\n",
      "733971_1st_inn.json\n",
      "829723_1st_inn.json\n",
      "501215_1st_inn.json\n",
      "548380_2nd_inn.json\n",
      "734031_1st_inn.json\n",
      "1082632_1st_inn.json\n",
      "392189_1st_inn.json\n",
      "501202_2nd_inn.json\n",
      "501257_2nd_inn.json\n",
      "829761_2nd_inn.json\n",
      "598019_2nd_inn.json\n",
      "733999_2nd_inn.json\n",
      "548368_1st_inn.json\n",
      "1136618_1st_inn.json\n",
      "1082622_2nd_inn.json\n",
      "829771_1st_inn.json\n",
      "501247_1st_inn.json\n",
      "392199_2nd_inn.json\n",
      "501212_1st_inn.json\n",
      "733989_1st_inn.json\n",
      "598009_1st_inn.json\n",
      "548378_2nd_inn.json\n",
      "1136608_2nd_inn.json\n",
      "1082635_1st_inn.json\n",
      "829799_2nd_inn.json\n",
      "501205_2nd_inn.json\n",
      "829733_2nd_inn.json\n",
      "501250_2nd_inn.json\n",
      "734021_2nd_inn.json\n",
      "336002_1st_inn.json\n",
      "729303_1st_inn.json\n",
      "980905_2nd_inn.json\n",
      "419112_1st_inn.json\n",
      "419147_1st_inn.json\n",
      "336015_2nd_inn.json\n",
      "829805_2nd_inn.json\n",
      "336040_2nd_inn.json\n",
      "392219_1st_inn.json\n",
      "980947_1st_inn.json\n",
      "1136588_1st_inn.json\n",
      "981019_1st_inn.json\n",
      "1136577_1st_inn.json\n",
      "419150_2nd_inn.json\n",
      "392209_2nd_inn.json\n",
      "336005_1st_inn.json\n",
      "829815_1st_inn.json\n",
      "1136598_2nd_inn.json\n",
      "980957_2nd_inn.json\n",
      "1136567_2nd_inn.json\n",
      "981009_2nd_inn.json\n",
      "419115_1st_inn.json\n",
      "419140_1st_inn.json\n",
      "336012_2nd_inn.json\n",
      "729313_2nd_inn.json\n",
      "1136570_1st_inn.json\n",
      "980915_1st_inn.json\n",
      "419157_2nd_inn.json\n",
      "501210_2nd_inn.json\n",
      "829773_2nd_inn.json\n",
      "501245_2nd_inn.json\n",
      "1082620_1st_inn.json\n",
      "501252_1st_inn.json\n",
      "501207_1st_inn.json\n",
      "829731_1st_inn.json\n",
      "598049_1st_inn.json\n",
      "734023_1st_inn.json\n",
      "1082637_2nd_inn.json\n",
      "829721_2nd_inn.json\n",
      "501242_2nd_inn.json\n",
      "733973_2nd_inn.json\n",
      "598059_2nd_inn.json\n",
      "548328_1st_inn.json\n",
      "734033_2nd_inn.json\n",
      "1082627_1st_inn.json\n",
      "501255_1st_inn.json\n",
      "829763_1st_inn.json\n",
      "501200_1st_inn.json\n",
      "1082630_2nd_inn.json\n",
      "729299_1st_inn.json\n",
      "419142_2nd_inn.json\n",
      "419117_2nd_inn.json\n",
      "336007_2nd_inn.json\n",
      "829817_2nd_inn.json\n",
      "1136565_1st_inn.json\n",
      "980955_1st_inn.json\n",
      "1175369_2nd_inn.json\n",
      "419155_1st_inn.json\n",
      "729311_1st_inn.json\n",
      "336010_1st_inn.json\n",
      "980917_2nd_inn.json\n",
      "1136572_2nd_inn.json\n",
      "419145_2nd_inn.json\n",
      "419110_2nd_inn.json\n",
      "729301_2nd_inn.json\n",
      "336000_2nd_inn.json\n",
      "980907_1st_inn.json\n",
      "1136562_1st_inn.json\n",
      "729289_2nd_inn.json\n",
      "419107_1st_inn.json\n",
      "419152_1st_inn.json\n",
      "336017_1st_inn.json\n",
      "829807_1st_inn.json\n",
      "1136575_2nd_inn.json\n",
      "980945_2nd_inn.json\n",
      "335983_1st_inn.json\n",
      "1082644_1st_inn.json\n",
      "1082611_1st_inn.json\n",
      "734005_2nd_inn.json\n",
      "829717_2nd_inn.json\n",
      "501221_2nd_inn.json\n",
      "1082606_2nd_inn.json\n",
      "335994_2nd_inn.json\n",
      "734047_1st_inn.json\n",
      "548309_2nd_inn.json\n",
      "501263_1st_inn.json\n",
      "501236_1st_inn.json\n",
      "1082643_1st_inn.json\n",
      "1082616_1st_inn.json\n",
      "335984_1st_inn.json\n",
      "548319_1st_inn.json\n",
      "501226_2nd_inn.json\n",
      "829745_2nd_inn.json\n",
      "598068_2nd_inn.json\n",
      "1178395_2nd_inn.json\n",
      "335993_2nd_inn.json\n",
      "1082601_2nd_inn.json\n",
      "734015_1st_inn.json\n",
      "501264_1st_inn.json\n",
      "501231_1st_inn.json\n",
      "829707_1st_inn.json\n",
      "980931_1st_inn.json\n",
      "336036_2nd_inn.json\n",
      "419126_2nd_inn.json\n",
      "980973_2nd_inn.json\n",
      "336021_1st_inn.json\n",
      "419131_1st_inn.json\n",
      "419164_1st_inn.json\n",
      "1082596_2nd_inn.json\n",
      "1175358_2nd_inn.json\n",
      "980963_1st_inn.json\n",
      "829821_2nd_inn.json\n",
      "336031_2nd_inn.json\n",
      "419121_2nd_inn.json\n",
      "980921_2nd_inn.json\n",
      "336026_1st_inn.json\n",
      "1082591_2nd_inn.json\n",
      "419136_1st_inn.json\n",
      "419163_1st_inn.json\n",
      "829747_1st_inn.json\n",
      "501271_1st_inn.json\n",
      "501224_1st_inn.json\n",
      "335986_2nd_inn.json\n",
      "1082614_2nd_inn.json\n",
      "1082641_2nd_inn.json\n",
      "734017_2nd_inn.json\n",
      "548359_1st_inn.json\n",
      "1178419_1st_inn.json\n",
      "501233_2nd_inn.json\n",
      "829705_2nd_inn.json\n",
      "501266_2nd_inn.json\n",
      "598028_2nd_inn.json\n",
      "1082603_1st_inn.json\n",
      "335991_1st_inn.json\n",
      "1178397_1st_inn.json\n",
      "548349_2nd_inn.json\n",
      "734007_1st_inn.json\n",
      "1178409_2nd_inn.json\n",
      "829715_1st_inn.json\n",
      "501223_1st_inn.json\n",
      "598038_1st_inn.json\n",
      "1082613_2nd_inn.json\n",
      "1082646_2nd_inn.json\n",
      "734045_2nd_inn.json\n",
      "501234_2nd_inn.json\n",
      "501261_2nd_inn.json\n",
      "829757_2nd_inn.json\n",
      "335996_1st_inn.json\n",
      "1082604_1st_inn.json\n",
      "419123_1st_inn.json\n",
      "980961_2nd_inn.json\n",
      "829823_1st_inn.json\n",
      "336033_1st_inn.json\n",
      "419161_2nd_inn.json\n",
      "419134_2nd_inn.json\n",
      "1082593_1st_inn.json\n",
      "980923_1st_inn.json\n",
      "980989_1st_inn.json\n",
      "336024_2nd_inn.json\n",
      "392228_1st_inn.json\n",
      "419124_1st_inn.json\n",
      "980933_2nd_inn.json\n",
      "980999_2nd_inn.json\n",
      "392238_2nd_inn.json\n",
      "336034_1st_inn.json\n",
      "1082594_1st_inn.json\n",
      "419133_2nd_inn.json\n",
      "980971_1st_inn.json\n",
      "336023_2nd_inn.json\n",
      "734025_1st_inn.json\n",
      "501201_1st_inn.json\n",
      "829737_1st_inn.json\n",
      "501254_1st_inn.json\n",
      "1082631_2nd_inn.json\n",
      "548329_1st_inn.json\n",
      "598058_2nd_inn.json\n",
      "829775_2nd_inn.json\n",
      "501243_2nd_inn.json\n",
      "501216_2nd_inn.json\n",
      "1082626_1st_inn.json\n",
      "548339_2nd_inn.json\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "598048_1st_inn.json\n",
      "501206_1st_inn.json\n",
      "501253_1st_inn.json\n",
      "829765_1st_inn.json\n",
      "1082636_2nd_inn.json\n",
      "734035_2nd_inn.json\n",
      "501244_2nd_inn.json\n",
      "733975_2nd_inn.json\n",
      "829727_2nd_inn.json\n",
      "501211_2nd_inn.json\n",
      "1082621_1st_inn.json\n",
      "419153_1st_inn.json\n",
      "419106_1st_inn.json\n",
      "980911_2nd_inn.json\n",
      "1136574_2nd_inn.json\n",
      "729317_1st_inn.json\n",
      "336016_1st_inn.json\n",
      "419111_2nd_inn.json\n",
      "419144_2nd_inn.json\n",
      "1136563_1st_inn.json\n",
      "980953_1st_inn.json\n",
      "336001_2nd_inn.json\n",
      "829811_2nd_inn.json\n",
      "419154_1st_inn.json\n",
      "1175368_2nd_inn.json\n",
      "1136573_2nd_inn.json\n",
      "980943_2nd_inn.json\n",
      "336011_1st_inn.json\n",
      "829801_1st_inn.json\n",
      "419116_2nd_inn.json\n",
      "419143_2nd_inn.json\n",
      "980901_1st_inn.json\n",
      "1136564_1st_inn.json\n",
      "729307_2nd_inn.json\n",
      "336006_2nd_inn.json\n",
      "1082634_1st_inn.json\n",
      "501251_2nd_inn.json\n",
      "829767_2nd_inn.json\n",
      "501204_2nd_inn.json\n",
      "1082623_2nd_inn.json\n",
      "1136609_2nd_inn.json\n",
      "734037_1st_inn.json\n",
      "548379_2nd_inn.json\n",
      "598008_1st_inn.json\n",
      "829725_1st_inn.json\n",
      "501213_1st_inn.json\n",
      "392198_2nd_inn.json\n",
      "501246_1st_inn.json\n",
      "733977_1st_inn.json\n",
      "1082633_1st_inn.json\n",
      "1136619_1st_inn.json\n",
      "548369_1st_inn.json\n",
      "734027_2nd_inn.json\n",
      "598018_2nd_inn.json\n",
      "501256_2nd_inn.json\n",
      "501203_2nd_inn.json\n",
      "829735_2nd_inn.json\n",
      "392188_1st_inn.json\n",
      "1082624_2nd_inn.json\n",
      "548381_2nd_inn.json\n",
      "501214_1st_inn.json\n",
      "829777_1st_inn.json\n",
      "501241_1st_inn.json\n",
      "980941_1st_inn.json\n",
      "1136571_1st_inn.json\n",
      "336013_2nd_inn.json\n",
      "829803_2nd_inn.json\n",
      "419156_2nd_inn.json\n",
      "1136566_2nd_inn.json\n",
      "1136599_2nd_inn.json\n",
      "980903_2nd_inn.json\n",
      "336004_1st_inn.json\n",
      "392208_2nd_inn.json\n",
      "729305_1st_inn.json\n",
      "419141_1st_inn.json\n",
      "419114_1st_inn.json\n",
      "1136576_1st_inn.json\n",
      "980913_1st_inn.json\n",
      "1136589_1st_inn.json\n",
      "392218_1st_inn.json\n",
      "336014_2nd_inn.json\n",
      "729315_2nd_inn.json\n",
      "419151_2nd_inn.json\n",
      "980951_2nd_inn.json\n",
      "1136561_2nd_inn.json\n",
      "336003_1st_inn.json\n",
      "829813_1st_inn.json\n",
      "419146_1st_inn.json\n",
      "419113_1st_inn.json\n",
      "501260_2nd_inn.json\n",
      "501235_2nd_inn.json\n",
      "734011_2nd_inn.json\n",
      "1082605_1st_inn.json\n",
      "1082650_1st_inn.json\n",
      "335997_1st_inn.json\n",
      "598039_1st_inn.json\n",
      "501222_1st_inn.json\n",
      "829741_1st_inn.json\n",
      "1178408_2nd_inn.json\n",
      "548348_2nd_inn.json\n",
      "1082647_2nd_inn.json\n",
      "1082612_2nd_inn.json\n",
      "598029_2nd_inn.json\n",
      "501267_2nd_inn.json\n",
      "829751_2nd_inn.json\n",
      "501232_2nd_inn.json\n",
      "1178418_1st_inn.json\n",
      "734043_2nd_inn.json\n",
      "548358_1st_inn.json\n",
      "1178396_1st_inn.json\n",
      "335990_1st_inn.json\n",
      "1082602_1st_inn.json\n",
      "829713_1st_inn.json\n",
      "501225_1st_inn.json\n",
      "501270_1st_inn.json\n",
      "734001_1st_inn.json\n",
      "1082640_2nd_inn.json\n",
      "1082615_2nd_inn.json\n",
      "335987_2nd_inn.json\n",
      "419132_2nd_inn.json\n",
      "1082595_1st_inn.json\n",
      "336022_2nd_inn.json\n",
      "980925_1st_inn.json\n",
      "419125_1st_inn.json\n",
      "336035_1st_inn.json\n",
      "392239_2nd_inn.json\n",
      "980967_2nd_inn.json\n",
      "1082592_1st_inn.json\n",
      "419135_2nd_inn.json\n",
      "419160_2nd_inn.json\n",
      "392229_1st_inn.json\n",
      "336025_2nd_inn.json\n",
      "980977_1st_inn.json\n",
      "419122_1st_inn.json\n",
      "336032_1st_inn.json\n",
      "980935_2nd_inn.json\n",
      "1082600_2nd_inn.json\n",
      "335992_2nd_inn.json\n",
      "1178394_2nd_inn.json\n",
      "501230_1st_inn.json\n",
      "501265_1st_inn.json\n",
      "829753_1st_inn.json\n",
      "734041_1st_inn.json\n",
      "335985_1st_inn.json\n",
      "1082617_1st_inn.json\n",
      "1082642_1st_inn.json\n",
      "598069_2nd_inn.json\n",
      "829711_2nd_inn.json\n",
      "501227_2nd_inn.json\n",
      "548318_1st_inn.json\n",
      "734003_2nd_inn.json\n",
      "335995_2nd_inn.json\n",
      "1178393_2nd_inn.json\n",
      "1082607_2nd_inn.json\n",
      "501237_1st_inn.json\n",
      "501262_1st_inn.json\n",
      "734013_1st_inn.json\n",
      "548308_2nd_inn.json\n",
      "1082610_1st_inn.json\n",
      "1082645_1st_inn.json\n",
      "335982_1st_inn.json\n",
      "829743_2nd_inn.json\n",
      "501220_2nd_inn.json\n",
      "336027_1st_inn.json\n",
      "980975_2nd_inn.json\n",
      "419162_1st_inn.json\n",
      "419137_1st_inn.json\n",
      "980937_1st_inn.json\n",
      "419120_2nd_inn.json\n",
      "336020_1st_inn.json\n",
      "980927_2nd_inn.json\n",
      "1175359_2nd_inn.json\n",
      "1082597_2nd_inn.json\n",
      "419165_1st_inn.json\n",
      "419130_1st_inn.json\n",
      "336037_2nd_inn.json\n",
      "980965_1st_inn.json\n",
      "419127_2nd_inn.json\n",
      "419141_2nd_inn.json\n",
      "419114_2nd_inn.json\n",
      "1136566_1st_inn.json\n",
      "1136599_1st_inn.json\n",
      "980903_1st_inn.json\n",
      "336004_2nd_inn.json\n",
      "392208_1st_inn.json\n",
      "729305_2nd_inn.json\n",
      "419156_1st_inn.json\n",
      "980941_2nd_inn.json\n",
      "1136571_2nd_inn.json\n",
      "336013_1st_inn.json\n",
      "829803_1st_inn.json\n",
      "419146_2nd_inn.json\n",
      "419113_2nd_inn.json\n",
      "980951_1st_inn.json\n",
      "1136561_1st_inn.json\n",
      "336003_2nd_inn.json\n",
      "829813_2nd_inn.json\n",
      "419151_1st_inn.json\n",
      "1136576_2nd_inn.json\n",
      "980913_2nd_inn.json\n",
      "1136589_2nd_inn.json\n",
      "392218_2nd_inn.json\n",
      "336014_1st_inn.json\n",
      "729315_1st_inn.json\n",
      "1136609_1st_inn.json\n",
      "734037_2nd_inn.json\n",
      "548379_1st_inn.json\n",
      "598008_2nd_inn.json\n",
      "829725_2nd_inn.json\n",
      "501213_2nd_inn.json\n",
      "392198_1st_inn.json\n",
      "501246_2nd_inn.json\n",
      "733977_2nd_inn.json\n",
      "1082623_1st_inn.json\n",
      "501251_1st_inn.json\n",
      "829767_1st_inn.json\n",
      "501204_1st_inn.json\n",
      "1082634_2nd_inn.json\n",
      "548381_1st_inn.json\n",
      "501214_2nd_inn.json\n",
      "829777_2nd_inn.json\n",
      "501241_2nd_inn.json\n",
      "1082624_1st_inn.json\n",
      "1136619_2nd_inn.json\n",
      "548369_2nd_inn.json\n",
      "734027_1st_inn.json\n",
      "598018_1st_inn.json\n",
      "501256_1st_inn.json\n",
      "501203_1st_inn.json\n",
      "829735_1st_inn.json\n",
      "392188_2nd_inn.json\n",
      "1082633_2nd_inn.json\n",
      "1136563_2nd_inn.json\n",
      "980953_2nd_inn.json\n",
      "336001_1st_inn.json\n",
      "829811_1st_inn.json\n",
      "419111_1st_inn.json\n",
      "419144_1st_inn.json\n",
      "980911_1st_inn.json\n",
      "1136574_1st_inn.json\n",
      "729317_2nd_inn.json\n",
      "336016_2nd_inn.json\n",
      "419153_2nd_inn.json\n",
      "419106_2nd_inn.json\n",
      "980901_2nd_inn.json\n",
      "1136564_2nd_inn.json\n",
      "729307_1st_inn.json\n",
      "336006_1st_inn.json\n",
      "419116_1st_inn.json\n",
      "419143_1st_inn.json\n",
      "1136573_1st_inn.json\n",
      "980943_1st_inn.json\n",
      "336011_2nd_inn.json\n",
      "829801_2nd_inn.json\n",
      "419154_2nd_inn.json\n",
      "1175368_1st_inn.json\n",
      "1082626_2nd_inn.json\n",
      "548329_2nd_inn.json\n",
      "598058_1st_inn.json\n",
      "829775_1st_inn.json\n",
      "501243_1st_inn.json\n",
      "501216_1st_inn.json\n",
      "1082631_1st_inn.json\n",
      "734025_2nd_inn.json\n",
      "501201_2nd_inn.json\n",
      "829737_2nd_inn.json\n",
      "501254_2nd_inn.json\n",
      "1082621_2nd_inn.json\n",
      "734035_1st_inn.json\n",
      "501244_1st_inn.json\n",
      "733975_1st_inn.json\n",
      "829727_1st_inn.json\n",
      "501211_1st_inn.json\n",
      "1082636_1st_inn.json\n",
      "548339_1st_inn.json\n",
      "598048_2nd_inn.json\n",
      "501206_2nd_inn.json\n",
      "501253_2nd_inn.json\n",
      "829765_2nd_inn.json\n",
      "419120_1st_inn.json\n",
      "980937_2nd_inn.json\n",
      "419162_2nd_inn.json\n",
      "419137_2nd_inn.json\n",
      "336027_2nd_inn.json\n",
      "980975_1st_inn.json\n",
      "419127_1st_inn.json\n",
      "336037_1st_inn.json\n",
      "980965_2nd_inn.json\n",
      "1175359_1st_inn.json\n",
      "1082597_1st_inn.json\n",
      "419165_2nd_inn.json\n",
      "419130_2nd_inn.json\n",
      "336020_2nd_inn.json\n",
      "980927_1st_inn.json\n",
      "598069_1st_inn.json\n",
      "829711_1st_inn.json\n",
      "501227_1st_inn.json\n",
      "734003_1st_inn.json\n",
      "548318_2nd_inn.json\n",
      "335985_2nd_inn.json\n",
      "1082617_2nd_inn.json\n",
      "1082642_2nd_inn.json\n",
      "501230_2nd_inn.json\n",
      "501265_2nd_inn.json\n",
      "829753_2nd_inn.json\n",
      "734041_2nd_inn.json\n",
      "1082600_1st_inn.json\n",
      "335992_1st_inn.json\n",
      "1178394_1st_inn.json\n",
      "829743_1st_inn.json\n",
      "501220_1st_inn.json\n",
      "1082610_2nd_inn.json\n",
      "1082645_2nd_inn.json\n",
      "335982_2nd_inn.json\n",
      "501237_2nd_inn.json\n",
      "501262_2nd_inn.json\n",
      "548308_1st_inn.json\n",
      "734013_2nd_inn.json\n",
      "335995_1st_inn.json\n",
      "1178393_1st_inn.json\n",
      "1082607_1st_inn.json\n",
      "336035_2nd_inn.json\n",
      "392239_1st_inn.json\n",
      "980967_1st_inn.json\n",
      "419125_2nd_inn.json\n",
      "336022_1st_inn.json\n",
      "980925_2nd_inn.json\n",
      "419132_1st_inn.json\n",
      "1082595_2nd_inn.json\n",
      "336032_2nd_inn.json\n",
      "980935_1st_inn.json\n",
      "419122_2nd_inn.json\n",
      "392229_2nd_inn.json\n",
      "336025_1st_inn.json\n",
      "980977_2nd_inn.json\n",
      "1082592_2nd_inn.json\n",
      "419135_1st_inn.json\n",
      "419160_1st_inn.json\n",
      "1082647_1st_inn.json\n",
      "1082612_1st_inn.json\n",
      "598039_2nd_inn.json\n",
      "501222_2nd_inn.json\n",
      "829741_2nd_inn.json\n",
      "1178408_1st_inn.json\n",
      "548348_1st_inn.json\n",
      "1082605_2nd_inn.json\n",
      "1082650_2nd_inn.json\n",
      "335997_2nd_inn.json\n",
      "501260_1st_inn.json\n",
      "501235_1st_inn.json\n",
      "734011_1st_inn.json\n",
      "1082640_1st_inn.json\n",
      "1082615_1st_inn.json\n",
      "335987_1st_inn.json\n",
      "829713_2nd_inn.json\n",
      "501225_2nd_inn.json\n",
      "501270_2nd_inn.json\n",
      "734001_2nd_inn.json\n",
      "1178396_2nd_inn.json\n",
      "335990_2nd_inn.json\n",
      "1082602_2nd_inn.json\n",
      "598029_1st_inn.json\n",
      "501267_1st_inn.json\n",
      "829751_1st_inn.json\n",
      "501232_1st_inn.json\n",
      "1178418_2nd_inn.json\n",
      "548358_2nd_inn.json\n",
      "734043_1st_inn.json\n",
      "729311_2nd_inn.json\n",
      "336010_2nd_inn.json\n",
      "980917_1st_inn.json\n",
      "1136572_1st_inn.json\n",
      "1175369_1st_inn.json\n",
      "419155_2nd_inn.json\n",
      "336007_1st_inn.json\n",
      "829817_1st_inn.json\n",
      "1136565_2nd_inn.json\n",
      "980955_2nd_inn.json\n",
      "729299_2nd_inn.json\n",
      "419142_1st_inn.json\n",
      "419117_1st_inn.json\n",
      "336017_2nd_inn.json\n",
      "829807_2nd_inn.json\n",
      "1136575_1st_inn.json\n",
      "980945_1st_inn.json\n",
      "729289_1st_inn.json\n",
      "419107_2nd_inn.json\n",
      "419152_2nd_inn.json\n",
      "729301_1st_inn.json\n",
      "336000_1st_inn.json\n",
      "980907_2nd_inn.json\n",
      "1136562_2nd_inn.json\n",
      "419145_1st_inn.json\n",
      "419110_1st_inn.json\n",
      "1082637_1st_inn.json\n",
      "501252_2nd_inn.json\n",
      "501207_2nd_inn.json\n",
      "829731_2nd_inn.json\n",
      "598049_2nd_inn.json\n",
      "734023_2nd_inn.json\n",
      "1082620_2nd_inn.json\n",
      "501210_1st_inn.json\n",
      "829773_1st_inn.json\n",
      "501245_1st_inn.json\n",
      "1082630_1st_inn.json\n",
      "501255_2nd_inn.json\n",
      "829763_2nd_inn.json\n"
     ]
    },
    {
     "ename": "JSONDecodeError",
     "evalue": "Expecting value: line 1 column 1 (char 0)",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mJSONDecodeError\u001b[0m                           Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-21-f7b61e576e8b>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m      2\u001b[0m     \u001b[0;32mwith\u001b[0m \u001b[0mopen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mos\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mpath\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mjoin\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'./processed_data/innings/'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mfile_name\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0mf\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      3\u001b[0m         \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfile_name\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 4\u001b[0;31m         \u001b[0ms\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mjson\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mload\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mf\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      5\u001b[0m         \u001b[0mdf_i\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ms\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/anaconda3/lib/python3.7/json/__init__.py\u001b[0m in \u001b[0;36mload\u001b[0;34m(fp, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, **kw)\u001b[0m\n\u001b[1;32m    294\u001b[0m         \u001b[0mcls\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mcls\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mobject_hook\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mobject_hook\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    295\u001b[0m         \u001b[0mparse_float\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mparse_float\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mparse_int\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mparse_int\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 296\u001b[0;31m         parse_constant=parse_constant, object_pairs_hook=object_pairs_hook, **kw)\n\u001b[0m\u001b[1;32m    297\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    298\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/anaconda3/lib/python3.7/json/__init__.py\u001b[0m in \u001b[0;36mloads\u001b[0;34m(s, encoding, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, **kw)\u001b[0m\n\u001b[1;32m    346\u001b[0m             \u001b[0mparse_int\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mNone\u001b[0m \u001b[0;32mand\u001b[0m \u001b[0mparse_float\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mNone\u001b[0m \u001b[0;32mand\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    347\u001b[0m             parse_constant is None and object_pairs_hook is None and not kw):\n\u001b[0;32m--> 348\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0m_default_decoder\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdecode\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ms\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    349\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mcls\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    350\u001b[0m         \u001b[0mcls\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mJSONDecoder\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/anaconda3/lib/python3.7/json/decoder.py\u001b[0m in \u001b[0;36mdecode\u001b[0;34m(self, s, _w)\u001b[0m\n\u001b[1;32m    335\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    336\u001b[0m         \"\"\"\n\u001b[0;32m--> 337\u001b[0;31m         \u001b[0mobj\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mend\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mraw_decode\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ms\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0midx\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0m_w\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ms\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;36m0\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    338\u001b[0m         \u001b[0mend\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0m_w\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ms\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mend\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    339\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mend\u001b[0m \u001b[0;34m!=\u001b[0m \u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ms\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/anaconda3/lib/python3.7/json/decoder.py\u001b[0m in \u001b[0;36mraw_decode\u001b[0;34m(self, s, idx)\u001b[0m\n\u001b[1;32m    353\u001b[0m             \u001b[0mobj\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mend\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mscan_once\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ms\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0midx\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    354\u001b[0m         \u001b[0;32mexcept\u001b[0m \u001b[0mStopIteration\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 355\u001b[0;31m             \u001b[0;32mraise\u001b[0m \u001b[0mJSONDecodeError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"Expecting value\"\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0ms\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mvalue\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mfrom\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    356\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mobj\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mend\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mJSONDecodeError\u001b[0m: Expecting value: line 1 column 1 (char 0)"
     ]
    }
   ],
   "source": [
    "for file_name in os.listdir('./processed_data/innings/'):\n",
    "    with open(os.path.join('./processed_data/innings/', file_name)) as f:\n",
    "        print(file_name)\n",
    "        s = json.load(f)\n",
    "        df_i.append(s)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_i = pd.DataFrame.from_records(df_i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_i"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}