Notebook-2-yaml-files-processing.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import yaml"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [],
   "source": [
    "f=open('335982.yaml','r')\n",
    "f1=open('1136563.yaml','r')\n",
    "doc = yaml.load(f)\n",
    "doc1=yaml.load(f1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2008"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a=doc['info']['dates'][0]\n",
    "#'%s/%s/%s' % (a.month, a.day, a.year)\n",
    "a.year"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2018"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a1=doc1['info']['dates']\n",
    "a1=int(doc1['info']['dates'][0].split('-')[0])\n",
    "a1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "adict={}\n",
    "adict[2008]=10\n",
    "adict[a.year]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'city': 'Bangalore',\n",
       " 'competition': 'IPL',\n",
       " 'dates': [datetime.date(2008, 4, 18)],\n",
       " 'gender': 'male',\n",
       " 'match_type': 'T20',\n",
       " 'outcome': {'by': {'runs': 140}, 'winner': 'Kolkata Knight Riders'},\n",
       " 'overs': 20,\n",
       " 'player_of_match': ['BB McCullum'],\n",
       " 'teams': ['Royal Challengers Bangalore', 'Kolkata Knight Riders'],\n",
       " 'toss': {'decision': 'field', 'winner': 'Royal Challengers Bangalore'},\n",
       " 'umpires': ['Asad Rauf', 'RE Koertzen'],\n",
       " 'venue': 'M Chinnaswamy Stadium'}"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "doc['info']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Royal Challengers Bangalore - Kolkata Knight Riders'"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "doc['info']['teams'][0] + ' - ' + doc['info']['teams'][1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Royal Challengers Bangalore'"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "doc['info']['toss']['winner']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Royal Challengers Bangalore'"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "doc['innings'][1]['2nd innings']['team']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "total_5=0\n",
    "total=0\n",
    "for i in range(len(doc['innings'][0]['1st innings']['deliveries'])):\n",
    "    for j in doc['innings'][0]['1st innings']['deliveries'][i].keys():\n",
    "        if(j<5.1):\n",
    "            total_5=total_5+doc['innings'][0]['1st innings']['deliveries'][i][j]['runs']['total']\n",
    "            total=total+doc['innings'][0]['1st innings']['deliveries'][i][j]['runs']['total']\n",
    "        else:\n",
    "            total=total+doc['innings'][0]['1st innings']['deliveries'][i][j]['runs']['total']\n",
    "#len(doc['innings'][0]['1st innings']['deliveries'])\n",
    "#doc['innings'][0]['1st innings']['deliveries']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "222"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "5.1\n"
     ]
    }
   ],
   "source": [
    "for j in doc['innings'][0]['1st innings']['deliveries'][32].keys():\n",
    "    print(j)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{0.1: {'batsman': 'R Dravid',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'W Jaffer',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {0.2: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'extras': {'wides': 1},\n",
       "   'non_striker': 'R Dravid',\n",
       "   'runs': {'batsman': 0, 'extras': 1, 'total': 1}}},\n",
       " {0.3: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'R Dravid',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {0.4: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'R Dravid',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {0.5: {'batsman': 'R Dravid',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'W Jaffer',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {0.6: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'R Dravid',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {0.7: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'R Dravid',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {1.1: {'batsman': 'R Dravid',\n",
       "   'bowler': 'I Sharma',\n",
       "   'non_striker': 'W Jaffer',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0},\n",
       "   'wicket': {'kind': 'bowled', 'player_out': 'R Dravid'}}},\n",
       " {1.2: {'batsman': 'V Kohli',\n",
       "   'bowler': 'I Sharma',\n",
       "   'non_striker': 'W Jaffer',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {1.3: {'batsman': 'V Kohli',\n",
       "   'bowler': 'I Sharma',\n",
       "   'extras': {'legbyes': 4},\n",
       "   'non_striker': 'W Jaffer',\n",
       "   'runs': {'batsman': 0, 'extras': 4, 'total': 4}}},\n",
       " {1.4: {'batsman': 'V Kohli',\n",
       "   'bowler': 'I Sharma',\n",
       "   'non_striker': 'W Jaffer',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {1.5: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'I Sharma',\n",
       "   'non_striker': 'V Kohli',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {1.6: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'I Sharma',\n",
       "   'non_striker': 'V Kohli',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {2.1: {'batsman': 'V Kohli',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'W Jaffer',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {2.2: {'batsman': 'V Kohli',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'W Jaffer',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0},\n",
       "   'wicket': {'kind': 'bowled', 'player_out': 'V Kohli'}}},\n",
       " {2.3: {'batsman': 'JH Kallis',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'W Jaffer',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {2.4: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'JH Kallis',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {2.5: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'extras': {'wides': 1},\n",
       "   'non_striker': 'JH Kallis',\n",
       "   'runs': {'batsman': 0, 'extras': 1, 'total': 1}}},\n",
       " {2.6: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'JH Kallis',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {2.7: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'JH Kallis',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {3.1: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'I Sharma',\n",
       "   'non_striker': 'JH Kallis',\n",
       "   'runs': {'batsman': 2, 'extras': 0, 'total': 2}}},\n",
       " {3.2: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'I Sharma',\n",
       "   'non_striker': 'JH Kallis',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {3.3: {'batsman': 'JH Kallis',\n",
       "   'bowler': 'I Sharma',\n",
       "   'non_striker': 'W Jaffer',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {3.4: {'batsman': 'JH Kallis',\n",
       "   'bowler': 'I Sharma',\n",
       "   'extras': {'legbyes': 1},\n",
       "   'non_striker': 'W Jaffer',\n",
       "   'runs': {'batsman': 0, 'extras': 1, 'total': 1}}},\n",
       " {3.5: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'I Sharma',\n",
       "   'non_striker': 'JH Kallis',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {3.6: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'I Sharma',\n",
       "   'non_striker': 'JH Kallis',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {4.1: {'batsman': 'JH Kallis',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'W Jaffer',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {4.2: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'JH Kallis',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {4.3: {'batsman': 'JH Kallis',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'W Jaffer',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {4.4: {'batsman': 'JH Kallis',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'W Jaffer',\n",
       "   'runs': {'batsman': 6, 'extras': 0, 'total': 6}}},\n",
       " {4.5: {'batsman': 'JH Kallis',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'W Jaffer',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0},\n",
       "   'wicket': {'fielders': ['M Kartik'],\n",
       "    'kind': 'caught',\n",
       "    'player_out': 'JH Kallis'}}},\n",
       " {4.6: {'batsman': 'CL White',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'W Jaffer',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {5.1: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {5.2: {'batsman': 'W Jaffer',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0},\n",
       "   'wicket': {'fielders': ['RT Ponting'],\n",
       "    'kind': 'caught',\n",
       "    'player_out': 'W Jaffer'}}},\n",
       " {5.3: {'batsman': 'MV Boucher',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {5.4: {'batsman': 'MV Boucher',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {5.5: {'batsman': 'CL White',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'MV Boucher',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {5.6: {'batsman': 'MV Boucher',\n",
       "   'bowler': 'AB Dinda',\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {6.1: {'batsman': 'CL White',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'MV Boucher',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {6.2: {'batsman': 'CL White',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'MV Boucher',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {6.3: {'batsman': 'CL White',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'MV Boucher',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {6.4: {'batsman': 'MV Boucher',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'extras': {'wides': 1},\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 0, 'extras': 1, 'total': 1}}},\n",
       " {6.5: {'batsman': 'MV Boucher',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'extras': {'wides': 1},\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 0, 'extras': 1, 'total': 1}}},\n",
       " {6.6: {'batsman': 'MV Boucher',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {6.7: {'batsman': 'MV Boucher',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {6.8: {'batsman': 'MV Boucher',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 4, 'extras': 0, 'total': 4}}},\n",
       " {7.1: {'batsman': 'CL White',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'MV Boucher',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {7.2: {'batsman': 'MV Boucher',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'extras': {'legbyes': 1},\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 0, 'extras': 1, 'total': 1}}},\n",
       " {7.3: {'batsman': 'CL White',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'MV Boucher',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {7.4: {'batsman': 'MV Boucher',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 2, 'extras': 0, 'total': 2}}},\n",
       " {7.5: {'batsman': 'MV Boucher',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0},\n",
       "   'wicket': {'fielders': ['M Kartik'],\n",
       "    'kind': 'caught',\n",
       "    'player_out': 'MV Boucher'}}},\n",
       " {7.6: {'batsman': 'CL White',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'B Akhil',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {8.1: {'batsman': 'B Akhil',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {8.2: {'batsman': 'B Akhil',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0},\n",
       "   'wicket': {'fielders': ['RT Ponting'],\n",
       "    'kind': 'caught',\n",
       "    'player_out': 'B Akhil'}}},\n",
       " {8.3: {'batsman': 'AA Noffke',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {8.4: {'batsman': 'AA Noffke',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'extras': {'wides': 1},\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 0, 'extras': 1, 'total': 1}}},\n",
       " {8.5: {'batsman': 'AA Noffke',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'extras': {'wides': 1},\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 0, 'extras': 1, 'total': 1}}},\n",
       " {8.6: {'batsman': 'AA Noffke',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'CL White',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {8.7: {'batsman': 'CL White',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'AA Noffke',\n",
       "   'runs': {'batsman': 2, 'extras': 0, 'total': 2}}},\n",
       " {8.8: {'batsman': 'CL White',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'AA Noffke',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0},\n",
       "   'wicket': {'fielders': ['WP Saha'],\n",
       "    'kind': 'caught',\n",
       "    'player_out': 'CL White'}}},\n",
       " {9.1: {'batsman': 'AA Noffke',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {9.2: {'batsman': 'P Kumar',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'AA Noffke',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {9.3: {'batsman': 'P Kumar',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'AA Noffke',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {9.4: {'batsman': 'P Kumar',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'extras': {'wides': 1},\n",
       "   'non_striker': 'AA Noffke',\n",
       "   'runs': {'batsman': 0, 'extras': 1, 'total': 1}}},\n",
       " {9.5: {'batsman': 'P Kumar',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'extras': {'legbyes': 1},\n",
       "   'non_striker': 'AA Noffke',\n",
       "   'runs': {'batsman': 0, 'extras': 1, 'total': 1}}},\n",
       " {9.6: {'batsman': 'AA Noffke',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 4, 'extras': 0, 'total': 4}}},\n",
       " {9.7: {'batsman': 'AA Noffke',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {10.1: {'batsman': 'AA Noffke',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {10.2: {'batsman': 'AA Noffke',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {10.3: {'batsman': 'AA Noffke',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {10.4: {'batsman': 'AA Noffke',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {10.5: {'batsman': 'P Kumar',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'AA Noffke',\n",
       "   'runs': {'batsman': 4, 'extras': 0, 'total': 4}}},\n",
       " {10.6: {'batsman': 'P Kumar',\n",
       "   'bowler': 'AB Agarkar',\n",
       "   'non_striker': 'AA Noffke',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {11.1: {'batsman': 'AA Noffke',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1},\n",
       "   'wicket': {'fielders': ['AB Agarkar', 'WP Saha'],\n",
       "    'kind': 'run out',\n",
       "    'player_out': 'AA Noffke'}}},\n",
       " {11.2: {'batsman': 'Z Khan',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {11.3: {'batsman': 'Z Khan',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {11.4: {'batsman': 'Z Khan',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {11.5: {'batsman': 'P Kumar',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'Z Khan',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {11.6: {'batsman': 'P Kumar',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'Z Khan',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {12.1: {'batsman': 'P Kumar',\n",
       "   'bowler': 'LR Shukla',\n",
       "   'non_striker': 'Z Khan',\n",
       "   'runs': {'batsman': 6, 'extras': 0, 'total': 6}}},\n",
       " {12.2: {'batsman': 'P Kumar',\n",
       "   'bowler': 'LR Shukla',\n",
       "   'extras': {'wides': 2},\n",
       "   'non_striker': 'Z Khan',\n",
       "   'runs': {'batsman': 0, 'extras': 2, 'total': 2}}},\n",
       " {12.3: {'batsman': 'Z Khan',\n",
       "   'bowler': 'LR Shukla',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {12.4: {'batsman': 'P Kumar',\n",
       "   'bowler': 'LR Shukla',\n",
       "   'non_striker': 'Z Khan',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {12.5: {'batsman': 'Z Khan',\n",
       "   'bowler': 'LR Shukla',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {12.6: {'batsman': 'Z Khan',\n",
       "   'bowler': 'LR Shukla',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {12.7: {'batsman': 'Z Khan',\n",
       "   'bowler': 'LR Shukla',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {13.1: {'batsman': 'Z Khan',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0},\n",
       "   'wicket': {'kind': 'bowled', 'player_out': 'Z Khan'}}},\n",
       " {13.2: {'batsman': 'SB Joshi',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {13.3: {'batsman': 'P Kumar',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'SB Joshi',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {13.4: {'batsman': 'P Kumar',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'SB Joshi',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {13.5: {'batsman': 'P Kumar',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'SB Joshi',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {13.6: {'batsman': 'P Kumar',\n",
       "   'bowler': 'SC Ganguly',\n",
       "   'non_striker': 'SB Joshi',\n",
       "   'runs': {'batsman': 6, 'extras': 0, 'total': 6}}},\n",
       " {14.1: {'batsman': 'SB Joshi',\n",
       "   'bowler': 'I Sharma',\n",
       "   'extras': {'wides': 1},\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 0, 'extras': 1, 'total': 1}}},\n",
       " {14.2: {'batsman': 'SB Joshi',\n",
       "   'bowler': 'I Sharma',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {14.3: {'batsman': 'SB Joshi',\n",
       "   'bowler': 'I Sharma',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {14.4: {'batsman': 'SB Joshi',\n",
       "   'bowler': 'I Sharma',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {14.5: {'batsman': 'P Kumar',\n",
       "   'bowler': 'I Sharma',\n",
       "   'extras': {'legbyes': 1},\n",
       "   'non_striker': 'SB Joshi',\n",
       "   'runs': {'batsman': 0, 'extras': 1, 'total': 1}}},\n",
       " {14.6: {'batsman': 'SB Joshi',\n",
       "   'bowler': 'I Sharma',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 1, 'extras': 0, 'total': 1}}},\n",
       " {14.7: {'batsman': 'P Kumar',\n",
       "   'bowler': 'I Sharma',\n",
       "   'non_striker': 'SB Joshi',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0}}},\n",
       " {15.1: {'batsman': 'SB Joshi',\n",
       "   'bowler': 'LR Shukla',\n",
       "   'extras': {'wides': 1},\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 0, 'extras': 1, 'total': 1}}},\n",
       " {15.2: {'batsman': 'SB Joshi',\n",
       "   'bowler': 'LR Shukla',\n",
       "   'non_striker': 'P Kumar',\n",
       "   'runs': {'batsman': 0, 'extras': 0, 'total': 0},\n",
       "   'wicket': {'fielders': ['BB McCullum'],\n",
       "    'kind': 'caught',\n",
       "    'player_out': 'SB Joshi'}}}]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "doc['innings'][1]['2nd innings']['deliveries']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import yaml\n",
    "df=pd.DataFrame(columns=['Match_Year', 'Match_Number', 'Match_City', 'Match_Stadium','Match_Teams', 'Team', '5_Over_score', '5_Over_Wicket','First_Innings','Total_Score', 'Toss_Won'])\n",
    "dictrow=dict()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "dictmatchnum=dict()\n",
    "dictmatchnum[2008]=0\n",
    "dictmatchnum[2009]=0\n",
    "dictmatchnum[2010]=0\n",
    "dictmatchnum[2011]=0\n",
    "dictmatchnum[2012]=0\n",
    "dictmatchnum[2013]=0\n",
    "dictmatchnum[2014]=0\n",
    "dictmatchnum[2015]=0\n",
    "dictmatchnum[2016]=0\n",
    "dictmatchnum[2017]=0\n",
    "dictmatchnum[2018]=0\n",
    "dictmatchnum[2019]=0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import glob\n",
    "#for file in glob.glob(\"D:\\\\Learning\\\\Matches_IPL\\\\ipl_files\\\\*.yaml\"):\n",
    "#   print(file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082591.yaml\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\users\\ravi_\\appdata\\local\\programs\\python\\python35\\lib\\site-packages\\pandas\\core\\frame.py:6211: FutureWarning: Sorting because non-concatenation axis is not aligned. A future version\n",
      "of pandas will change to not sort by default.\n",
      "\n",
      "To accept the future behavior, pass 'sort=False'.\n",
      "\n",
      "To retain the current behavior and silence the warning, pass 'sort=True'.\n",
      "\n",
      "  sort=sort)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082592.yaml\n",
      "3  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082593.yaml\n",
      "4  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082594.yaml\n",
      "5  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082595.yaml\n",
      "6  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082596.yaml\n",
      "7  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082597.yaml\n",
      "8  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082598.yaml\n",
      "9  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082599.yaml\n",
      "10  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082600.yaml\n",
      "11  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082601.yaml\n",
      "12  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082602.yaml\n",
      "13  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082603.yaml\n",
      "14  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082604.yaml\n",
      "15  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082605.yaml\n",
      "16  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082606.yaml\n",
      "17  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082607.yaml\n",
      "18  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082608.yaml\n",
      "19  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082609.yaml\n",
      "20  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082610.yaml\n",
      "21  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082611.yaml\n",
      "22  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082612.yaml\n",
      "23  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082613.yaml\n",
      "24  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082614.yaml\n",
      "25  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082615.yaml\n",
      "26  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082616.yaml\n",
      "27  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082617.yaml\n",
      "28  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082618.yaml\n",
      "29  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082620.yaml\n",
      "30  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082621.yaml\n",
      "31  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082622.yaml\n",
      "32  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082623.yaml\n",
      "33  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082624.yaml\n",
      "34  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082625.yaml\n",
      "35  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082626.yaml\n",
      "36  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082627.yaml\n",
      "37  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082628.yaml\n",
      "38  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082629.yaml\n",
      "39  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082630.yaml\n",
      "40  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082631.yaml\n",
      "41  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082632.yaml\n",
      "42  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082633.yaml\n",
      "43  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082634.yaml\n",
      "44  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082635.yaml\n",
      "45  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082636.yaml\n",
      "46  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082637.yaml\n",
      "47  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082638.yaml\n",
      "48  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082639.yaml\n",
      "49  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082640.yaml\n",
      "50  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082641.yaml\n",
      "51  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082642.yaml\n",
      "52  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082643.yaml\n",
      "53  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082644.yaml\n",
      "54  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082645.yaml\n",
      "55  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082646.yaml\n",
      "56  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082647.yaml\n",
      "57  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082648.yaml\n",
      "58  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082649.yaml\n",
      "59  -  D:\\Learning\\Matches_IPL\\ipl_files\\1082650.yaml\n",
      "60  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136561.yaml\n",
      "61  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136562.yaml\n",
      "62  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136563.yaml\n",
      "63  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136564.yaml\n",
      "64  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136565.yaml\n",
      "65  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136566.yaml\n",
      "66  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136567.yaml\n",
      "67  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136568.yaml\n",
      "68  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136569.yaml\n",
      "69  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136570.yaml\n",
      "70  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136571.yaml\n",
      "71  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136572.yaml\n",
      "72  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136573.yaml\n",
      "73  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136574.yaml\n",
      "74  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136575.yaml\n",
      "75  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136576.yaml\n",
      "76  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136577.yaml\n",
      "77  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136578.yaml\n",
      "78  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136579.yaml\n",
      "79  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136580.yaml\n",
      "80  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136581.yaml\n",
      "81  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136582.yaml\n",
      "82  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136583.yaml\n",
      "83  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136584.yaml\n",
      "84  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136585.yaml\n",
      "85  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136586.yaml\n",
      "86  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136587.yaml\n",
      "87  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136588.yaml\n",
      "88  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136589.yaml\n",
      "89  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136590.yaml\n",
      "90  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136591.yaml\n",
      "91  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136592.yaml\n",
      "92  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136593.yaml\n",
      "93  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136594.yaml\n",
      "94  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136595.yaml\n",
      "95  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136596.yaml\n",
      "96  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136597.yaml\n",
      "97  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136598.yaml\n",
      "98  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136599.yaml\n",
      "99  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136600.yaml\n",
      "100  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136601.yaml\n",
      "101  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136602.yaml\n",
      "102  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136603.yaml\n",
      "103  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136604.yaml\n",
      "104  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136605.yaml\n",
      "105  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136606.yaml\n",
      "106  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136607.yaml\n",
      "107  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136608.yaml\n",
      "108  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136609.yaml\n",
      "109  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136610.yaml\n",
      "110  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136611.yaml\n",
      "111  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136612.yaml\n",
      "112  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136613.yaml\n",
      "113  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136614.yaml\n",
      "114  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136615.yaml\n",
      "115  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136616.yaml\n",
      "116  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136617.yaml\n",
      "117  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136618.yaml\n",
      "118  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136619.yaml\n",
      "119  -  D:\\Learning\\Matches_IPL\\ipl_files\\1136620.yaml\n",
      "120  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175356.yaml\n",
      "121  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175357.yaml\n",
      "122  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175358.yaml\n",
      "123  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175359.yaml\n",
      "124  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175360.yaml\n",
      "125  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175361.yaml\n",
      "126  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175362.yaml\n",
      "127  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175363.yaml\n",
      "128  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175364.yaml\n",
      "129  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175365.yaml\n",
      "130  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175366.yaml\n",
      "131  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175367.yaml\n",
      "132  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175368.yaml\n",
      "133  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175369.yaml\n",
      "134  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175370.yaml\n",
      "135  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175371.yaml\n",
      "136  -  D:\\Learning\\Matches_IPL\\ipl_files\\1175372.yaml\n",
      "137  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178393.yaml\n",
      "138  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178394.yaml\n",
      "139  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178395.yaml\n",
      "140  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178396.yaml\n",
      "141  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178397.yaml\n",
      "142  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178398.yaml\n",
      "143  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178399.yaml\n",
      "144  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178400.yaml\n",
      "145  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178401.yaml\n",
      "146  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178402.yaml\n",
      "147  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178403.yaml\n",
      "148  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178404.yaml\n",
      "149  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178405.yaml\n",
      "150  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178406.yaml\n",
      "151  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178407.yaml\n",
      "152  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178408.yaml\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "153  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178409.yaml\n",
      "154  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178410.yaml\n",
      "155  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178411.yaml\n",
      "156  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178412.yaml\n",
      "157  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178413.yaml\n",
      "158  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178414.yaml\n",
      "159  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178415.yaml\n",
      "160  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178416.yaml\n",
      "161  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178417.yaml\n",
      "162  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178418.yaml\n",
      "163  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178419.yaml\n",
      "164  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178420.yaml\n",
      "165  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178421.yaml\n",
      "166  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178422.yaml\n",
      "167  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178423.yaml\n",
      "168  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178424.yaml\n",
      "169  -  D:\\Learning\\Matches_IPL\\ipl_files\\1178425.yaml\n",
      "170  -  D:\\Learning\\Matches_IPL\\ipl_files\\335982.yaml\n",
      "171  -  D:\\Learning\\Matches_IPL\\ipl_files\\335983.yaml\n",
      "172  -  D:\\Learning\\Matches_IPL\\ipl_files\\335984.yaml\n",
      "173  -  D:\\Learning\\Matches_IPL\\ipl_files\\335985.yaml\n",
      "174  -  D:\\Learning\\Matches_IPL\\ipl_files\\335986.yaml\n",
      "175  -  D:\\Learning\\Matches_IPL\\ipl_files\\335987.yaml\n",
      "176  -  D:\\Learning\\Matches_IPL\\ipl_files\\335988.yaml\n",
      "177  -  D:\\Learning\\Matches_IPL\\ipl_files\\335989.yaml\n",
      "178  -  D:\\Learning\\Matches_IPL\\ipl_files\\335990.yaml\n",
      "179  -  D:\\Learning\\Matches_IPL\\ipl_files\\335991.yaml\n",
      "180  -  D:\\Learning\\Matches_IPL\\ipl_files\\335992.yaml\n",
      "181  -  D:\\Learning\\Matches_IPL\\ipl_files\\335993.yaml\n",
      "182  -  D:\\Learning\\Matches_IPL\\ipl_files\\335994.yaml\n",
      "183  -  D:\\Learning\\Matches_IPL\\ipl_files\\335995.yaml\n",
      "184  -  D:\\Learning\\Matches_IPL\\ipl_files\\335996.yaml\n",
      "185  -  D:\\Learning\\Matches_IPL\\ipl_files\\335997.yaml\n",
      "186  -  D:\\Learning\\Matches_IPL\\ipl_files\\335998.yaml\n",
      "187  -  D:\\Learning\\Matches_IPL\\ipl_files\\335999.yaml\n",
      "188  -  D:\\Learning\\Matches_IPL\\ipl_files\\336000.yaml\n",
      "189  -  D:\\Learning\\Matches_IPL\\ipl_files\\336001.yaml\n",
      "190  -  D:\\Learning\\Matches_IPL\\ipl_files\\336002.yaml\n",
      "191  -  D:\\Learning\\Matches_IPL\\ipl_files\\336003.yaml\n",
      "192  -  D:\\Learning\\Matches_IPL\\ipl_files\\336004.yaml\n",
      "193  -  D:\\Learning\\Matches_IPL\\ipl_files\\336005.yaml\n",
      "194  -  D:\\Learning\\Matches_IPL\\ipl_files\\336006.yaml\n",
      "195  -  D:\\Learning\\Matches_IPL\\ipl_files\\336007.yaml\n",
      "196  -  D:\\Learning\\Matches_IPL\\ipl_files\\336008.yaml\n",
      "197  -  D:\\Learning\\Matches_IPL\\ipl_files\\336009.yaml\n",
      "198  -  D:\\Learning\\Matches_IPL\\ipl_files\\336010.yaml\n",
      "199  -  D:\\Learning\\Matches_IPL\\ipl_files\\336011.yaml\n",
      "200  -  D:\\Learning\\Matches_IPL\\ipl_files\\336012.yaml\n",
      "201  -  D:\\Learning\\Matches_IPL\\ipl_files\\336013.yaml\n",
      "202  -  D:\\Learning\\Matches_IPL\\ipl_files\\336014.yaml\n",
      "203  -  D:\\Learning\\Matches_IPL\\ipl_files\\336015.yaml\n",
      "204  -  D:\\Learning\\Matches_IPL\\ipl_files\\336016.yaml\n",
      "205  -  D:\\Learning\\Matches_IPL\\ipl_files\\336017.yaml\n",
      "206  -  D:\\Learning\\Matches_IPL\\ipl_files\\336018.yaml\n",
      "207  -  D:\\Learning\\Matches_IPL\\ipl_files\\336019.yaml\n",
      "208  -  D:\\Learning\\Matches_IPL\\ipl_files\\336020.yaml\n",
      "209  -  D:\\Learning\\Matches_IPL\\ipl_files\\336021.yaml\n",
      "210  -  D:\\Learning\\Matches_IPL\\ipl_files\\336022.yaml\n",
      "211  -  D:\\Learning\\Matches_IPL\\ipl_files\\336023.yaml\n",
      "212  -  D:\\Learning\\Matches_IPL\\ipl_files\\336024.yaml\n",
      "213  -  D:\\Learning\\Matches_IPL\\ipl_files\\336025.yaml\n",
      "214  -  D:\\Learning\\Matches_IPL\\ipl_files\\336026.yaml\n",
      "215  -  D:\\Learning\\Matches_IPL\\ipl_files\\336027.yaml\n",
      "216  -  D:\\Learning\\Matches_IPL\\ipl_files\\336028.yaml\n",
      "217  -  D:\\Learning\\Matches_IPL\\ipl_files\\336029.yaml\n",
      "218  -  D:\\Learning\\Matches_IPL\\ipl_files\\336031.yaml\n",
      "219  -  D:\\Learning\\Matches_IPL\\ipl_files\\336032.yaml\n",
      "220  -  D:\\Learning\\Matches_IPL\\ipl_files\\336033.yaml\n",
      "221  -  D:\\Learning\\Matches_IPL\\ipl_files\\336034.yaml\n",
      "222  -  D:\\Learning\\Matches_IPL\\ipl_files\\336035.yaml\n",
      "223  -  D:\\Learning\\Matches_IPL\\ipl_files\\336036.yaml\n",
      "224  -  D:\\Learning\\Matches_IPL\\ipl_files\\336037.yaml\n",
      "225  -  D:\\Learning\\Matches_IPL\\ipl_files\\336038.yaml\n",
      "226  -  D:\\Learning\\Matches_IPL\\ipl_files\\336039.yaml\n",
      "227  -  D:\\Learning\\Matches_IPL\\ipl_files\\336040.yaml\n",
      "228  -  D:\\Learning\\Matches_IPL\\ipl_files\\392181.yaml\n",
      "229  -  D:\\Learning\\Matches_IPL\\ipl_files\\392182.yaml\n",
      "230  -  D:\\Learning\\Matches_IPL\\ipl_files\\392183.yaml\n",
      "231  -  D:\\Learning\\Matches_IPL\\ipl_files\\392184.yaml\n",
      "232  -  D:\\Learning\\Matches_IPL\\ipl_files\\392185.yaml\n",
      "233  -  D:\\Learning\\Matches_IPL\\ipl_files\\392186.yaml\n",
      "234  -  D:\\Learning\\Matches_IPL\\ipl_files\\392188.yaml\n",
      "235  -  D:\\Learning\\Matches_IPL\\ipl_files\\392189.yaml\n",
      "236  -  D:\\Learning\\Matches_IPL\\ipl_files\\392190.yaml\n",
      "237  -  D:\\Learning\\Matches_IPL\\ipl_files\\392191.yaml\n",
      "238  -  D:\\Learning\\Matches_IPL\\ipl_files\\392192.yaml\n",
      "239  -  D:\\Learning\\Matches_IPL\\ipl_files\\392194.yaml\n",
      "240  -  D:\\Learning\\Matches_IPL\\ipl_files\\392195.yaml\n",
      "241  -  D:\\Learning\\Matches_IPL\\ipl_files\\392196.yaml\n",
      "242  -  D:\\Learning\\Matches_IPL\\ipl_files\\392197.yaml\n",
      "243  -  D:\\Learning\\Matches_IPL\\ipl_files\\392198.yaml\n",
      "244  -  D:\\Learning\\Matches_IPL\\ipl_files\\392199.yaml\n",
      "245  -  D:\\Learning\\Matches_IPL\\ipl_files\\392200.yaml\n",
      "246  -  D:\\Learning\\Matches_IPL\\ipl_files\\392201.yaml\n",
      "247  -  D:\\Learning\\Matches_IPL\\ipl_files\\392202.yaml\n",
      "248  -  D:\\Learning\\Matches_IPL\\ipl_files\\392203.yaml\n",
      "249  -  D:\\Learning\\Matches_IPL\\ipl_files\\392204.yaml\n",
      "250  -  D:\\Learning\\Matches_IPL\\ipl_files\\392205.yaml\n",
      "251  -  D:\\Learning\\Matches_IPL\\ipl_files\\392206.yaml\n",
      "252  -  D:\\Learning\\Matches_IPL\\ipl_files\\392207.yaml\n",
      "253  -  D:\\Learning\\Matches_IPL\\ipl_files\\392208.yaml\n",
      "254  -  D:\\Learning\\Matches_IPL\\ipl_files\\392209.yaml\n",
      "255  -  D:\\Learning\\Matches_IPL\\ipl_files\\392210.yaml\n",
      "256  -  D:\\Learning\\Matches_IPL\\ipl_files\\392211.yaml\n",
      "257  -  D:\\Learning\\Matches_IPL\\ipl_files\\392212.yaml\n",
      "258  -  D:\\Learning\\Matches_IPL\\ipl_files\\392213.yaml\n",
      "259  -  D:\\Learning\\Matches_IPL\\ipl_files\\392214.yaml\n",
      "260  -  D:\\Learning\\Matches_IPL\\ipl_files\\392215.yaml\n",
      "261  -  D:\\Learning\\Matches_IPL\\ipl_files\\392216.yaml\n",
      "262  -  D:\\Learning\\Matches_IPL\\ipl_files\\392217.yaml\n",
      "263  -  D:\\Learning\\Matches_IPL\\ipl_files\\392218.yaml\n",
      "264  -  D:\\Learning\\Matches_IPL\\ipl_files\\392219.yaml\n",
      "265  -  D:\\Learning\\Matches_IPL\\ipl_files\\392220.yaml\n",
      "266  -  D:\\Learning\\Matches_IPL\\ipl_files\\392221.yaml\n",
      "267  -  D:\\Learning\\Matches_IPL\\ipl_files\\392222.yaml\n",
      "268  -  D:\\Learning\\Matches_IPL\\ipl_files\\392223.yaml\n",
      "269  -  D:\\Learning\\Matches_IPL\\ipl_files\\392224.yaml\n",
      "270  -  D:\\Learning\\Matches_IPL\\ipl_files\\392225.yaml\n",
      "271  -  D:\\Learning\\Matches_IPL\\ipl_files\\392226.yaml\n",
      "272  -  D:\\Learning\\Matches_IPL\\ipl_files\\392227.yaml\n",
      "273  -  D:\\Learning\\Matches_IPL\\ipl_files\\392228.yaml\n",
      "274  -  D:\\Learning\\Matches_IPL\\ipl_files\\392229.yaml\n",
      "275  -  D:\\Learning\\Matches_IPL\\ipl_files\\392230.yaml\n",
      "276  -  D:\\Learning\\Matches_IPL\\ipl_files\\392231.yaml\n",
      "277  -  D:\\Learning\\Matches_IPL\\ipl_files\\392232.yaml\n",
      "278  -  D:\\Learning\\Matches_IPL\\ipl_files\\392233.yaml\n",
      "279  -  D:\\Learning\\Matches_IPL\\ipl_files\\392234.yaml\n",
      "280  -  D:\\Learning\\Matches_IPL\\ipl_files\\392235.yaml\n",
      "281  -  D:\\Learning\\Matches_IPL\\ipl_files\\392236.yaml\n",
      "282  -  D:\\Learning\\Matches_IPL\\ipl_files\\392237.yaml\n",
      "283  -  D:\\Learning\\Matches_IPL\\ipl_files\\392238.yaml\n",
      "284  -  D:\\Learning\\Matches_IPL\\ipl_files\\392239.yaml\n",
      "285  -  D:\\Learning\\Matches_IPL\\ipl_files\\419106.yaml\n",
      "286  -  D:\\Learning\\Matches_IPL\\ipl_files\\419107.yaml\n",
      "287  -  D:\\Learning\\Matches_IPL\\ipl_files\\419108.yaml\n",
      "288  -  D:\\Learning\\Matches_IPL\\ipl_files\\419109.yaml\n",
      "289  -  D:\\Learning\\Matches_IPL\\ipl_files\\419110.yaml\n",
      "290  -  D:\\Learning\\Matches_IPL\\ipl_files\\419111.yaml\n",
      "291  -  D:\\Learning\\Matches_IPL\\ipl_files\\419112.yaml\n",
      "292  -  D:\\Learning\\Matches_IPL\\ipl_files\\419113.yaml\n",
      "293  -  D:\\Learning\\Matches_IPL\\ipl_files\\419114.yaml\n",
      "294  -  D:\\Learning\\Matches_IPL\\ipl_files\\419115.yaml\n",
      "295  -  D:\\Learning\\Matches_IPL\\ipl_files\\419116.yaml\n",
      "296  -  D:\\Learning\\Matches_IPL\\ipl_files\\419117.yaml\n",
      "297  -  D:\\Learning\\Matches_IPL\\ipl_files\\419118.yaml\n",
      "298  -  D:\\Learning\\Matches_IPL\\ipl_files\\419119.yaml\n",
      "299  -  D:\\Learning\\Matches_IPL\\ipl_files\\419120.yaml\n",
      "300  -  D:\\Learning\\Matches_IPL\\ipl_files\\419121.yaml\n",
      "301  -  D:\\Learning\\Matches_IPL\\ipl_files\\419122.yaml\n",
      "302  -  D:\\Learning\\Matches_IPL\\ipl_files\\419123.yaml\n",
      "303  -  D:\\Learning\\Matches_IPL\\ipl_files\\419124.yaml\n",
      "304  -  D:\\Learning\\Matches_IPL\\ipl_files\\419125.yaml\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "305  -  D:\\Learning\\Matches_IPL\\ipl_files\\419126.yaml\n",
      "306  -  D:\\Learning\\Matches_IPL\\ipl_files\\419127.yaml\n",
      "307  -  D:\\Learning\\Matches_IPL\\ipl_files\\419128.yaml\n",
      "308  -  D:\\Learning\\Matches_IPL\\ipl_files\\419129.yaml\n",
      "309  -  D:\\Learning\\Matches_IPL\\ipl_files\\419130.yaml\n",
      "310  -  D:\\Learning\\Matches_IPL\\ipl_files\\419131.yaml\n",
      "311  -  D:\\Learning\\Matches_IPL\\ipl_files\\419132.yaml\n",
      "312  -  D:\\Learning\\Matches_IPL\\ipl_files\\419133.yaml\n",
      "313  -  D:\\Learning\\Matches_IPL\\ipl_files\\419134.yaml\n",
      "314  -  D:\\Learning\\Matches_IPL\\ipl_files\\419135.yaml\n",
      "315  -  D:\\Learning\\Matches_IPL\\ipl_files\\419136.yaml\n",
      "316  -  D:\\Learning\\Matches_IPL\\ipl_files\\419137.yaml\n",
      "317  -  D:\\Learning\\Matches_IPL\\ipl_files\\419138.yaml\n",
      "318  -  D:\\Learning\\Matches_IPL\\ipl_files\\419139.yaml\n",
      "319  -  D:\\Learning\\Matches_IPL\\ipl_files\\419140.yaml\n",
      "320  -  D:\\Learning\\Matches_IPL\\ipl_files\\419141.yaml\n",
      "321  -  D:\\Learning\\Matches_IPL\\ipl_files\\419142.yaml\n",
      "322  -  D:\\Learning\\Matches_IPL\\ipl_files\\419143.yaml\n",
      "323  -  D:\\Learning\\Matches_IPL\\ipl_files\\419144.yaml\n",
      "324  -  D:\\Learning\\Matches_IPL\\ipl_files\\419145.yaml\n",
      "325  -  D:\\Learning\\Matches_IPL\\ipl_files\\419146.yaml\n",
      "326  -  D:\\Learning\\Matches_IPL\\ipl_files\\419147.yaml\n",
      "327  -  D:\\Learning\\Matches_IPL\\ipl_files\\419148.yaml\n",
      "328  -  D:\\Learning\\Matches_IPL\\ipl_files\\419149.yaml\n",
      "329  -  D:\\Learning\\Matches_IPL\\ipl_files\\419150.yaml\n",
      "330  -  D:\\Learning\\Matches_IPL\\ipl_files\\419151.yaml\n",
      "331  -  D:\\Learning\\Matches_IPL\\ipl_files\\419152.yaml\n",
      "332  -  D:\\Learning\\Matches_IPL\\ipl_files\\419153.yaml\n",
      "333  -  D:\\Learning\\Matches_IPL\\ipl_files\\419154.yaml\n",
      "334  -  D:\\Learning\\Matches_IPL\\ipl_files\\419155.yaml\n",
      "335  -  D:\\Learning\\Matches_IPL\\ipl_files\\419156.yaml\n",
      "336  -  D:\\Learning\\Matches_IPL\\ipl_files\\419157.yaml\n",
      "337  -  D:\\Learning\\Matches_IPL\\ipl_files\\419158.yaml\n",
      "338  -  D:\\Learning\\Matches_IPL\\ipl_files\\419159.yaml\n",
      "339  -  D:\\Learning\\Matches_IPL\\ipl_files\\419160.yaml\n",
      "340  -  D:\\Learning\\Matches_IPL\\ipl_files\\419161.yaml\n",
      "341  -  D:\\Learning\\Matches_IPL\\ipl_files\\419162.yaml\n",
      "342  -  D:\\Learning\\Matches_IPL\\ipl_files\\419163.yaml\n",
      "343  -  D:\\Learning\\Matches_IPL\\ipl_files\\419164.yaml\n",
      "344  -  D:\\Learning\\Matches_IPL\\ipl_files\\419165.yaml\n",
      "345  -  D:\\Learning\\Matches_IPL\\ipl_files\\501198.yaml\n",
      "346  -  D:\\Learning\\Matches_IPL\\ipl_files\\501199.yaml\n",
      "347  -  D:\\Learning\\Matches_IPL\\ipl_files\\501200.yaml\n",
      "348  -  D:\\Learning\\Matches_IPL\\ipl_files\\501201.yaml\n",
      "349  -  D:\\Learning\\Matches_IPL\\ipl_files\\501202.yaml\n",
      "350  -  D:\\Learning\\Matches_IPL\\ipl_files\\501203.yaml\n",
      "351  -  D:\\Learning\\Matches_IPL\\ipl_files\\501204.yaml\n",
      "352  -  D:\\Learning\\Matches_IPL\\ipl_files\\501205.yaml\n",
      "353  -  D:\\Learning\\Matches_IPL\\ipl_files\\501206.yaml\n",
      "354  -  D:\\Learning\\Matches_IPL\\ipl_files\\501207.yaml\n",
      "355  -  D:\\Learning\\Matches_IPL\\ipl_files\\501208.yaml\n",
      "356  -  D:\\Learning\\Matches_IPL\\ipl_files\\501209.yaml\n",
      "357  -  D:\\Learning\\Matches_IPL\\ipl_files\\501210.yaml\n",
      "358  -  D:\\Learning\\Matches_IPL\\ipl_files\\501211.yaml\n",
      "359  -  D:\\Learning\\Matches_IPL\\ipl_files\\501212.yaml\n",
      "360  -  D:\\Learning\\Matches_IPL\\ipl_files\\501213.yaml\n",
      "361  -  D:\\Learning\\Matches_IPL\\ipl_files\\501214.yaml\n",
      "362  -  D:\\Learning\\Matches_IPL\\ipl_files\\501215.yaml\n",
      "363  -  D:\\Learning\\Matches_IPL\\ipl_files\\501216.yaml\n",
      "364  -  D:\\Learning\\Matches_IPL\\ipl_files\\501218.yaml\n",
      "365  -  D:\\Learning\\Matches_IPL\\ipl_files\\501219.yaml\n",
      "366  -  D:\\Learning\\Matches_IPL\\ipl_files\\501220.yaml\n",
      "367  -  D:\\Learning\\Matches_IPL\\ipl_files\\501221.yaml\n",
      "368  -  D:\\Learning\\Matches_IPL\\ipl_files\\501222.yaml\n",
      "369  -  D:\\Learning\\Matches_IPL\\ipl_files\\501223.yaml\n",
      "370  -  D:\\Learning\\Matches_IPL\\ipl_files\\501224.yaml\n",
      "371  -  D:\\Learning\\Matches_IPL\\ipl_files\\501225.yaml\n",
      "372  -  D:\\Learning\\Matches_IPL\\ipl_files\\501226.yaml\n",
      "373  -  D:\\Learning\\Matches_IPL\\ipl_files\\501227.yaml\n",
      "374  -  D:\\Learning\\Matches_IPL\\ipl_files\\501228.yaml\n",
      "375  -  D:\\Learning\\Matches_IPL\\ipl_files\\501229.yaml\n",
      "376  -  D:\\Learning\\Matches_IPL\\ipl_files\\501230.yaml\n",
      "377  -  D:\\Learning\\Matches_IPL\\ipl_files\\501231.yaml\n",
      "378  -  D:\\Learning\\Matches_IPL\\ipl_files\\501232.yaml\n",
      "379  -  D:\\Learning\\Matches_IPL\\ipl_files\\501233.yaml\n",
      "380  -  D:\\Learning\\Matches_IPL\\ipl_files\\501234.yaml\n",
      "381  -  D:\\Learning\\Matches_IPL\\ipl_files\\501235.yaml\n",
      "382  -  D:\\Learning\\Matches_IPL\\ipl_files\\501236.yaml\n",
      "383  -  D:\\Learning\\Matches_IPL\\ipl_files\\501237.yaml\n",
      "384  -  D:\\Learning\\Matches_IPL\\ipl_files\\501238.yaml\n",
      "385  -  D:\\Learning\\Matches_IPL\\ipl_files\\501239.yaml\n",
      "386  -  D:\\Learning\\Matches_IPL\\ipl_files\\501240.yaml\n",
      "387  -  D:\\Learning\\Matches_IPL\\ipl_files\\501241.yaml\n",
      "388  -  D:\\Learning\\Matches_IPL\\ipl_files\\501242.yaml\n",
      "389  -  D:\\Learning\\Matches_IPL\\ipl_files\\501243.yaml\n",
      "390  -  D:\\Learning\\Matches_IPL\\ipl_files\\501244.yaml\n",
      "391  -  D:\\Learning\\Matches_IPL\\ipl_files\\501245.yaml\n",
      "392  -  D:\\Learning\\Matches_IPL\\ipl_files\\501246.yaml\n",
      "393  -  D:\\Learning\\Matches_IPL\\ipl_files\\501247.yaml\n",
      "394  -  D:\\Learning\\Matches_IPL\\ipl_files\\501248.yaml\n",
      "395  -  D:\\Learning\\Matches_IPL\\ipl_files\\501249.yaml\n",
      "396  -  D:\\Learning\\Matches_IPL\\ipl_files\\501250.yaml\n",
      "397  -  D:\\Learning\\Matches_IPL\\ipl_files\\501251.yaml\n",
      "398  -  D:\\Learning\\Matches_IPL\\ipl_files\\501252.yaml\n",
      "399  -  D:\\Learning\\Matches_IPL\\ipl_files\\501253.yaml\n",
      "400  -  D:\\Learning\\Matches_IPL\\ipl_files\\501254.yaml\n",
      "401  -  D:\\Learning\\Matches_IPL\\ipl_files\\501255.yaml\n",
      "402  -  D:\\Learning\\Matches_IPL\\ipl_files\\501256.yaml\n",
      "403  -  D:\\Learning\\Matches_IPL\\ipl_files\\501257.yaml\n",
      "404  -  D:\\Learning\\Matches_IPL\\ipl_files\\501258.yaml\n",
      "405  -  D:\\Learning\\Matches_IPL\\ipl_files\\501259.yaml\n",
      "406  -  D:\\Learning\\Matches_IPL\\ipl_files\\501260.yaml\n",
      "407  -  D:\\Learning\\Matches_IPL\\ipl_files\\501261.yaml\n",
      "408  -  D:\\Learning\\Matches_IPL\\ipl_files\\501262.yaml\n",
      "409  -  D:\\Learning\\Matches_IPL\\ipl_files\\501263.yaml\n",
      "410  -  D:\\Learning\\Matches_IPL\\ipl_files\\501264.yaml\n",
      "411  -  D:\\Learning\\Matches_IPL\\ipl_files\\501266.yaml\n",
      "412  -  D:\\Learning\\Matches_IPL\\ipl_files\\501267.yaml\n",
      "413  -  D:\\Learning\\Matches_IPL\\ipl_files\\501268.yaml\n",
      "414  -  D:\\Learning\\Matches_IPL\\ipl_files\\501269.yaml\n",
      "415  -  D:\\Learning\\Matches_IPL\\ipl_files\\501270.yaml\n",
      "416  -  D:\\Learning\\Matches_IPL\\ipl_files\\501271.yaml\n",
      "417  -  D:\\Learning\\Matches_IPL\\ipl_files\\548306.yaml\n",
      "418  -  D:\\Learning\\Matches_IPL\\ipl_files\\548307.yaml\n",
      "419  -  D:\\Learning\\Matches_IPL\\ipl_files\\548308.yaml\n",
      "420  -  D:\\Learning\\Matches_IPL\\ipl_files\\548309.yaml\n",
      "421  -  D:\\Learning\\Matches_IPL\\ipl_files\\548310.yaml\n",
      "422  -  D:\\Learning\\Matches_IPL\\ipl_files\\548311.yaml\n",
      "423  -  D:\\Learning\\Matches_IPL\\ipl_files\\548312.yaml\n",
      "424  -  D:\\Learning\\Matches_IPL\\ipl_files\\548313.yaml\n",
      "425  -  D:\\Learning\\Matches_IPL\\ipl_files\\548314.yaml\n",
      "426  -  D:\\Learning\\Matches_IPL\\ipl_files\\548315.yaml\n",
      "427  -  D:\\Learning\\Matches_IPL\\ipl_files\\548316.yaml\n",
      "428  -  D:\\Learning\\Matches_IPL\\ipl_files\\548317.yaml\n",
      "429  -  D:\\Learning\\Matches_IPL\\ipl_files\\548318.yaml\n",
      "430  -  D:\\Learning\\Matches_IPL\\ipl_files\\548319.yaml\n",
      "431  -  D:\\Learning\\Matches_IPL\\ipl_files\\548320.yaml\n",
      "432  -  D:\\Learning\\Matches_IPL\\ipl_files\\548321.yaml\n",
      "433  -  D:\\Learning\\Matches_IPL\\ipl_files\\548322.yaml\n",
      "434  -  D:\\Learning\\Matches_IPL\\ipl_files\\548323.yaml\n",
      "435  -  D:\\Learning\\Matches_IPL\\ipl_files\\548324.yaml\n",
      "436  -  D:\\Learning\\Matches_IPL\\ipl_files\\548325.yaml\n",
      "437  -  D:\\Learning\\Matches_IPL\\ipl_files\\548326.yaml\n",
      "438  -  D:\\Learning\\Matches_IPL\\ipl_files\\548327.yaml\n",
      "439  -  D:\\Learning\\Matches_IPL\\ipl_files\\548328.yaml\n",
      "440  -  D:\\Learning\\Matches_IPL\\ipl_files\\548329.yaml\n",
      "441  -  D:\\Learning\\Matches_IPL\\ipl_files\\548330.yaml\n",
      "442  -  D:\\Learning\\Matches_IPL\\ipl_files\\548331.yaml\n",
      "443  -  D:\\Learning\\Matches_IPL\\ipl_files\\548332.yaml\n",
      "444  -  D:\\Learning\\Matches_IPL\\ipl_files\\548333.yaml\n",
      "445  -  D:\\Learning\\Matches_IPL\\ipl_files\\548334.yaml\n",
      "446  -  D:\\Learning\\Matches_IPL\\ipl_files\\548335.yaml\n",
      "447  -  D:\\Learning\\Matches_IPL\\ipl_files\\548336.yaml\n",
      "448  -  D:\\Learning\\Matches_IPL\\ipl_files\\548337.yaml\n",
      "449  -  D:\\Learning\\Matches_IPL\\ipl_files\\548339.yaml\n",
      "450  -  D:\\Learning\\Matches_IPL\\ipl_files\\548341.yaml\n",
      "451  -  D:\\Learning\\Matches_IPL\\ipl_files\\548342.yaml\n",
      "452  -  D:\\Learning\\Matches_IPL\\ipl_files\\548343.yaml\n",
      "453  -  D:\\Learning\\Matches_IPL\\ipl_files\\548344.yaml\n",
      "454  -  D:\\Learning\\Matches_IPL\\ipl_files\\548345.yaml\n",
      "455  -  D:\\Learning\\Matches_IPL\\ipl_files\\548346.yaml\n",
      "456  -  D:\\Learning\\Matches_IPL\\ipl_files\\548347.yaml\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "457  -  D:\\Learning\\Matches_IPL\\ipl_files\\548348.yaml\n",
      "458  -  D:\\Learning\\Matches_IPL\\ipl_files\\548349.yaml\n",
      "459  -  D:\\Learning\\Matches_IPL\\ipl_files\\548350.yaml\n",
      "460  -  D:\\Learning\\Matches_IPL\\ipl_files\\548351.yaml\n",
      "461  -  D:\\Learning\\Matches_IPL\\ipl_files\\548352.yaml\n",
      "462  -  D:\\Learning\\Matches_IPL\\ipl_files\\548353.yaml\n",
      "463  -  D:\\Learning\\Matches_IPL\\ipl_files\\548354.yaml\n",
      "464  -  D:\\Learning\\Matches_IPL\\ipl_files\\548355.yaml\n",
      "465  -  D:\\Learning\\Matches_IPL\\ipl_files\\548356.yaml\n",
      "466  -  D:\\Learning\\Matches_IPL\\ipl_files\\548357.yaml\n",
      "467  -  D:\\Learning\\Matches_IPL\\ipl_files\\548358.yaml\n",
      "468  -  D:\\Learning\\Matches_IPL\\ipl_files\\548359.yaml\n",
      "469  -  D:\\Learning\\Matches_IPL\\ipl_files\\548360.yaml\n",
      "470  -  D:\\Learning\\Matches_IPL\\ipl_files\\548361.yaml\n",
      "471  -  D:\\Learning\\Matches_IPL\\ipl_files\\548362.yaml\n",
      "472  -  D:\\Learning\\Matches_IPL\\ipl_files\\548363.yaml\n",
      "473  -  D:\\Learning\\Matches_IPL\\ipl_files\\548364.yaml\n",
      "474  -  D:\\Learning\\Matches_IPL\\ipl_files\\548365.yaml\n",
      "475  -  D:\\Learning\\Matches_IPL\\ipl_files\\548366.yaml\n",
      "476  -  D:\\Learning\\Matches_IPL\\ipl_files\\548367.yaml\n",
      "477  -  D:\\Learning\\Matches_IPL\\ipl_files\\548368.yaml\n",
      "478  -  D:\\Learning\\Matches_IPL\\ipl_files\\548369.yaml\n",
      "479  -  D:\\Learning\\Matches_IPL\\ipl_files\\548370.yaml\n",
      "480  -  D:\\Learning\\Matches_IPL\\ipl_files\\548371.yaml\n",
      "481  -  D:\\Learning\\Matches_IPL\\ipl_files\\548372.yaml\n",
      "482  -  D:\\Learning\\Matches_IPL\\ipl_files\\548373.yaml\n",
      "483  -  D:\\Learning\\Matches_IPL\\ipl_files\\548374.yaml\n",
      "484  -  D:\\Learning\\Matches_IPL\\ipl_files\\548375.yaml\n",
      "485  -  D:\\Learning\\Matches_IPL\\ipl_files\\548376.yaml\n",
      "486  -  D:\\Learning\\Matches_IPL\\ipl_files\\548377.yaml\n",
      "487  -  D:\\Learning\\Matches_IPL\\ipl_files\\548378.yaml\n",
      "488  -  D:\\Learning\\Matches_IPL\\ipl_files\\548379.yaml\n",
      "489  -  D:\\Learning\\Matches_IPL\\ipl_files\\548380.yaml\n",
      "490  -  D:\\Learning\\Matches_IPL\\ipl_files\\548381.yaml\n",
      "491  -  D:\\Learning\\Matches_IPL\\ipl_files\\597998.yaml\n",
      "492  -  D:\\Learning\\Matches_IPL\\ipl_files\\597999.yaml\n",
      "493  -  D:\\Learning\\Matches_IPL\\ipl_files\\598000.yaml\n",
      "494  -  D:\\Learning\\Matches_IPL\\ipl_files\\598001.yaml\n",
      "495  -  D:\\Learning\\Matches_IPL\\ipl_files\\598002.yaml\n",
      "496  -  D:\\Learning\\Matches_IPL\\ipl_files\\598003.yaml\n",
      "497  -  D:\\Learning\\Matches_IPL\\ipl_files\\598004.yaml\n",
      "498  -  D:\\Learning\\Matches_IPL\\ipl_files\\598005.yaml\n",
      "499  -  D:\\Learning\\Matches_IPL\\ipl_files\\598006.yaml\n",
      "500  -  D:\\Learning\\Matches_IPL\\ipl_files\\598007.yaml\n",
      "501  -  D:\\Learning\\Matches_IPL\\ipl_files\\598008.yaml\n",
      "502  -  D:\\Learning\\Matches_IPL\\ipl_files\\598009.yaml\n",
      "503  -  D:\\Learning\\Matches_IPL\\ipl_files\\598010.yaml\n",
      "504  -  D:\\Learning\\Matches_IPL\\ipl_files\\598011.yaml\n",
      "505  -  D:\\Learning\\Matches_IPL\\ipl_files\\598012.yaml\n",
      "506  -  D:\\Learning\\Matches_IPL\\ipl_files\\598013.yaml\n",
      "507  -  D:\\Learning\\Matches_IPL\\ipl_files\\598014.yaml\n",
      "508  -  D:\\Learning\\Matches_IPL\\ipl_files\\598015.yaml\n",
      "509  -  D:\\Learning\\Matches_IPL\\ipl_files\\598016.yaml\n",
      "510  -  D:\\Learning\\Matches_IPL\\ipl_files\\598017.yaml\n",
      "511  -  D:\\Learning\\Matches_IPL\\ipl_files\\598018.yaml\n",
      "512  -  D:\\Learning\\Matches_IPL\\ipl_files\\598019.yaml\n",
      "513  -  D:\\Learning\\Matches_IPL\\ipl_files\\598020.yaml\n",
      "514  -  D:\\Learning\\Matches_IPL\\ipl_files\\598021.yaml\n",
      "515  -  D:\\Learning\\Matches_IPL\\ipl_files\\598022.yaml\n",
      "516  -  D:\\Learning\\Matches_IPL\\ipl_files\\598023.yaml\n",
      "517  -  D:\\Learning\\Matches_IPL\\ipl_files\\598024.yaml\n",
      "518  -  D:\\Learning\\Matches_IPL\\ipl_files\\598025.yaml\n",
      "519  -  D:\\Learning\\Matches_IPL\\ipl_files\\598026.yaml\n",
      "520  -  D:\\Learning\\Matches_IPL\\ipl_files\\598027.yaml\n",
      "521  -  D:\\Learning\\Matches_IPL\\ipl_files\\598028.yaml\n",
      "522  -  D:\\Learning\\Matches_IPL\\ipl_files\\598029.yaml\n",
      "523  -  D:\\Learning\\Matches_IPL\\ipl_files\\598030.yaml\n",
      "524  -  D:\\Learning\\Matches_IPL\\ipl_files\\598031.yaml\n",
      "525  -  D:\\Learning\\Matches_IPL\\ipl_files\\598032.yaml\n",
      "526  -  D:\\Learning\\Matches_IPL\\ipl_files\\598033.yaml\n",
      "527  -  D:\\Learning\\Matches_IPL\\ipl_files\\598034.yaml\n",
      "528  -  D:\\Learning\\Matches_IPL\\ipl_files\\598035.yaml\n",
      "529  -  D:\\Learning\\Matches_IPL\\ipl_files\\598036.yaml\n",
      "530  -  D:\\Learning\\Matches_IPL\\ipl_files\\598037.yaml\n",
      "531  -  D:\\Learning\\Matches_IPL\\ipl_files\\598038.yaml\n",
      "532  -  D:\\Learning\\Matches_IPL\\ipl_files\\598039.yaml\n",
      "533  -  D:\\Learning\\Matches_IPL\\ipl_files\\598040.yaml\n",
      "534  -  D:\\Learning\\Matches_IPL\\ipl_files\\598041.yaml\n",
      "535  -  D:\\Learning\\Matches_IPL\\ipl_files\\598042.yaml\n",
      "536  -  D:\\Learning\\Matches_IPL\\ipl_files\\598043.yaml\n",
      "537  -  D:\\Learning\\Matches_IPL\\ipl_files\\598044.yaml\n",
      "538  -  D:\\Learning\\Matches_IPL\\ipl_files\\598045.yaml\n",
      "539  -  D:\\Learning\\Matches_IPL\\ipl_files\\598046.yaml\n",
      "540  -  D:\\Learning\\Matches_IPL\\ipl_files\\598047.yaml\n",
      "541  -  D:\\Learning\\Matches_IPL\\ipl_files\\598048.yaml\n",
      "542  -  D:\\Learning\\Matches_IPL\\ipl_files\\598049.yaml\n",
      "543  -  D:\\Learning\\Matches_IPL\\ipl_files\\598050.yaml\n",
      "544  -  D:\\Learning\\Matches_IPL\\ipl_files\\598051.yaml\n",
      "545  -  D:\\Learning\\Matches_IPL\\ipl_files\\598052.yaml\n",
      "546  -  D:\\Learning\\Matches_IPL\\ipl_files\\598053.yaml\n",
      "547  -  D:\\Learning\\Matches_IPL\\ipl_files\\598054.yaml\n",
      "548  -  D:\\Learning\\Matches_IPL\\ipl_files\\598055.yaml\n",
      "549  -  D:\\Learning\\Matches_IPL\\ipl_files\\598056.yaml\n",
      "550  -  D:\\Learning\\Matches_IPL\\ipl_files\\598057.yaml\n",
      "551  -  D:\\Learning\\Matches_IPL\\ipl_files\\598058.yaml\n",
      "552  -  D:\\Learning\\Matches_IPL\\ipl_files\\598059.yaml\n",
      "553  -  D:\\Learning\\Matches_IPL\\ipl_files\\598060.yaml\n",
      "554  -  D:\\Learning\\Matches_IPL\\ipl_files\\598061.yaml\n",
      "555  -  D:\\Learning\\Matches_IPL\\ipl_files\\598062.yaml\n",
      "556  -  D:\\Learning\\Matches_IPL\\ipl_files\\598063.yaml\n",
      "557  -  D:\\Learning\\Matches_IPL\\ipl_files\\598064.yaml\n",
      "558  -  D:\\Learning\\Matches_IPL\\ipl_files\\598065.yaml\n",
      "559  -  D:\\Learning\\Matches_IPL\\ipl_files\\598066.yaml\n",
      "560  -  D:\\Learning\\Matches_IPL\\ipl_files\\598067.yaml\n",
      "561  -  D:\\Learning\\Matches_IPL\\ipl_files\\598068.yaml\n",
      "562  -  D:\\Learning\\Matches_IPL\\ipl_files\\598069.yaml\n",
      "563  -  D:\\Learning\\Matches_IPL\\ipl_files\\598070.yaml\n",
      "564  -  D:\\Learning\\Matches_IPL\\ipl_files\\598071.yaml\n",
      "565  -  D:\\Learning\\Matches_IPL\\ipl_files\\598072.yaml\n",
      "566  -  D:\\Learning\\Matches_IPL\\ipl_files\\598073.yaml\n",
      "567  -  D:\\Learning\\Matches_IPL\\ipl_files\\729279.yaml\n",
      "568  -  D:\\Learning\\Matches_IPL\\ipl_files\\729281.yaml\n",
      "569  -  D:\\Learning\\Matches_IPL\\ipl_files\\729283.yaml\n",
      "570  -  D:\\Learning\\Matches_IPL\\ipl_files\\729285.yaml\n",
      "571  -  D:\\Learning\\Matches_IPL\\ipl_files\\729287.yaml\n",
      "572  -  D:\\Learning\\Matches_IPL\\ipl_files\\729289.yaml\n",
      "573  -  D:\\Learning\\Matches_IPL\\ipl_files\\729291.yaml\n",
      "574  -  D:\\Learning\\Matches_IPL\\ipl_files\\729293.yaml\n",
      "575  -  D:\\Learning\\Matches_IPL\\ipl_files\\729295.yaml\n",
      "576  -  D:\\Learning\\Matches_IPL\\ipl_files\\729297.yaml\n",
      "577  -  D:\\Learning\\Matches_IPL\\ipl_files\\729299.yaml\n",
      "578  -  D:\\Learning\\Matches_IPL\\ipl_files\\729301.yaml\n",
      "579  -  D:\\Learning\\Matches_IPL\\ipl_files\\729303.yaml\n",
      "580  -  D:\\Learning\\Matches_IPL\\ipl_files\\729305.yaml\n",
      "581  -  D:\\Learning\\Matches_IPL\\ipl_files\\729307.yaml\n",
      "582  -  D:\\Learning\\Matches_IPL\\ipl_files\\729309.yaml\n",
      "583  -  D:\\Learning\\Matches_IPL\\ipl_files\\729311.yaml\n",
      "584  -  D:\\Learning\\Matches_IPL\\ipl_files\\729313.yaml\n",
      "585  -  D:\\Learning\\Matches_IPL\\ipl_files\\729315.yaml\n",
      "586  -  D:\\Learning\\Matches_IPL\\ipl_files\\729317.yaml\n",
      "587  -  D:\\Learning\\Matches_IPL\\ipl_files\\733971.yaml\n",
      "588  -  D:\\Learning\\Matches_IPL\\ipl_files\\733973.yaml\n",
      "589  -  D:\\Learning\\Matches_IPL\\ipl_files\\733975.yaml\n",
      "590  -  D:\\Learning\\Matches_IPL\\ipl_files\\733977.yaml\n",
      "591  -  D:\\Learning\\Matches_IPL\\ipl_files\\733979.yaml\n",
      "592  -  D:\\Learning\\Matches_IPL\\ipl_files\\733981.yaml\n",
      "593  -  D:\\Learning\\Matches_IPL\\ipl_files\\733983.yaml\n",
      "594  -  D:\\Learning\\Matches_IPL\\ipl_files\\733985.yaml\n",
      "595  -  D:\\Learning\\Matches_IPL\\ipl_files\\733987.yaml\n",
      "596  -  D:\\Learning\\Matches_IPL\\ipl_files\\733989.yaml\n",
      "597  -  D:\\Learning\\Matches_IPL\\ipl_files\\733991.yaml\n",
      "598  -  D:\\Learning\\Matches_IPL\\ipl_files\\733993.yaml\n",
      "599  -  D:\\Learning\\Matches_IPL\\ipl_files\\733995.yaml\n",
      "600  -  D:\\Learning\\Matches_IPL\\ipl_files\\733997.yaml\n",
      "601  -  D:\\Learning\\Matches_IPL\\ipl_files\\733999.yaml\n",
      "602  -  D:\\Learning\\Matches_IPL\\ipl_files\\734001.yaml\n",
      "603  -  D:\\Learning\\Matches_IPL\\ipl_files\\734003.yaml\n",
      "604  -  D:\\Learning\\Matches_IPL\\ipl_files\\734005.yaml\n",
      "605  -  D:\\Learning\\Matches_IPL\\ipl_files\\734007.yaml\n",
      "606  -  D:\\Learning\\Matches_IPL\\ipl_files\\734009.yaml\n",
      "607  -  D:\\Learning\\Matches_IPL\\ipl_files\\734011.yaml\n",
      "608  -  D:\\Learning\\Matches_IPL\\ipl_files\\734013.yaml\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "609  -  D:\\Learning\\Matches_IPL\\ipl_files\\734015.yaml\n",
      "610  -  D:\\Learning\\Matches_IPL\\ipl_files\\734017.yaml\n",
      "611  -  D:\\Learning\\Matches_IPL\\ipl_files\\734019.yaml\n",
      "612  -  D:\\Learning\\Matches_IPL\\ipl_files\\734021.yaml\n",
      "613  -  D:\\Learning\\Matches_IPL\\ipl_files\\734023.yaml\n",
      "614  -  D:\\Learning\\Matches_IPL\\ipl_files\\734025.yaml\n",
      "615  -  D:\\Learning\\Matches_IPL\\ipl_files\\734027.yaml\n",
      "616  -  D:\\Learning\\Matches_IPL\\ipl_files\\734029.yaml\n",
      "617  -  D:\\Learning\\Matches_IPL\\ipl_files\\734031.yaml\n",
      "618  -  D:\\Learning\\Matches_IPL\\ipl_files\\734033.yaml\n",
      "619  -  D:\\Learning\\Matches_IPL\\ipl_files\\734035.yaml\n",
      "620  -  D:\\Learning\\Matches_IPL\\ipl_files\\734037.yaml\n",
      "621  -  D:\\Learning\\Matches_IPL\\ipl_files\\734039.yaml\n",
      "622  -  D:\\Learning\\Matches_IPL\\ipl_files\\734041.yaml\n",
      "623  -  D:\\Learning\\Matches_IPL\\ipl_files\\734043.yaml\n",
      "624  -  D:\\Learning\\Matches_IPL\\ipl_files\\734045.yaml\n",
      "625  -  D:\\Learning\\Matches_IPL\\ipl_files\\734047.yaml\n",
      "626  -  D:\\Learning\\Matches_IPL\\ipl_files\\734049.yaml\n",
      "627  -  D:\\Learning\\Matches_IPL\\ipl_files\\829705.yaml\n",
      "628  -  D:\\Learning\\Matches_IPL\\ipl_files\\829707.yaml\n",
      "629  -  D:\\Learning\\Matches_IPL\\ipl_files\\829709.yaml\n",
      "630  -  D:\\Learning\\Matches_IPL\\ipl_files\\829711.yaml\n",
      "631  -  D:\\Learning\\Matches_IPL\\ipl_files\\829713.yaml\n",
      "632  -  D:\\Learning\\Matches_IPL\\ipl_files\\829715.yaml\n",
      "633  -  D:\\Learning\\Matches_IPL\\ipl_files\\829717.yaml\n",
      "634  -  D:\\Learning\\Matches_IPL\\ipl_files\\829719.yaml\n",
      "635  -  D:\\Learning\\Matches_IPL\\ipl_files\\829721.yaml\n",
      "636  -  D:\\Learning\\Matches_IPL\\ipl_files\\829723.yaml\n",
      "637  -  D:\\Learning\\Matches_IPL\\ipl_files\\829725.yaml\n",
      "638  -  D:\\Learning\\Matches_IPL\\ipl_files\\829727.yaml\n",
      "639  -  D:\\Learning\\Matches_IPL\\ipl_files\\829729.yaml\n",
      "640  -  D:\\Learning\\Matches_IPL\\ipl_files\\829731.yaml\n",
      "641  -  D:\\Learning\\Matches_IPL\\ipl_files\\829733.yaml\n",
      "642  -  D:\\Learning\\Matches_IPL\\ipl_files\\829735.yaml\n",
      "643  -  D:\\Learning\\Matches_IPL\\ipl_files\\829737.yaml\n",
      "644  -  D:\\Learning\\Matches_IPL\\ipl_files\\829739.yaml\n",
      "645  -  D:\\Learning\\Matches_IPL\\ipl_files\\829741.yaml\n",
      "646  -  D:\\Learning\\Matches_IPL\\ipl_files\\829743.yaml\n",
      "647  -  D:\\Learning\\Matches_IPL\\ipl_files\\829745.yaml\n",
      "648  -  D:\\Learning\\Matches_IPL\\ipl_files\\829747.yaml\n",
      "649  -  D:\\Learning\\Matches_IPL\\ipl_files\\829749.yaml\n",
      "650  -  D:\\Learning\\Matches_IPL\\ipl_files\\829751.yaml\n",
      "651  -  D:\\Learning\\Matches_IPL\\ipl_files\\829753.yaml\n",
      "652  -  D:\\Learning\\Matches_IPL\\ipl_files\\829757.yaml\n",
      "653  -  D:\\Learning\\Matches_IPL\\ipl_files\\829759.yaml\n",
      "654  -  D:\\Learning\\Matches_IPL\\ipl_files\\829761.yaml\n",
      "655  -  D:\\Learning\\Matches_IPL\\ipl_files\\829765.yaml\n",
      "656  -  D:\\Learning\\Matches_IPL\\ipl_files\\829767.yaml\n",
      "657  -  D:\\Learning\\Matches_IPL\\ipl_files\\829769.yaml\n",
      "658  -  D:\\Learning\\Matches_IPL\\ipl_files\\829771.yaml\n",
      "659  -  D:\\Learning\\Matches_IPL\\ipl_files\\829773.yaml\n",
      "660  -  D:\\Learning\\Matches_IPL\\ipl_files\\829775.yaml\n",
      "661  -  D:\\Learning\\Matches_IPL\\ipl_files\\829777.yaml\n",
      "662  -  D:\\Learning\\Matches_IPL\\ipl_files\\829779.yaml\n",
      "663  -  D:\\Learning\\Matches_IPL\\ipl_files\\829781.yaml\n",
      "664  -  D:\\Learning\\Matches_IPL\\ipl_files\\829783.yaml\n",
      "665  -  D:\\Learning\\Matches_IPL\\ipl_files\\829785.yaml\n",
      "666  -  D:\\Learning\\Matches_IPL\\ipl_files\\829787.yaml\n",
      "667  -  D:\\Learning\\Matches_IPL\\ipl_files\\829789.yaml\n",
      "668  -  D:\\Learning\\Matches_IPL\\ipl_files\\829791.yaml\n",
      "669  -  D:\\Learning\\Matches_IPL\\ipl_files\\829793.yaml\n",
      "670  -  D:\\Learning\\Matches_IPL\\ipl_files\\829795.yaml\n",
      "671  -  D:\\Learning\\Matches_IPL\\ipl_files\\829797.yaml\n",
      "672  -  D:\\Learning\\Matches_IPL\\ipl_files\\829799.yaml\n",
      "673  -  D:\\Learning\\Matches_IPL\\ipl_files\\829801.yaml\n",
      "674  -  D:\\Learning\\Matches_IPL\\ipl_files\\829803.yaml\n",
      "675  -  D:\\Learning\\Matches_IPL\\ipl_files\\829805.yaml\n",
      "676  -  D:\\Learning\\Matches_IPL\\ipl_files\\829807.yaml\n",
      "677  -  D:\\Learning\\Matches_IPL\\ipl_files\\829809.yaml\n",
      "678  -  D:\\Learning\\Matches_IPL\\ipl_files\\829811.yaml\n",
      "679  -  D:\\Learning\\Matches_IPL\\ipl_files\\829813.yaml\n",
      "680  -  D:\\Learning\\Matches_IPL\\ipl_files\\829815.yaml\n",
      "681  -  D:\\Learning\\Matches_IPL\\ipl_files\\829817.yaml\n",
      "682  -  D:\\Learning\\Matches_IPL\\ipl_files\\829819.yaml\n",
      "683  -  D:\\Learning\\Matches_IPL\\ipl_files\\829821.yaml\n",
      "684  -  D:\\Learning\\Matches_IPL\\ipl_files\\829823.yaml\n",
      "685  -  D:\\Learning\\Matches_IPL\\ipl_files\\980901.yaml\n",
      "686  -  D:\\Learning\\Matches_IPL\\ipl_files\\980903.yaml\n",
      "687  -  D:\\Learning\\Matches_IPL\\ipl_files\\980905.yaml\n",
      "688  -  D:\\Learning\\Matches_IPL\\ipl_files\\980907.yaml\n",
      "689  -  D:\\Learning\\Matches_IPL\\ipl_files\\980909.yaml\n",
      "690  -  D:\\Learning\\Matches_IPL\\ipl_files\\980911.yaml\n",
      "691  -  D:\\Learning\\Matches_IPL\\ipl_files\\980913.yaml\n",
      "692  -  D:\\Learning\\Matches_IPL\\ipl_files\\980915.yaml\n",
      "693  -  D:\\Learning\\Matches_IPL\\ipl_files\\980917.yaml\n",
      "694  -  D:\\Learning\\Matches_IPL\\ipl_files\\980919.yaml\n",
      "695  -  D:\\Learning\\Matches_IPL\\ipl_files\\980921.yaml\n",
      "696  -  D:\\Learning\\Matches_IPL\\ipl_files\\980923.yaml\n",
      "697  -  D:\\Learning\\Matches_IPL\\ipl_files\\980925.yaml\n",
      "698  -  D:\\Learning\\Matches_IPL\\ipl_files\\980927.yaml\n",
      "699  -  D:\\Learning\\Matches_IPL\\ipl_files\\980929.yaml\n",
      "700  -  D:\\Learning\\Matches_IPL\\ipl_files\\980931.yaml\n",
      "701  -  D:\\Learning\\Matches_IPL\\ipl_files\\980933.yaml\n",
      "702  -  D:\\Learning\\Matches_IPL\\ipl_files\\980935.yaml\n",
      "703  -  D:\\Learning\\Matches_IPL\\ipl_files\\980937.yaml\n",
      "704  -  D:\\Learning\\Matches_IPL\\ipl_files\\980939.yaml\n",
      "705  -  D:\\Learning\\Matches_IPL\\ipl_files\\980941.yaml\n",
      "706  -  D:\\Learning\\Matches_IPL\\ipl_files\\980943.yaml\n",
      "707  -  D:\\Learning\\Matches_IPL\\ipl_files\\980945.yaml\n",
      "708  -  D:\\Learning\\Matches_IPL\\ipl_files\\980947.yaml\n",
      "709  -  D:\\Learning\\Matches_IPL\\ipl_files\\980949.yaml\n",
      "710  -  D:\\Learning\\Matches_IPL\\ipl_files\\980951.yaml\n",
      "711  -  D:\\Learning\\Matches_IPL\\ipl_files\\980953.yaml\n",
      "712  -  D:\\Learning\\Matches_IPL\\ipl_files\\980955.yaml\n",
      "713  -  D:\\Learning\\Matches_IPL\\ipl_files\\980957.yaml\n",
      "714  -  D:\\Learning\\Matches_IPL\\ipl_files\\980959.yaml\n",
      "715  -  D:\\Learning\\Matches_IPL\\ipl_files\\980961.yaml\n",
      "716  -  D:\\Learning\\Matches_IPL\\ipl_files\\980963.yaml\n",
      "717  -  D:\\Learning\\Matches_IPL\\ipl_files\\980965.yaml\n",
      "718  -  D:\\Learning\\Matches_IPL\\ipl_files\\980967.yaml\n",
      "719  -  D:\\Learning\\Matches_IPL\\ipl_files\\980969.yaml\n",
      "720  -  D:\\Learning\\Matches_IPL\\ipl_files\\980971.yaml\n",
      "721  -  D:\\Learning\\Matches_IPL\\ipl_files\\980973.yaml\n",
      "722  -  D:\\Learning\\Matches_IPL\\ipl_files\\980975.yaml\n",
      "723  -  D:\\Learning\\Matches_IPL\\ipl_files\\980977.yaml\n",
      "724  -  D:\\Learning\\Matches_IPL\\ipl_files\\980979.yaml\n",
      "725  -  D:\\Learning\\Matches_IPL\\ipl_files\\980981.yaml\n",
      "726  -  D:\\Learning\\Matches_IPL\\ipl_files\\980983.yaml\n",
      "727  -  D:\\Learning\\Matches_IPL\\ipl_files\\980985.yaml\n",
      "728  -  D:\\Learning\\Matches_IPL\\ipl_files\\980987.yaml\n",
      "729  -  D:\\Learning\\Matches_IPL\\ipl_files\\980989.yaml\n",
      "730  -  D:\\Learning\\Matches_IPL\\ipl_files\\980991.yaml\n",
      "731  -  D:\\Learning\\Matches_IPL\\ipl_files\\980993.yaml\n",
      "732  -  D:\\Learning\\Matches_IPL\\ipl_files\\980995.yaml\n",
      "733  -  D:\\Learning\\Matches_IPL\\ipl_files\\980997.yaml\n",
      "734  -  D:\\Learning\\Matches_IPL\\ipl_files\\980999.yaml\n",
      "735  -  D:\\Learning\\Matches_IPL\\ipl_files\\981001.yaml\n",
      "736  -  D:\\Learning\\Matches_IPL\\ipl_files\\981003.yaml\n",
      "737  -  D:\\Learning\\Matches_IPL\\ipl_files\\981005.yaml\n",
      "738  -  D:\\Learning\\Matches_IPL\\ipl_files\\981007.yaml\n",
      "739  -  D:\\Learning\\Matches_IPL\\ipl_files\\981009.yaml\n",
      "740  -  D:\\Learning\\Matches_IPL\\ipl_files\\981011.yaml\n",
      "741  -  D:\\Learning\\Matches_IPL\\ipl_files\\981013.yaml\n",
      "742  -  D:\\Learning\\Matches_IPL\\ipl_files\\981015.yaml\n",
      "743  -  D:\\Learning\\Matches_IPL\\ipl_files\\981017.yaml\n",
      "744  -  D:\\Learning\\Matches_IPL\\ipl_files\\981019.yaml\n"
     ]
    }
   ],
   "source": [
    "count=0\n",
    "file_num=0\n",
    "for file in glob.glob(\"D:\\\\Learning\\\\Matches_IPL\\\\ipl_files\\\\*.yaml\"):\n",
    "    count=count+1\n",
    "    #f=open('335982.yaml','r')\n",
    "    file_num=file_num+1\n",
    "    print(str(file_num), ' - ',file)\n",
    "    f=open(file,'r')\n",
    "    doc = yaml.load(f)\n",
    "\n",
    "    dictrow=dict()\n",
    "    try:\n",
    "        match_year=doc['info']['dates'][0].year\n",
    "        match_number=dictmatchnum[doc['info']['dates'][0].year]+1\n",
    "        dictmatchnum[match_year]=match_number\n",
    "    except:\n",
    "        match_year=int(doc['info']['dates'][0].split('-')[0])\n",
    "        match_number=dictmatchnum[match_year]+1\n",
    "        dictmatchnum[match_year]=match_number\n",
    "    total_5=0\n",
    "    total=0\n",
    "    wickets_1=0\n",
    "    for i in range(len(doc['innings'][0]['1st innings']['deliveries'])):\n",
    "        for j in doc['innings'][0]['1st innings']['deliveries'][i].keys():\n",
    "            if(j<5.1):\n",
    "                total_5=total_5+doc['innings'][0]['1st innings']['deliveries'][i][j]['runs']['total']\n",
    "                total=total+doc['innings'][0]['1st innings']['deliveries'][i][j]['runs']['total']\n",
    "                if ('wicket' in doc['innings'][0]['1st innings']['deliveries'][i][j].keys()):\n",
    "                    wickets_1=wickets_1+1\n",
    "            else:\n",
    "                total=total+doc['innings'][0]['1st innings']['deliveries'][i][j]['runs']['total']\n",
    "    #len(doc['innings'][0]['1st innings']['deliveries'])\n",
    "    #doc['innings'][0]['1st innings']['deliveries']\n",
    "    if(doc['info']['toss']['decision']!='field'):\n",
    "        dictrow['Toss_Won']=1\n",
    "    else:\n",
    "        dictrow['Toss_Won']=0\n",
    "    dictrow['5_Over_score']=total_5\n",
    "    dictrow['5_Over_Wicket']=wickets_1\n",
    "    dictrow['Total_Score']=total\n",
    "    dictrow['Match_Year']=match_year\n",
    "    dictrow['Match_Number'] = match_number\n",
    "    try:\n",
    "        dictrow['Match_City'] = doc['info']['city']\n",
    "    except:\n",
    "        dictrow['Match_City'] ='Unknown'\n",
    "    dictrow['Match_Stadium'] = doc['info']['venue']\n",
    "    dictrow['Match_Teams'] = doc['info']['teams'][0] + ' - ' + doc['info']['teams'][1]\n",
    "    dictrow['First_Innings']=1\n",
    "    dictrow['Team']= doc['innings'][0]['1st innings']['team']\n",
    "    #print(count)\n",
    "    dfrow=pd.DataFrame(dictrow,index=[count])\n",
    "    df=df.append(dfrow)\n",
    "\n",
    "    total_5_2=0\n",
    "    total_2=0\n",
    "    wickets_2=0\n",
    "    dictrow=dict()\n",
    "    count=count+1\n",
    "    for i in range(len(doc['innings'][1]['2nd innings']['deliveries'])):\n",
    "        for j in doc['innings'][1]['2nd innings']['deliveries'][i].keys():\n",
    "            if(j<5.1):\n",
    "                total_5_2=total_5_2+doc['innings'][1]['2nd innings']['deliveries'][i][j]['runs']['total']\n",
    "                total_2=total_2+doc['innings'][1]['2nd innings']['deliveries'][i][j]['runs']['total']\n",
    "                if ('wicket' in doc['innings'][1]['2nd innings']['deliveries'][i][j].keys()):\n",
    "                    wickets_2=wickets_2+1\n",
    "            else:\n",
    "                total_2=total_2+doc['innings'][1]['2nd innings']['deliveries'][i][j]['runs']['total']\n",
    "    if(doc['info']['toss']['decision']=='field'):\n",
    "        dictrow['Toss_Won']=1\n",
    "    else:\n",
    "        dictrow['Toss_Won']=0\n",
    "    dictrow['5_Over_score']=total_5_2\n",
    "    dictrow['5_Over_Wicket']=wickets_2\n",
    "    dictrow['Total_Score']=total_2\n",
    "    #dictrow['Match_Year']= doc['info']['dates'][0].year\n",
    "    dictrow['Match_Year']=match_year\n",
    "    dictrow['Match_Number'] = match_number\n",
    "    try:\n",
    "        dictrow['Match_City'] = doc['info']['city']\n",
    "    except:\n",
    "        dictrow['Match_City'] ='Unknown'\n",
    "    dictrow['Match_Stadium'] = doc['info']['venue']\n",
    "    dictrow['Match_Teams'] = doc['info']['teams'][0] + ' - ' + doc['info']['teams'][1]\n",
    "    dictrow['First_Innings']=0\n",
    "    dictrow['Team']= doc['innings'][1]['2nd innings']['team']\n",
    "    #print(count)\n",
    "    dfrow=pd.DataFrame(dictrow,index=[count])\n",
    "    df=df.append(dfrow)\n",
    "    #len(doc['innings'][0]['1st innings']['deliveries'])\n",
    "    #doc['innings'][0]['1st innings']['deliveries']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "82"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total_2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "df.to_csv('IPL_Analysis.csv', sep='|')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}