Data Preprocessing.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "d4a6afd5",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "3190a0d8",
   "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>team1</th>\n",
       "      <th>team2</th>\n",
       "      <th>winner</th>\n",
       "      <th>margin</th>\n",
       "      <th>ground</th>\n",
       "      <th>matchDate</th>\n",
       "      <th>matchID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gujarat Giants Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>143 runs</td>\n",
       "      <td>DY Patil</td>\n",
       "      <td>Mar 4, 2023</td>\n",
       "      <td>WT20#1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Royal Challengers Bangalore Women</td>\n",
       "      <td>Delhi Capitals Women</td>\n",
       "      <td>Delhi Capitals Women</td>\n",
       "      <td>60 runs</td>\n",
       "      <td>Brabourne</td>\n",
       "      <td>Mar 5, 2023</td>\n",
       "      <td>WT20#2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>UP Warriorz Women</td>\n",
       "      <td>Gujarat Giants Women</td>\n",
       "      <td>UP Warriorz Women</td>\n",
       "      <td>3 wickets</td>\n",
       "      <td>DY Patil</td>\n",
       "      <td>Mar 5, 2023</td>\n",
       "      <td>WT20#3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>Royal Challengers Bangalore Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>9 wickets</td>\n",
       "      <td>Brabourne</td>\n",
       "      <td>Mar 6, 2023</td>\n",
       "      <td>WT20#4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Delhi Capitals Women</td>\n",
       "      <td>UP Warriorz Women</td>\n",
       "      <td>Delhi Capitals Women</td>\n",
       "      <td>42 runs</td>\n",
       "      <td>DY Patil</td>\n",
       "      <td>Mar 7, 2023</td>\n",
       "      <td>WT20#5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               team1                              team2  \\\n",
       "0               Gujarat Giants Women               Mumbai Indians Women   \n",
       "1  Royal Challengers Bangalore Women               Delhi Capitals Women   \n",
       "2                  UP Warriorz Women               Gujarat Giants Women   \n",
       "3               Mumbai Indians Women  Royal Challengers Bangalore Women   \n",
       "4               Delhi Capitals Women                  UP Warriorz Women   \n",
       "\n",
       "                 winner     margin     ground    matchDate matchID  \n",
       "0  Mumbai Indians Women   143 runs   DY Patil  Mar 4, 2023  WT20#1  \n",
       "1  Delhi Capitals Women    60 runs  Brabourne  Mar 5, 2023  WT20#2  \n",
       "2     UP Warriorz Women  3 wickets   DY Patil  Mar 5, 2023  WT20#3  \n",
       "3  Mumbai Indians Women  9 wickets  Brabourne  Mar 6, 2023  WT20#4  \n",
       "4  Delhi Capitals Women    42 runs   DY Patil  Mar 7, 2023  WT20#5  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "with open('WPl_json_files/match_summary.json') as f:\n",
    "    data =  json.load(f)\n",
    "df_matches = pd.DataFrame(data)\n",
    "df_matches.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "f1d83e1e",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matches.to_csv('WPL_csv_files/match_summary.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "01b8eb2e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'Gujarat Giants Women Vs Mumbai Indians Women': 'WT20#12', 'Mumbai Indians Women Vs Gujarat Giants Women': 'WT20#12', 'Royal Challengers Bangalore Women Vs Delhi Capitals Women': 'WT20#11', 'Delhi Capitals Women Vs Royal Challengers Bangalore Women': 'WT20#11', 'UP Warriorz Women Vs Gujarat Giants Women': 'WT20#17', 'Gujarat Giants Women Vs UP Warriorz Women': 'WT20#17', 'Mumbai Indians Women Vs Royal Challengers Bangalore Women': 'WT20#19', 'Royal Challengers Bangalore Women Vs Mumbai Indians Women': 'WT20#19', 'Delhi Capitals Women Vs UP Warriorz Women': 'WT20#20', 'UP Warriorz Women Vs Delhi Capitals Women': 'WT20#20', 'Gujarat Giants Women Vs Royal Challengers Bangalore Women': 'WT20#16', 'Royal Challengers Bangalore Women Vs Gujarat Giants Women': 'WT20#16', 'Delhi Capitals Women Vs Mumbai Indians Women': 'WT20#22', 'Mumbai Indians Women Vs Delhi Capitals Women': 'WT20#22', 'Royal Challengers Bangalore Women Vs UP Warriorz Women': 'WT20#13', 'UP Warriorz Women Vs Royal Challengers Bangalore Women': 'WT20#13', 'Gujarat Giants Women Vs Delhi Capitals Women': 'WT20#14', 'Delhi Capitals Women Vs Gujarat Giants Women': 'WT20#14', 'UP Warriorz Women Vs Mumbai Indians Women': 'WT20#21', 'Mumbai Indians Women Vs UP Warriorz Women': 'WT20#21'}\n"
     ]
    }
   ],
   "source": [
    "match_dict = {}\n",
    "\n",
    "for index,row in df_matches.iterrows():\n",
    "    key1 = row['team1'] + ' Vs ' +row['team2']\n",
    "    key2 = row['team2'] + ' Vs ' +row['team1']\n",
    "    match_dict[key1] = row[\"matchID\"]\n",
    "    match_dict[key2] = row[\"matchID\"]\n",
    "print(match_dict)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "517431ce",
   "metadata": {},
   "source": [
    "**BATTING SUMMARY**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "87dff0d0",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('WPl_json_files/batting_summary.json') as f:\n",
    "    data =  json.load(f)\n",
    "    batting_records = []\n",
    "    for rec in data:\n",
    "        batting_records.extend(rec)\n",
    "        \n",
    "df_batting = pd.DataFrame(batting_records)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "6659a7ea",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>match</th>\n",
       "      <th>teamInnings</th>\n",
       "      <th>battingPos</th>\n",
       "      <th>battername</th>\n",
       "      <th>runs</th>\n",
       "      <th>balls</th>\n",
       "      <th>4s</th>\n",
       "      <th>6s</th>\n",
       "      <th>SR</th>\n",
       "      <th>out/not_out</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Mumbai Indians Women Vs Gujarat Giants Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>1</td>\n",
       "      <td>Yastika Bhatia</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12.50</td>\n",
       "      <td>out</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mumbai Indians Women Vs Gujarat Giants Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>2</td>\n",
       "      <td>Hayley Matthews</td>\n",
       "      <td>47</td>\n",
       "      <td>31</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>151.61</td>\n",
       "      <td>out</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mumbai Indians Women Vs Gujarat Giants Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>3</td>\n",
       "      <td>Nat Sciver-Brunt</td>\n",
       "      <td>23</td>\n",
       "      <td>18</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>127.77</td>\n",
       "      <td>out</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Mumbai Indians Women Vs Gujarat Giants Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>4</td>\n",
       "      <td>Harmanpreet Kaur</td>\n",
       "      <td>65</td>\n",
       "      <td>30</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>216.66</td>\n",
       "      <td>out</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Mumbai Indians Women Vs Gujarat Giants Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>5</td>\n",
       "      <td>Amelia Kerr</td>\n",
       "      <td>45</td>\n",
       "      <td>24</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>187.50</td>\n",
       "      <td>not_out</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          match           teamInnings  \\\n",
       "0  Mumbai Indians Women Vs Gujarat Giants Women  Mumbai Indians Women   \n",
       "1  Mumbai Indians Women Vs Gujarat Giants Women  Mumbai Indians Women   \n",
       "2  Mumbai Indians Women Vs Gujarat Giants Women  Mumbai Indians Women   \n",
       "3  Mumbai Indians Women Vs Gujarat Giants Women  Mumbai Indians Women   \n",
       "4  Mumbai Indians Women Vs Gujarat Giants Women  Mumbai Indians Women   \n",
       "\n",
       "   battingPos        battername runs balls  4s 6s      SR out/not_out  \n",
       "0           1    Yastika Bhatia    1     8   0  0   12.50         out  \n",
       "1           2   Hayley Matthews   47    31   3  4  151.61         out  \n",
       "2           3  Nat Sciver-Brunt   23    18   5  0  127.77         out  \n",
       "3           4  Harmanpreet Kaur   65    30  14  0  216.66         out  \n",
       "4           5       Amelia Kerr   45    24   6  1  187.50     not_out  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_batting[\"out/not_out\"] = df_batting.dismissal.apply(lambda x: \"out\" if len(x)>1 else \"not_out\")\n",
    "df_batting.drop(columns=[\"dismissal\"],inplace=True)\n",
    "df_batting.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "657cdbca",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>match</th>\n",
       "      <th>teamInnings</th>\n",
       "      <th>battingPos</th>\n",
       "      <th>battername</th>\n",
       "      <th>runs</th>\n",
       "      <th>balls</th>\n",
       "      <th>4s</th>\n",
       "      <th>6s</th>\n",
       "      <th>SR</th>\n",
       "      <th>out/not_out</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Mumbai Indians Women Vs Gujarat Giants Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>1</td>\n",
       "      <td>Yastika Bhatia</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12.50</td>\n",
       "      <td>out</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mumbai Indians Women Vs Gujarat Giants Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>2</td>\n",
       "      <td>Hayley Matthews</td>\n",
       "      <td>47</td>\n",
       "      <td>31</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>151.61</td>\n",
       "      <td>out</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mumbai Indians Women Vs Gujarat Giants Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>3</td>\n",
       "      <td>Nat Sciver-Brunt</td>\n",
       "      <td>23</td>\n",
       "      <td>18</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>127.77</td>\n",
       "      <td>out</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Mumbai Indians Women Vs Gujarat Giants Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>4</td>\n",
       "      <td>Harmanpreet Kaur</td>\n",
       "      <td>65</td>\n",
       "      <td>30</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>216.66</td>\n",
       "      <td>out</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Mumbai Indians Women Vs Gujarat Giants Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>5</td>\n",
       "      <td>Amelia Kerr</td>\n",
       "      <td>45</td>\n",
       "      <td>24</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>187.50</td>\n",
       "      <td>not_out</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>331</th>\n",
       "      <td>Delhi Capitals Women Vs Mumbai Indians Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>1</td>\n",
       "      <td>Hayley Matthews</td>\n",
       "      <td>13</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>108.33</td>\n",
       "      <td>out</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>332</th>\n",
       "      <td>Delhi Capitals Women Vs Mumbai Indians Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>2</td>\n",
       "      <td>Yastika Bhatia</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>133.33</td>\n",
       "      <td>out</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>333</th>\n",
       "      <td>Delhi Capitals Women Vs Mumbai Indians Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>3</td>\n",
       "      <td>Nat Sciver-Brunt</td>\n",
       "      <td>60</td>\n",
       "      <td>55</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>109.09</td>\n",
       "      <td>not_out</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>334</th>\n",
       "      <td>Delhi Capitals Women Vs Mumbai Indians Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>4</td>\n",
       "      <td>Harmanpreet Kaur</td>\n",
       "      <td>37</td>\n",
       "      <td>39</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>94.87</td>\n",
       "      <td>out</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335</th>\n",
       "      <td>Delhi Capitals Women Vs Mumbai Indians Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>5</td>\n",
       "      <td>Amelia Kerr</td>\n",
       "      <td>14</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>175.00</td>\n",
       "      <td>not_out</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>336 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            match           teamInnings  \\\n",
       "0    Mumbai Indians Women Vs Gujarat Giants Women  Mumbai Indians Women   \n",
       "1    Mumbai Indians Women Vs Gujarat Giants Women  Mumbai Indians Women   \n",
       "2    Mumbai Indians Women Vs Gujarat Giants Women  Mumbai Indians Women   \n",
       "3    Mumbai Indians Women Vs Gujarat Giants Women  Mumbai Indians Women   \n",
       "4    Mumbai Indians Women Vs Gujarat Giants Women  Mumbai Indians Women   \n",
       "..                                            ...                   ...   \n",
       "331  Delhi Capitals Women Vs Mumbai Indians Women  Mumbai Indians Women   \n",
       "332  Delhi Capitals Women Vs Mumbai Indians Women  Mumbai Indians Women   \n",
       "333  Delhi Capitals Women Vs Mumbai Indians Women  Mumbai Indians Women   \n",
       "334  Delhi Capitals Women Vs Mumbai Indians Women  Mumbai Indians Women   \n",
       "335  Delhi Capitals Women Vs Mumbai Indians Women  Mumbai Indians Women   \n",
       "\n",
       "     battingPos        battername runs balls  4s 6s      SR out/not_out  \n",
       "0             1    Yastika Bhatia    1     8   0  0   12.50         out  \n",
       "1             2   Hayley Matthews   47    31   3  4  151.61         out  \n",
       "2             3  Nat Sciver-Brunt   23    18   5  0  127.77         out  \n",
       "3             4  Harmanpreet Kaur   65    30  14  0  216.66         out  \n",
       "4             5       Amelia Kerr   45    24   6  1  187.50     not_out  \n",
       "..          ...               ...  ...   ...  .. ..     ...         ...  \n",
       "331           1   Hayley Matthews   13    12   3  0  108.33         out  \n",
       "332           2    Yastika Bhatia    4     3   1  0  133.33         out  \n",
       "333           3  Nat Sciver-Brunt   60    55   7  0  109.09     not_out  \n",
       "334           4  Harmanpreet Kaur   37    39   5  0   94.87         out  \n",
       "335           5       Amelia Kerr   14     8   2  0  175.00     not_out  \n",
       "\n",
       "[336 rows x 10 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_batting['match'] = df_batting['match'].apply(lambda x: x.rstrip())\n",
    "df_batting"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "7ceb561d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>match</th>\n",
       "      <th>teamInnings</th>\n",
       "      <th>battingPos</th>\n",
       "      <th>battername</th>\n",
       "      <th>runs</th>\n",
       "      <th>balls</th>\n",
       "      <th>4s</th>\n",
       "      <th>6s</th>\n",
       "      <th>SR</th>\n",
       "      <th>out/not_out</th>\n",
       "      <th>matchID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Mumbai Indians Women Vs Gujarat Giants Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>1</td>\n",
       "      <td>Yastika Bhatia</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12.50</td>\n",
       "      <td>out</td>\n",
       "      <td>WT20#12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mumbai Indians Women Vs Gujarat Giants Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>2</td>\n",
       "      <td>Hayley Matthews</td>\n",
       "      <td>47</td>\n",
       "      <td>31</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>151.61</td>\n",
       "      <td>out</td>\n",
       "      <td>WT20#12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mumbai Indians Women Vs Gujarat Giants Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>3</td>\n",
       "      <td>Nat Sciver-Brunt</td>\n",
       "      <td>23</td>\n",
       "      <td>18</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>127.77</td>\n",
       "      <td>out</td>\n",
       "      <td>WT20#12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Mumbai Indians Women Vs Gujarat Giants Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>4</td>\n",
       "      <td>Harmanpreet Kaur</td>\n",
       "      <td>65</td>\n",
       "      <td>30</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>216.66</td>\n",
       "      <td>out</td>\n",
       "      <td>WT20#12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Mumbai Indians Women Vs Gujarat Giants Women</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>5</td>\n",
       "      <td>Amelia Kerr</td>\n",
       "      <td>45</td>\n",
       "      <td>24</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>187.50</td>\n",
       "      <td>not_out</td>\n",
       "      <td>WT20#12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          match           teamInnings  \\\n",
       "0  Mumbai Indians Women Vs Gujarat Giants Women  Mumbai Indians Women   \n",
       "1  Mumbai Indians Women Vs Gujarat Giants Women  Mumbai Indians Women   \n",
       "2  Mumbai Indians Women Vs Gujarat Giants Women  Mumbai Indians Women   \n",
       "3  Mumbai Indians Women Vs Gujarat Giants Women  Mumbai Indians Women   \n",
       "4  Mumbai Indians Women Vs Gujarat Giants Women  Mumbai Indians Women   \n",
       "\n",
       "   battingPos        battername runs balls  4s 6s      SR out/not_out  matchID  \n",
       "0           1    Yastika Bhatia    1     8   0  0   12.50         out  WT20#12  \n",
       "1           2   Hayley Matthews   47    31   3  4  151.61         out  WT20#12  \n",
       "2           3  Nat Sciver-Brunt   23    18   5  0  127.77         out  WT20#12  \n",
       "3           4  Harmanpreet Kaur   65    30  14  0  216.66         out  WT20#12  \n",
       "4           5       Amelia Kerr   45    24   6  1  187.50     not_out  WT20#12  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_batting[\"matchID\"] = df_batting[\"match\"].map(match_dict)\n",
    "df_batting.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "798c830f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_batting.to_csv('WPL_csv_files/batting_summary.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "f7c01c77",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('WPL_json_files/bowling_summary.json') as f:\n",
    "    data = json.load(f)\n",
    "    all_records = []\n",
    "    for rec in data:\n",
    "        all_records.extend(rec)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "9293e154",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(270, 13)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>match</th>\n",
       "      <th>bowlingTeam</th>\n",
       "      <th>bowlerName</th>\n",
       "      <th>overs</th>\n",
       "      <th>maiden</th>\n",
       "      <th>runs</th>\n",
       "      <th>wickets</th>\n",
       "      <th>economy</th>\n",
       "      <th>0s</th>\n",
       "      <th>4s</th>\n",
       "      <th>6s</th>\n",
       "      <th>wides</th>\n",
       "      <th>noBalls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gujarat Giants Women Vs Mumbai Indians Women</td>\n",
       "      <td>Gujarat Giants Women</td>\n",
       "      <td>Ashleigh Gardner</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>9.50</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gujarat Giants Women Vs Mumbai Indians Women</td>\n",
       "      <td>Gujarat Giants Women</td>\n",
       "      <td>Mansi Joshi</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>8.50</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gujarat Giants Women Vs Mumbai Indians Women</td>\n",
       "      <td>Gujarat Giants Women</td>\n",
       "      <td>Tanuja Kanwar</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>6.00</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Gujarat Giants Women Vs Mumbai Indians Women</td>\n",
       "      <td>Gujarat Giants Women</td>\n",
       "      <td>Monica Patel</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>17.00</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Gujarat Giants Women Vs Mumbai Indians Women</td>\n",
       "      <td>Gujarat Giants Women</td>\n",
       "      <td>Georgia Wareham</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>10.00</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          match           bowlingTeam  \\\n",
       "0  Gujarat Giants Women Vs Mumbai Indians Women  Gujarat Giants Women   \n",
       "1  Gujarat Giants Women Vs Mumbai Indians Women  Gujarat Giants Women   \n",
       "2  Gujarat Giants Women Vs Mumbai Indians Women  Gujarat Giants Women   \n",
       "3  Gujarat Giants Women Vs Mumbai Indians Women  Gujarat Giants Women   \n",
       "4  Gujarat Giants Women Vs Mumbai Indians Women  Gujarat Giants Women   \n",
       "\n",
       "         bowlerName overs maiden runs wickets economy 0s 4s 6s wides noBalls  \n",
       "0  Ashleigh Gardner     4      0   38       1    9.50  7  7  0     0       0  \n",
       "1       Mansi Joshi     2      0   17       0    8.50  7  2  1     1       0  \n",
       "2     Tanuja Kanwar     2      0   12       1    6.00  6  2  0     0       0  \n",
       "3      Monica Patel     2      0   34       0   17.00  1  7  0     2       0  \n",
       "4   Georgia Wareham     3      0   30       1   10.00  6  4  1     0       0  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_bowling = pd.DataFrame(all_records)\n",
    "print(df_bowling.shape)\n",
    "df_bowling['match'] = df_bowling['match'].apply(lambda x: x.rstrip())\n",
    "df_bowling.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "8c43a39f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>match</th>\n",
       "      <th>bowlingTeam</th>\n",
       "      <th>bowlerName</th>\n",
       "      <th>overs</th>\n",
       "      <th>maiden</th>\n",
       "      <th>runs</th>\n",
       "      <th>wickets</th>\n",
       "      <th>economy</th>\n",
       "      <th>0s</th>\n",
       "      <th>4s</th>\n",
       "      <th>6s</th>\n",
       "      <th>wides</th>\n",
       "      <th>noBalls</th>\n",
       "      <th>matchID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gujarat Giants Women Vs Mumbai Indians Women</td>\n",
       "      <td>Gujarat Giants Women</td>\n",
       "      <td>Ashleigh Gardner</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>9.50</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>WT20#12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gujarat Giants Women Vs Mumbai Indians Women</td>\n",
       "      <td>Gujarat Giants Women</td>\n",
       "      <td>Mansi Joshi</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>8.50</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>WT20#12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gujarat Giants Women Vs Mumbai Indians Women</td>\n",
       "      <td>Gujarat Giants Women</td>\n",
       "      <td>Tanuja Kanwar</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>6.00</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>WT20#12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Gujarat Giants Women Vs Mumbai Indians Women</td>\n",
       "      <td>Gujarat Giants Women</td>\n",
       "      <td>Monica Patel</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>17.00</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>WT20#12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Gujarat Giants Women Vs Mumbai Indians Women</td>\n",
       "      <td>Gujarat Giants Women</td>\n",
       "      <td>Georgia Wareham</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>10.00</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>WT20#12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          match            bowlingTeam  \\\n",
       "0  Gujarat Giants Women Vs Mumbai Indians Women  Gujarat Giants Women    \n",
       "1  Gujarat Giants Women Vs Mumbai Indians Women  Gujarat Giants Women    \n",
       "2  Gujarat Giants Women Vs Mumbai Indians Women  Gujarat Giants Women    \n",
       "3  Gujarat Giants Women Vs Mumbai Indians Women  Gujarat Giants Women    \n",
       "4  Gujarat Giants Women Vs Mumbai Indians Women  Gujarat Giants Women    \n",
       "\n",
       "         bowlerName overs maiden runs wickets economy 0s 4s 6s wides noBalls  \\\n",
       "0  Ashleigh Gardner     4      0   38       1    9.50  7  7  0     0       0   \n",
       "1       Mansi Joshi     2      0   17       0    8.50  7  2  1     1       0   \n",
       "2     Tanuja Kanwar     2      0   12       1    6.00  6  2  0     0       0   \n",
       "3      Monica Patel     2      0   34       0   17.00  1  7  0     2       0   \n",
       "4   Georgia Wareham     3      0   30       1   10.00  6  4  1     0       0   \n",
       "\n",
       "   matchID  \n",
       "0  WT20#12  \n",
       "1  WT20#12  \n",
       "2  WT20#12  \n",
       "3  WT20#12  \n",
       "4  WT20#12  "
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_bowling['matchID'] = df_bowling['match'].map(match_dict)\n",
    "df_bowling.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "66cf8dc4",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_bowling.to_csv('WPL_csv_files/bowling_summary.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "d5d6744d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(73, 6)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>team</th>\n",
       "      <th>link</th>\n",
       "      <th>battingStyle</th>\n",
       "      <th>bowlingStyle/WK</th>\n",
       "      <th>playingRole</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Yastika Bhatia</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>https://www.espncricinfo.com/cricketers/yastik...</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Wicketkeeper</td>\n",
       "      <td>Middle order Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Hayley Matthews</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>https://www.espncricinfo.com/cricketers/hayley...</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Offbreak</td>\n",
       "      <td>Opening Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Nat Sciver-Brunt</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>https://www.espncricinfo.com/cricketers/nat-sc...</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Medium</td>\n",
       "      <td>Allrounder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Harmanpreet Kaur</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>https://www.espncricinfo.com/cricketers/harman...</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Offbreak</td>\n",
       "      <td>Allrounder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Amelia Kerr</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>https://www.espncricinfo.com/cricketers/amelia...</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Legbreak</td>\n",
       "      <td>Allrounder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Pooja Vastrakar</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>https://www.espncricinfo.com/cricketers/pooja-...</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Medium</td>\n",
       "      <td>Bowler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Issy Wong</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>https://www.espncricinfo.com/cricketers/issy-w...</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Fast medium</td>\n",
       "      <td>Bowler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Sabbhineni Meghana</td>\n",
       "      <td>Gujarat Giants Women</td>\n",
       "      <td>https://www.espncricinfo.com/cricketers/sabbhi...</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Medium</td>\n",
       "      <td>Opening Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Beth Mooney</td>\n",
       "      <td>Gujarat Giants Women</td>\n",
       "      <td>https://www.espncricinfo.com/cricketers/beth-m...</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Wicketkeeper</td>\n",
       "      <td>Wicketkeeper Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Harleen Deol</td>\n",
       "      <td>Gujarat Giants Women</td>\n",
       "      <td>https://www.espncricinfo.com/cricketers/harlee...</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Offbreak, Legbreak Googly</td>\n",
       "      <td>Middle order Batter</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 name                   team  \\\n",
       "0      Yastika Bhatia  Mumbai Indians Women    \n",
       "1     Hayley Matthews  Mumbai Indians Women    \n",
       "2    Nat Sciver-Brunt  Mumbai Indians Women    \n",
       "3    Harmanpreet Kaur  Mumbai Indians Women    \n",
       "4         Amelia Kerr  Mumbai Indians Women    \n",
       "5     Pooja Vastrakar  Mumbai Indians Women    \n",
       "6           Issy Wong  Mumbai Indians Women    \n",
       "7  Sabbhineni Meghana  Gujarat Giants Women    \n",
       "8         Beth Mooney  Gujarat Giants Women    \n",
       "9        Harleen Deol  Gujarat Giants Women    \n",
       "\n",
       "                                                link    battingStyle  \\\n",
       "0  https://www.espncricinfo.com/cricketers/yastik...   Left hand Bat   \n",
       "1  https://www.espncricinfo.com/cricketers/hayley...  Right hand Bat   \n",
       "2  https://www.espncricinfo.com/cricketers/nat-sc...  Right hand Bat   \n",
       "3  https://www.espncricinfo.com/cricketers/harman...  Right hand Bat   \n",
       "4  https://www.espncricinfo.com/cricketers/amelia...  Right hand Bat   \n",
       "5  https://www.espncricinfo.com/cricketers/pooja-...  Right hand Bat   \n",
       "6  https://www.espncricinfo.com/cricketers/issy-w...  Right hand Bat   \n",
       "7  https://www.espncricinfo.com/cricketers/sabbhi...  Right hand Bat   \n",
       "8  https://www.espncricinfo.com/cricketers/beth-m...   Left hand Bat   \n",
       "9  https://www.espncricinfo.com/cricketers/harlee...  Right hand Bat   \n",
       "\n",
       "                       bowlingStyle/WK          playingRole  \n",
       "0                         Wicketkeeper  Middle order Batter  \n",
       "1                   Right arm Offbreak       Opening Batter  \n",
       "2                     Right arm Medium           Allrounder  \n",
       "3                   Right arm Offbreak           Allrounder  \n",
       "4                             Legbreak           Allrounder  \n",
       "5                     Right arm Medium               Bowler  \n",
       "6                Right arm Fast medium               Bowler  \n",
       "7                     Right arm Medium       Opening Batter  \n",
       "8                         Wicketkeeper  Wicketkeeper Batter  \n",
       "9  Right arm Offbreak, Legbreak Googly  Middle order Batter  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "with open('WPL_json_files/player_info.json') as f:\n",
    "    data = json.load(f)\n",
    "df_players = pd.DataFrame(data)\n",
    "\n",
    "print(df_players.shape)\n",
    "df_players.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "8d442c6c",
   "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>name</th>\n",
       "      <th>team</th>\n",
       "      <th>battingStyle</th>\n",
       "      <th>bowlingStyle/WK</th>\n",
       "      <th>playingRole</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Yastika Bhatia</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Wicketkeeper</td>\n",
       "      <td>Middle order Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Hayley Matthews</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Offbreak</td>\n",
       "      <td>Opening Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Nat Sciver-Brunt</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Medium</td>\n",
       "      <td>Allrounder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Harmanpreet Kaur</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Offbreak</td>\n",
       "      <td>Allrounder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Amelia Kerr</td>\n",
       "      <td>Mumbai Indians Women</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Legbreak</td>\n",
       "      <td>Allrounder</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               name                   team    battingStyle  \\\n",
       "0    Yastika Bhatia  Mumbai Indians Women    Left hand Bat   \n",
       "1   Hayley Matthews  Mumbai Indians Women   Right hand Bat   \n",
       "2  Nat Sciver-Brunt  Mumbai Indians Women   Right hand Bat   \n",
       "3  Harmanpreet Kaur  Mumbai Indians Women   Right hand Bat   \n",
       "4       Amelia Kerr  Mumbai Indians Women   Right hand Bat   \n",
       "\n",
       "      bowlingStyle/WK          playingRole  \n",
       "0        Wicketkeeper  Middle order Batter  \n",
       "1  Right arm Offbreak       Opening Batter  \n",
       "2    Right arm Medium           Allrounder  \n",
       "3  Right arm Offbreak           Allrounder  \n",
       "4            Legbreak           Allrounder  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_players.drop(columns=[\"link\"],inplace=True)\n",
    "df_players.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "64e913ab",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_players.to_csv('WPL_csv_files/player_info.csv', index = False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}