fantasy-ipl-dream-team.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "69e93c77",
   "metadata": {
    "_cell_guid": "b1076dfc-b9ad-4769-8c92-a6c4dae69d19",
    "_uuid": "8f2839f25d086af736a60e9eeb907d3b93b6e0e5",
    "execution": {
     "iopub.execute_input": "2021-08-20T15:34:48.256495Z",
     "iopub.status.busy": "2021-08-20T15:34:48.255199Z",
     "iopub.status.idle": "2021-08-20T15:34:48.280946Z",
     "shell.execute_reply": "2021-08-20T15:34:48.280171Z",
     "shell.execute_reply.started": "2021-08-20T15:30:56.000002Z"
    },
    "papermill": {
     "duration": 0.052565,
     "end_time": "2021-08-20T15:34:48.281180",
     "exception": false,
     "start_time": "2021-08-20T15:34:48.228615",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/kaggle/input/ipl-complete-dataset-20082020/IPL Matches 2008-2020.csv\n",
      "/kaggle/input/ipl-complete-dataset-20082020/IPL Ball-by-Ball 2008-2020.csv\n"
     ]
    }
   ],
   "source": [
    "# This Python 3 environment comes with many helpful analytics libraries installed\n",
    "# It is defined by the kaggle/python Docker image: https://github.com/kaggle/docker-python\n",
    "# For example, here's several helpful packages to load\n",
    "\n",
    "import numpy as np # linear algebra\n",
    "import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n",
    "\n",
    "# Input data files are available in the read-only \"../input/\" directory\n",
    "# For example, running this (by clicking run or pressing Shift+Enter) will list all files under the input directory\n",
    "\n",
    "import os\n",
    "for dirname, _, filenames in os.walk('/kaggle/input'):\n",
    "    for filename in filenames:\n",
    "        print(os.path.join(dirname, filename))\n",
    "\n",
    "# You can write up to 20GB to the current directory (/kaggle/working/) that gets preserved as output when you create a version using \"Save & Run All\" \n",
    "# You can also write temporary files to /kaggle/temp/, but they won't be saved outside of the current session"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "743d3c69",
   "metadata": {
    "papermill": {
     "duration": 0.021027,
     "end_time": "2021-08-20T15:34:48.324802",
     "exception": false,
     "start_time": "2021-08-20T15:34:48.303775",
     "status": "completed"
    },
    "tags": []
   },
   "source": [
    "<font size=\"+3\" color=red><b> <center><u> Fantasy IPL Dream Team🏏 for whole tournament and season 2020 </u></center></b></font>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "e3e552a9",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:34:48.374042Z",
     "iopub.status.busy": "2021-08-20T15:34:48.373347Z",
     "iopub.status.idle": "2021-08-20T15:34:48.522796Z",
     "shell.execute_reply": "2021-08-20T15:34:48.522250Z",
     "shell.execute_reply.started": "2021-08-20T15:32:34.089562Z"
    },
    "papermill": {
     "duration": 0.175768,
     "end_time": "2021-08-20T15:34:48.522945",
     "exception": false,
     "start_time": "2021-08-20T15:34:48.347177",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>city</th>\n",
       "      <th>date</th>\n",
       "      <th>player_of_match</th>\n",
       "      <th>venue</th>\n",
       "      <th>neutral_venue</th>\n",
       "      <th>team1</th>\n",
       "      <th>team2</th>\n",
       "      <th>toss_winner</th>\n",
       "      <th>toss_decision</th>\n",
       "      <th>winner</th>\n",
       "      <th>result</th>\n",
       "      <th>result_margin</th>\n",
       "      <th>eliminator</th>\n",
       "      <th>method</th>\n",
       "      <th>umpire1</th>\n",
       "      <th>umpire2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>2008-04-18</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>0</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>field</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>runs</td>\n",
       "      <td>140.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Asad Rauf</td>\n",
       "      <td>RE Koertzen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>335983</td>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>2008-04-19</td>\n",
       "      <td>MEK Hussey</td>\n",
       "      <td>Punjab Cricket Association Stadium, Mohali</td>\n",
       "      <td>0</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>bat</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>runs</td>\n",
       "      <td>33.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MR Benson</td>\n",
       "      <td>SL Shastri</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>335984</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>2008-04-19</td>\n",
       "      <td>MF Maharoof</td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>0</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>bat</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>wickets</td>\n",
       "      <td>9.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aleem Dar</td>\n",
       "      <td>GA Pratapkumar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>335985</td>\n",
       "      <td>Mumbai</td>\n",
       "      <td>2008-04-20</td>\n",
       "      <td>MV Boucher</td>\n",
       "      <td>Wankhede Stadium</td>\n",
       "      <td>0</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>bat</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>wickets</td>\n",
       "      <td>5.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SJ Davis</td>\n",
       "      <td>DJ Harper</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>335986</td>\n",
       "      <td>Kolkata</td>\n",
       "      <td>2008-04-20</td>\n",
       "      <td>DJ Hussey</td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>0</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>bat</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>wickets</td>\n",
       "      <td>5.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BF Bowden</td>\n",
       "      <td>K Hariharan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       id        city        date player_of_match  \\\n",
       "0  335982   Bangalore  2008-04-18     BB McCullum   \n",
       "1  335983  Chandigarh  2008-04-19      MEK Hussey   \n",
       "2  335984       Delhi  2008-04-19     MF Maharoof   \n",
       "3  335985      Mumbai  2008-04-20      MV Boucher   \n",
       "4  335986     Kolkata  2008-04-20       DJ Hussey   \n",
       "\n",
       "                                        venue  neutral_venue  \\\n",
       "0                       M Chinnaswamy Stadium              0   \n",
       "1  Punjab Cricket Association Stadium, Mohali              0   \n",
       "2                            Feroz Shah Kotla              0   \n",
       "3                            Wankhede Stadium              0   \n",
       "4                                Eden Gardens              0   \n",
       "\n",
       "                         team1                        team2  \\\n",
       "0  Royal Challengers Bangalore        Kolkata Knight Riders   \n",
       "1              Kings XI Punjab          Chennai Super Kings   \n",
       "2             Delhi Daredevils             Rajasthan Royals   \n",
       "3               Mumbai Indians  Royal Challengers Bangalore   \n",
       "4        Kolkata Knight Riders              Deccan Chargers   \n",
       "\n",
       "                   toss_winner toss_decision                       winner  \\\n",
       "0  Royal Challengers Bangalore         field        Kolkata Knight Riders   \n",
       "1          Chennai Super Kings           bat          Chennai Super Kings   \n",
       "2             Rajasthan Royals           bat             Delhi Daredevils   \n",
       "3               Mumbai Indians           bat  Royal Challengers Bangalore   \n",
       "4              Deccan Chargers           bat        Kolkata Knight Riders   \n",
       "\n",
       "    result  result_margin eliminator method    umpire1         umpire2  \n",
       "0     runs          140.0          N    NaN  Asad Rauf     RE Koertzen  \n",
       "1     runs           33.0          N    NaN  MR Benson      SL Shastri  \n",
       "2  wickets            9.0          N    NaN  Aleem Dar  GA Pratapkumar  \n",
       "3  wickets            5.0          N    NaN   SJ Davis       DJ Harper  \n",
       "4  wickets            5.0          N    NaN  BF Bowden     K Hariharan  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1=pd.read_csv(\"/kaggle/input/ipl-complete-dataset-20082020/IPL Matches 2008-2020.csv\")\n",
    "df1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "e9165d43",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:34:48.571555Z",
     "iopub.status.busy": "2021-08-20T15:34:48.570868Z",
     "iopub.status.idle": "2021-08-20T15:34:49.233787Z",
     "shell.execute_reply": "2021-08-20T15:34:49.233213Z",
     "shell.execute_reply.started": "2021-08-20T15:32:36.838759Z"
    },
    "papermill": {
     "duration": 0.688631,
     "end_time": "2021-08-20T15:34:49.233941",
     "exception": false,
     "start_time": "2021-08-20T15:34:48.545310",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>inning</th>\n",
       "      <th>over</th>\n",
       "      <th>ball</th>\n",
       "      <th>batsman</th>\n",
       "      <th>non_striker</th>\n",
       "      <th>bowler</th>\n",
       "      <th>batsman_runs</th>\n",
       "      <th>extra_runs</th>\n",
       "      <th>total_runs</th>\n",
       "      <th>non_boundary</th>\n",
       "      <th>is_wicket</th>\n",
       "      <th>dismissal_kind</th>\n",
       "      <th>player_dismissed</th>\n",
       "      <th>fielder</th>\n",
       "      <th>extras_type</th>\n",
       "      <th>batting_team</th>\n",
       "      <th>bowling_team</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>335982</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>RT Ponting</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>AA Noffke</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>335982</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>RT Ponting</td>\n",
       "      <td>AA Noffke</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>335982</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>RT Ponting</td>\n",
       "      <td>Z Khan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>335982</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>RT Ponting</td>\n",
       "      <td>Z Khan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>335982</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>RT Ponting</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>Z Khan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       id  inning  over  ball      batsman  non_striker     bowler  \\\n",
       "0  335982       1     6     5   RT Ponting  BB McCullum  AA Noffke   \n",
       "1  335982       1     6     6  BB McCullum   RT Ponting  AA Noffke   \n",
       "2  335982       1     7     1  BB McCullum   RT Ponting     Z Khan   \n",
       "3  335982       1     7     2  BB McCullum   RT Ponting     Z Khan   \n",
       "4  335982       1     7     3   RT Ponting  BB McCullum     Z Khan   \n",
       "\n",
       "   batsman_runs  extra_runs  total_runs  non_boundary  is_wicket  \\\n",
       "0             1           0           1             0          0   \n",
       "1             1           0           1             0          0   \n",
       "2             0           0           0             0          0   \n",
       "3             1           0           1             0          0   \n",
       "4             1           0           1             0          0   \n",
       "\n",
       "  dismissal_kind player_dismissed fielder extras_type           batting_team  \\\n",
       "0            NaN              NaN     NaN         NaN  Kolkata Knight Riders   \n",
       "1            NaN              NaN     NaN         NaN  Kolkata Knight Riders   \n",
       "2            NaN              NaN     NaN         NaN  Kolkata Knight Riders   \n",
       "3            NaN              NaN     NaN         NaN  Kolkata Knight Riders   \n",
       "4            NaN              NaN     NaN         NaN  Kolkata Knight Riders   \n",
       "\n",
       "                  bowling_team  \n",
       "0  Royal Challengers Bangalore  \n",
       "1  Royal Challengers Bangalore  \n",
       "2  Royal Challengers Bangalore  \n",
       "3  Royal Challengers Bangalore  \n",
       "4  Royal Challengers Bangalore  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2=pd.read_csv(\"/kaggle/input/ipl-complete-dataset-20082020/IPL Ball-by-Ball 2008-2020.csv\")\n",
    "df2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "f5302a8b",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:34:49.291323Z",
     "iopub.status.busy": "2021-08-20T15:34:49.288630Z",
     "iopub.status.idle": "2021-08-20T15:34:49.635583Z",
     "shell.execute_reply": "2021-08-20T15:34:49.634910Z",
     "shell.execute_reply.started": "2021-08-20T15:32:39.293708Z"
    },
    "papermill": {
     "duration": 0.379369,
     "end_time": "2021-08-20T15:34:49.635746",
     "exception": false,
     "start_time": "2021-08-20T15:34:49.256377",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "# We need two dataframes one is for whole tournament and other is for year 2020\n",
    "# Merge df1 and df2(onle two columns(id,date)) on 'id'\n",
    "data = pd.merge(df2, df1[['id','date']], on='id',how='left')\n",
    "\n",
    "# Extract year from date column\n",
    "data['year'] = pd.to_datetime(data['date']).dt.year\n",
    "data.drop('date',axis=1,inplace=True)\n",
    "\n",
    "# This dataframe is only for year 2020\n",
    "season_2020 = data[data['year']==2020]\n",
    "# This is basically copy of df2 because it contains data of whole tournament\n",
    "tournament = df2.copy()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3319d957",
   "metadata": {
    "papermill": {
     "duration": 0.022743,
     "end_time": "2021-08-20T15:34:49.681697",
     "exception": false,
     "start_time": "2021-08-20T15:34:49.658954",
     "status": "completed"
    },
    "tags": []
   },
   "source": [
    "# ****Batting Points****\n",
    "\n",
    " **Run                       -> +1**\n",
    " \n",
    " **Boundary Bonus            -> +1**\n",
    " \n",
    " **Six Bonus                 -> +2**\n",
    " \n",
    " **30 Run Bonus              -> +4**\n",
    " \n",
    " **Half-century Bonus        -> +8**\n",
    " \n",
    " **Century Bonus             -> +16**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "3c3e4383",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:34:49.741883Z",
     "iopub.status.busy": "2021-08-20T15:34:49.741110Z",
     "iopub.status.idle": "2021-08-20T15:34:49.744068Z",
     "shell.execute_reply": "2021-08-20T15:34:49.743477Z",
     "shell.execute_reply.started": "2021-08-20T15:32:46.731969Z"
    },
    "papermill": {
     "duration": 0.039122,
     "end_time": "2021-08-20T15:34:49.744234",
     "exception": false,
     "start_time": "2021-08-20T15:34:49.705112",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "# It finds bat_score according to point system mentioned above.\n",
    "def batsman_score(x):\n",
    "    x[\"bat_score\"]=1*x[\"runs\"]+1*x[\"fours\"]+2*x[\"sixes\"]+4*x[\"thirty\"]+8*x[\"fifty\"]+16*x[\"century\"]\n",
    "    return x\n",
    "\n",
    "def get_bat_stats(df):\n",
    "    # Initialize batting dataframe.\n",
    "    batting_df = pd.DataFrame(columns=[\"player\",\"runs\",\"fours\",\"sixes\",\"thirty\",\"fifty\",\"century\"])\n",
    "\n",
    "    # Let's use groupby function. Our aim is to find batting score so we'll group our data by batsman.\n",
    "    for player,details in df.groupby(\"batsman\"):\n",
    "        total_runs = sum(details[\"batsman_runs\"])\n",
    "\n",
    "        # If batsman_runs is 4 then we count it as four.\n",
    "        fours=0\n",
    "        try:\n",
    "            fours=details[\"batsman_runs\"].value_counts()[4]\n",
    "        except:\n",
    "            fours=0      \n",
    "\n",
    "        # If batsman_runs is 6 then we count it as six.\n",
    "        sixes=0\n",
    "        try:\n",
    "            sixes=details[\"batsman_runs\"].value_counts()[6]\n",
    "        except:\n",
    "            sixes=0 \n",
    "\n",
    "        thirty=0\n",
    "        fifty=0\n",
    "        century=0\n",
    "\n",
    "        # To find thirty, fifty, century of the player we need to group our dataframe(details) by match id.\n",
    "        for match,match_details in details.groupby(\"id\"):\n",
    "\n",
    "            # Find total score of the player by sum up total runs.\n",
    "            match_score = sum(match_details[\"batsman_runs\"])\n",
    "\n",
    "            # Accourding to match_score this count thirties, fifties, centuries.\n",
    "            if match_score>=100:\n",
    "                century+=1\n",
    "            elif match_score>=50:\n",
    "                fifty+=1\n",
    "            elif match_score>=30:\n",
    "                thirty+=1\n",
    "\n",
    "        # Store all the data into batting dataframe.\n",
    "        batting_df = batting_df.append({\"player\":player,\"runs\":total_runs,\"fours\":fours,\"sixes\":sixes,\"thirty\":thirty,\"fifty\":fifty,\"century\":century},ignore_index=True)\n",
    "    \n",
    "    # To find bat_score we apply batsman_score function\n",
    "    batting_df=batting_df.apply(batsman_score,axis=1)\n",
    "    return batting_df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e408df80",
   "metadata": {
    "papermill": {
     "duration": 0.022541,
     "end_time": "2021-08-20T15:34:49.790123",
     "exception": false,
     "start_time": "2021-08-20T15:34:49.767582",
     "status": "completed"
    },
    "tags": []
   },
   "source": [
    "# ****Bowling Points****\n",
    "\n",
    " **Wicket                  -> +25**\n",
    " \n",
    " **Bonus (LBW / Bowled)    -> +8**\n",
    " \n",
    " **3 Wicket Bonus          -> +4**\n",
    " \n",
    " **4 Wicket Bonus          -> +8**\n",
    " \n",
    " **5 Wicket Bonus          -> +16**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "dea84ff7",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:34:49.841419Z",
     "iopub.status.busy": "2021-08-20T15:34:49.840703Z",
     "iopub.status.idle": "2021-08-20T15:34:49.850321Z",
     "shell.execute_reply": "2021-08-20T15:34:49.850869Z",
     "shell.execute_reply.started": "2021-08-20T15:32:51.370027Z"
    },
    "papermill": {
     "duration": 0.036271,
     "end_time": "2021-08-20T15:34:49.851096",
     "exception": false,
     "start_time": "2021-08-20T15:34:49.814825",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "# Same as bat_score here we find bowl_score through point system mentioned above.\n",
    "def bowler_score(x):\n",
    "    x[\"bowl_score\"]=25*x[\"wickets\"]+8*x[\"lbw_or_bowled\"]+4*x[\"three_wickets\"]+8*x[\"four_wickets\"]+16*x[\"five_wickets\"]\n",
    "    return x\n",
    "\n",
    "def get_bowl_stats(df):\n",
    "    # Initialize bowling dataframe.\n",
    "    bowling_df = pd.DataFrame(columns=[\"player\",\"wickets\",\"lbw_or_bowled\",\"three_wickets\",\"four_wickets\",\"five_wickets\"])\n",
    "\n",
    "    # Let's use groupby function. Our aim is to find bowling score so we'll group our data by bowler.\n",
    "    for player,details in df.groupby(\"bowler\"):\n",
    "\n",
    "        # It finds the length of dataframe where dismissal kind is either lbw or bowled\n",
    "        lbw_or_bowled=len(details.query('dismissal_kind == \"lbw\" or dismissal_kind == \"bowled\"'))\n",
    "\n",
    "        total_wickets=0\n",
    "        three_wickets=0\n",
    "        four_wickets=0\n",
    "        fifer=0\n",
    "\n",
    "        # To find three wicket haul, four wicket haul and five wicket haul we should group dataframe(details) again by match id.\n",
    "        for match,match_details in details.groupby(\"id\"):\n",
    "            wickets = len(match_details.query('dismissal_kind in [\"caught\",\"bowled\",\"lbw\",\"stumped\",\"caught and bowled\"]'))\n",
    "            if wickets>=3:\n",
    "                three_wickets+=1\n",
    "            elif wickets>=4:\n",
    "                four_wickets+=1\n",
    "            elif wickets>=5:\n",
    "                fifer+=1\n",
    "            # Need to add every match wickets into total_wickets to find total wickets of bowler.\n",
    "            total_wickets+=wickets\n",
    "\n",
    "        # Store all the data into bowling dataframe.\n",
    "        bowling_df = bowling_df.append({\"player\":player,\"wickets\":total_wickets,\"lbw_or_bowled\":lbw_or_bowled,\"three_wickets\":three_wickets,\"four_wickets\":four_wickets,\"five_wickets\":fifer},ignore_index=True)\n",
    "        \n",
    "    # To find bowl_score we apply bowler_score function.\n",
    "    bowling_df=bowling_df.apply(bowler_score,axis=1) \n",
    "    return bowling_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "1d4bb765",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:34:49.900644Z",
     "iopub.status.busy": "2021-08-20T15:34:49.899891Z",
     "iopub.status.idle": "2021-08-20T15:34:49.904460Z",
     "shell.execute_reply": "2021-08-20T15:34:49.905232Z",
     "shell.execute_reply.started": "2021-08-20T15:32:54.574084Z"
    },
    "papermill": {
     "duration": 0.031383,
     "end_time": "2021-08-20T15:34:49.905467",
     "exception": false,
     "start_time": "2021-08-20T15:34:49.874084",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "def get_wicketkeepers(df):\n",
    "    # Let's find out wicketkeepers from this dataset. To achieve this we'll check dismissal kind, if it is stumpout then store such fielders name into list\n",
    "    return list(df.query('dismissal_kind == \"stumped\"')['fielder'].unique())"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "91f35683",
   "metadata": {
    "papermill": {
     "duration": 0.023745,
     "end_time": "2021-08-20T15:34:49.952674",
     "exception": false,
     "start_time": "2021-08-20T15:34:49.928929",
     "status": "completed"
    },
    "tags": []
   },
   "source": [
    "**Our Dream11 team will have different combinations of players...**\n",
    "\n",
    "**Batsman (BAT) - 4**\n",
    "\n",
    "**Wicket Keeper (WK) - 1**\n",
    "\n",
    "**All Rounder (AR) - 3**\n",
    "\n",
    "**Bowler (BWL) - 3**"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5be88b81",
   "metadata": {
    "papermill": {
     "duration": 0.022349,
     "end_time": "2021-08-20T15:34:49.997932",
     "exception": false,
     "start_time": "2021-08-20T15:34:49.975583",
     "status": "completed"
    },
    "tags": []
   },
   "source": [
    "# **For whole Tournament**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "3f608fdb",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:34:50.048690Z",
     "iopub.status.busy": "2021-08-20T15:34:50.047999Z",
     "iopub.status.idle": "2021-08-20T15:34:55.229016Z",
     "shell.execute_reply": "2021-08-20T15:34:55.228449Z",
     "shell.execute_reply.started": "2021-08-20T15:32:58.729320Z"
    },
    "papermill": {
     "duration": 5.206709,
     "end_time": "2021-08-20T15:34:55.229188",
     "exception": false,
     "start_time": "2021-08-20T15:34:50.022479",
     "status": "completed"
    },
    "tags": []
   },
   "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>player</th>\n",
       "      <th>runs</th>\n",
       "      <th>fours</th>\n",
       "      <th>sixes</th>\n",
       "      <th>thirty</th>\n",
       "      <th>fifty</th>\n",
       "      <th>century</th>\n",
       "      <th>bat_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A Ashish Reddy</td>\n",
       "      <td>280</td>\n",
       "      <td>16</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A Chandila</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A Chopra</td>\n",
       "      <td>53</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A Choudhary</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A Dananjaya</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           player  runs  fours  sixes  thirty  fifty  century  bat_score\n",
       "0  A Ashish Reddy   280     16     15       2      0        0        334\n",
       "1      A Chandila     4      0      0       0      0        0          4\n",
       "2        A Chopra    53      7      0       0      0        0         60\n",
       "3     A Choudhary    25      1      1       0      0        0         28\n",
       "4     A Dananjaya     4      0      0       0      0        0          4"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "batsmen_tournament = get_bat_stats(tournament)\n",
    "batsmen_tournament.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "919dfb3b",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:34:55.297243Z",
     "iopub.status.busy": "2021-08-20T15:34:55.296484Z",
     "iopub.status.idle": "2021-08-20T15:35:32.307032Z",
     "shell.execute_reply": "2021-08-20T15:35:32.307548Z",
     "shell.execute_reply.started": "2021-08-20T15:33:06.284209Z"
    },
    "papermill": {
     "duration": 37.055043,
     "end_time": "2021-08-20T15:35:32.307731",
     "exception": false,
     "start_time": "2021-08-20T15:34:55.252688",
     "status": "completed"
    },
    "tags": []
   },
   "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>player</th>\n",
       "      <th>wickets</th>\n",
       "      <th>lbw_or_bowled</th>\n",
       "      <th>three_wickets</th>\n",
       "      <th>four_wickets</th>\n",
       "      <th>five_wickets</th>\n",
       "      <th>bowl_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A Ashish Reddy</td>\n",
       "      <td>18</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A Chandila</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A Choudhary</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A Dananjaya</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A Flintoff</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           player  wickets  lbw_or_bowled  three_wickets  four_wickets  \\\n",
       "0  A Ashish Reddy       18              9              1             0   \n",
       "1      A Chandila       11              0              1             0   \n",
       "2     A Choudhary        5              0              0             0   \n",
       "3     A Dananjaya        0              0              0             0   \n",
       "4      A Flintoff        2              0              0             0   \n",
       "\n",
       "   five_wickets  bowl_score  \n",
       "0             0         526  \n",
       "1             0         279  \n",
       "2             0         125  \n",
       "3             0           0  \n",
       "4             0          50  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bowlers_tournament = get_bowl_stats(tournament)\n",
    "bowlers_tournament.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "86f7905e",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:35:32.360456Z",
     "iopub.status.busy": "2021-08-20T15:35:32.359764Z",
     "iopub.status.idle": "2021-08-20T15:35:32.388427Z",
     "shell.execute_reply": "2021-08-20T15:35:32.388915Z",
     "shell.execute_reply.started": "2021-08-20T15:33:50.209340Z"
    },
    "papermill": {
     "duration": 0.058402,
     "end_time": "2021-08-20T15:35:32.389114",
     "exception": false,
     "start_time": "2021-08-20T15:35:32.330712",
     "status": "completed"
    },
    "tags": []
   },
   "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>player</th>\n",
       "      <th>runs</th>\n",
       "      <th>fours</th>\n",
       "      <th>sixes</th>\n",
       "      <th>thirty</th>\n",
       "      <th>fifty</th>\n",
       "      <th>century</th>\n",
       "      <th>bat_score</th>\n",
       "      <th>wickets</th>\n",
       "      <th>lbw_or_bowled</th>\n",
       "      <th>three_wickets</th>\n",
       "      <th>four_wickets</th>\n",
       "      <th>five_wickets</th>\n",
       "      <th>bowl_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A Ashish Reddy</td>\n",
       "      <td>280.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>334.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>526.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A Chandila</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>279.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A Chopra</td>\n",
       "      <td>53.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A Choudhary</td>\n",
       "      <td>25.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>125.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A Dananjaya</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           player   runs  fours  sixes  thirty  fifty  century  bat_score  \\\n",
       "0  A Ashish Reddy  280.0   16.0   15.0     2.0    0.0      0.0      334.0   \n",
       "1      A Chandila    4.0    0.0    0.0     0.0    0.0      0.0        4.0   \n",
       "2        A Chopra   53.0    7.0    0.0     0.0    0.0      0.0       60.0   \n",
       "3     A Choudhary   25.0    1.0    1.0     0.0    0.0      0.0       28.0   \n",
       "4     A Dananjaya    4.0    0.0    0.0     0.0    0.0      0.0        4.0   \n",
       "\n",
       "   wickets  lbw_or_bowled  three_wickets  four_wickets  five_wickets  \\\n",
       "0     18.0            9.0            1.0           0.0           0.0   \n",
       "1     11.0            0.0            1.0           0.0           0.0   \n",
       "2      0.0            0.0            0.0           0.0           0.0   \n",
       "3      5.0            0.0            0.0           0.0           0.0   \n",
       "4      0.0            0.0            0.0           0.0           0.0   \n",
       "\n",
       "   bowl_score  \n",
       "0       526.0  \n",
       "1       279.0  \n",
       "2         0.0  \n",
       "3       125.0  \n",
       "4         0.0  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_data_tournament = pd.merge(batsmen_tournament,bowlers_tournament,on=\"player\",how=\"outer\").fillna(0)\n",
    "merged_data_tournament.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "afe7d7fe",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:35:32.439868Z",
     "iopub.status.busy": "2021-08-20T15:35:32.439142Z",
     "iopub.status.idle": "2021-08-20T15:35:32.465713Z",
     "shell.execute_reply": "2021-08-20T15:35:32.466295Z",
     "shell.execute_reply.started": "2021-08-20T15:33:52.729295Z"
    },
    "papermill": {
     "duration": 0.053495,
     "end_time": "2021-08-20T15:35:32.466472",
     "exception": false,
     "start_time": "2021-08-20T15:35:32.412977",
     "status": "completed"
    },
    "tags": []
   },
   "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>player</th>\n",
       "      <th>runs</th>\n",
       "      <th>fours</th>\n",
       "      <th>sixes</th>\n",
       "      <th>thirty</th>\n",
       "      <th>fifty</th>\n",
       "      <th>century</th>\n",
       "      <th>bat_score</th>\n",
       "      <th>wickets</th>\n",
       "      <th>lbw_or_bowled</th>\n",
       "      <th>three_wickets</th>\n",
       "      <th>four_wickets</th>\n",
       "      <th>five_wickets</th>\n",
       "      <th>bowl_score</th>\n",
       "      <th>allrounder_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A Ashish Reddy</td>\n",
       "      <td>280.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>334.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>526.0</td>\n",
       "      <td>175.684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A Chandila</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>279.0</td>\n",
       "      <td>1.116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A Chopra</td>\n",
       "      <td>53.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A Choudhary</td>\n",
       "      <td>25.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>3.500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A Dananjaya</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           player   runs  fours  sixes  thirty  fifty  century  bat_score  \\\n",
       "0  A Ashish Reddy  280.0   16.0   15.0     2.0    0.0      0.0      334.0   \n",
       "1      A Chandila    4.0    0.0    0.0     0.0    0.0      0.0        4.0   \n",
       "2        A Chopra   53.0    7.0    0.0     0.0    0.0      0.0       60.0   \n",
       "3     A Choudhary   25.0    1.0    1.0     0.0    0.0      0.0       28.0   \n",
       "4     A Dananjaya    4.0    0.0    0.0     0.0    0.0      0.0        4.0   \n",
       "\n",
       "   wickets  lbw_or_bowled  three_wickets  four_wickets  five_wickets  \\\n",
       "0     18.0            9.0            1.0           0.0           0.0   \n",
       "1     11.0            0.0            1.0           0.0           0.0   \n",
       "2      0.0            0.0            0.0           0.0           0.0   \n",
       "3      5.0            0.0            0.0           0.0           0.0   \n",
       "4      0.0            0.0            0.0           0.0           0.0   \n",
       "\n",
       "   bowl_score  allrounder_score  \n",
       "0       526.0           175.684  \n",
       "1       279.0             1.116  \n",
       "2         0.0             0.000  \n",
       "3       125.0             3.500  \n",
       "4         0.0             0.000  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Find allrounder score\n",
    "merged_data_tournament['allrounder_score']=(merged_data_tournament['bat_score']*merged_data_tournament['bowl_score'])/1000\n",
    "merged_data_tournament.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "30e6a824",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:35:32.519716Z",
     "iopub.status.busy": "2021-08-20T15:35:32.519111Z",
     "iopub.status.idle": "2021-08-20T15:35:32.546751Z",
     "shell.execute_reply": "2021-08-20T15:35:32.547321Z",
     "shell.execute_reply.started": "2021-08-20T15:33:55.259187Z"
    },
    "papermill": {
     "duration": 0.056169,
     "end_time": "2021-08-20T15:35:32.547500",
     "exception": false,
     "start_time": "2021-08-20T15:35:32.491331",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "wicketkeeper_tournament = get_wicketkeepers(tournament)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "1915586b",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:35:32.599668Z",
     "iopub.status.busy": "2021-08-20T15:35:32.598953Z",
     "iopub.status.idle": "2021-08-20T15:35:32.612501Z",
     "shell.execute_reply": "2021-08-20T15:35:32.613051Z",
     "shell.execute_reply.started": "2021-08-20T15:33:58.179237Z"
    },
    "papermill": {
     "duration": 0.041425,
     "end_time": "2021-08-20T15:35:32.613235",
     "exception": false,
     "start_time": "2021-08-20T15:35:32.571810",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "# According to score in particular role we sort data and store players name into dictionary. This dictonary contains players name and players role.\n",
    "total_batsmen = 4\n",
    "total_bowlers = 3\n",
    "total_allrounders = 3\n",
    "total_wicketkeepers = 1\n",
    "playing_XI_tournament = {}\n",
    "\n",
    "playing_XI_tournament['BAT'] = merged_data_tournament.sort_values(by=\"bat_score\",ascending=False).head(total_batsmen)['player'].to_list()\n",
    "playing_XI_tournament['WK'] = merged_data_tournament.query('player in @wicketkeeper_tournament').sort_values(by=\"bat_score\",ascending=False).head(total_wicketkeepers)['player'].to_list()\n",
    "playing_XI_tournament['AR'] = merged_data_tournament.sort_values(by=\"allrounder_score\",ascending=False).head(total_allrounders)['player'].to_list()\n",
    "playing_XI_tournament['BWL'] = merged_data_tournament.sort_values(by=\"bowl_score\",ascending=False).head(total_bowlers)['player'].to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "eba98909",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:35:32.665110Z",
     "iopub.status.busy": "2021-08-20T15:35:32.664439Z",
     "iopub.status.idle": "2021-08-20T15:35:32.673033Z",
     "shell.execute_reply": "2021-08-20T15:35:32.673604Z",
     "shell.execute_reply.started": "2021-08-20T15:34:01.369044Z"
    },
    "papermill": {
     "duration": 0.035944,
     "end_time": "2021-08-20T15:35:32.673776",
     "exception": false,
     "start_time": "2021-08-20T15:35:32.637832",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Fantasy dream team for the whole tournament\n",
      "\n",
      "V Kohli         BAT\n",
      "SK Raina        BAT\n",
      "DA Warner       BAT\n",
      "RG Sharma       BAT\n",
      "AB de Villiers  WK\n",
      "SR Watson       AR\n",
      "RA Jadeja       AR\n",
      "DJ Bravo        AR\n",
      "SL Malinga      BWL\n",
      "PP Chawla       BWL\n",
      "A Mishra        BWL\n"
     ]
    }
   ],
   "source": [
    "print('Fantasy dream team for the whole tournament\\n')\n",
    "for player_role,players in playing_XI_tournament.items():\n",
    "    for player in players:\n",
    "        print(\"{:15} {}\".format(player,player_role))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b61aa775",
   "metadata": {
    "papermill": {
     "duration": 0.025337,
     "end_time": "2021-08-20T15:35:32.723808",
     "exception": false,
     "start_time": "2021-08-20T15:35:32.698471",
     "status": "completed"
    },
    "tags": []
   },
   "source": [
    "# **For Season 2020**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "76f18194",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:35:32.781744Z",
     "iopub.status.busy": "2021-08-20T15:35:32.781097Z",
     "iopub.status.idle": "2021-08-20T15:35:33.804320Z",
     "shell.execute_reply": "2021-08-20T15:35:33.804774Z",
     "shell.execute_reply.started": "2021-08-20T15:34:03.864506Z"
    },
    "papermill": {
     "duration": 1.05626,
     "end_time": "2021-08-20T15:35:33.804953",
     "exception": false,
     "start_time": "2021-08-20T15:35:32.748693",
     "status": "completed"
    },
    "tags": []
   },
   "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>player</th>\n",
       "      <th>runs</th>\n",
       "      <th>fours</th>\n",
       "      <th>sixes</th>\n",
       "      <th>thirty</th>\n",
       "      <th>fifty</th>\n",
       "      <th>century</th>\n",
       "      <th>bat_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A Nortje</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AB de Villiers</td>\n",
       "      <td>454</td>\n",
       "      <td>33</td>\n",
       "      <td>23</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AD Russell</td>\n",
       "      <td>117</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AJ Finch</td>\n",
       "      <td>268</td>\n",
       "      <td>28</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AJ Tye</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           player  runs  fours  sixes  thirty  fifty  century  bat_score\n",
       "0        A Nortje     7      0      0       0      0        0          7\n",
       "1  AB de Villiers   454     33     23       2      5        0        581\n",
       "2      AD Russell   117      9      9       0      0        0        144\n",
       "3        AJ Finch   268     28      8       2      1        0        328\n",
       "4          AJ Tye     6      0      1       0      0        0          8"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "batsmen_2020 = get_bat_stats(season_2020)\n",
    "batsmen_2020.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "2ac27efb",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:35:33.858848Z",
     "iopub.status.busy": "2021-08-20T15:35:33.858160Z",
     "iopub.status.idle": "2021-08-20T15:35:37.293668Z",
     "shell.execute_reply": "2021-08-20T15:35:37.294164Z",
     "shell.execute_reply.started": "2021-08-20T15:34:07.189302Z"
    },
    "papermill": {
     "duration": 3.464066,
     "end_time": "2021-08-20T15:35:37.294363",
     "exception": false,
     "start_time": "2021-08-20T15:35:33.830297",
     "status": "completed"
    },
    "tags": []
   },
   "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>player</th>\n",
       "      <th>wickets</th>\n",
       "      <th>lbw_or_bowled</th>\n",
       "      <th>three_wickets</th>\n",
       "      <th>four_wickets</th>\n",
       "      <th>five_wickets</th>\n",
       "      <th>bowl_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A Mishra</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A Nortje</td>\n",
       "      <td>22</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A Zampa</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AD Russell</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AJ Tye</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       player  wickets  lbw_or_bowled  three_wickets  four_wickets  \\\n",
       "0    A Mishra        3              0              0             0   \n",
       "1    A Nortje       22              9              2             0   \n",
       "2     A Zampa        2              0              0             0   \n",
       "3  AD Russell        5              1              0             0   \n",
       "4      AJ Tye        1              0              0             0   \n",
       "\n",
       "   five_wickets  bowl_score  \n",
       "0             0          75  \n",
       "1             0         630  \n",
       "2             0          50  \n",
       "3             0         133  \n",
       "4             0          25  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bowlers_2020 = get_bowl_stats(season_2020)\n",
    "bowlers_2020.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "f3af6cae",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:35:37.355632Z",
     "iopub.status.busy": "2021-08-20T15:35:37.354938Z",
     "iopub.status.idle": "2021-08-20T15:35:37.386445Z",
     "shell.execute_reply": "2021-08-20T15:35:37.387188Z",
     "shell.execute_reply.started": "2021-08-20T15:34:12.834327Z"
    },
    "papermill": {
     "duration": 0.064123,
     "end_time": "2021-08-20T15:35:37.387395",
     "exception": false,
     "start_time": "2021-08-20T15:35:37.323272",
     "status": "completed"
    },
    "tags": []
   },
   "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>player</th>\n",
       "      <th>runs</th>\n",
       "      <th>fours</th>\n",
       "      <th>sixes</th>\n",
       "      <th>thirty</th>\n",
       "      <th>fifty</th>\n",
       "      <th>century</th>\n",
       "      <th>bat_score</th>\n",
       "      <th>wickets</th>\n",
       "      <th>lbw_or_bowled</th>\n",
       "      <th>three_wickets</th>\n",
       "      <th>four_wickets</th>\n",
       "      <th>five_wickets</th>\n",
       "      <th>bowl_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A Nortje</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>630.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AB de Villiers</td>\n",
       "      <td>454.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>581.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AD Russell</td>\n",
       "      <td>117.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>133.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AJ Finch</td>\n",
       "      <td>268.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>328.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AJ Tye</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           player   runs  fours  sixes  thirty  fifty  century  bat_score  \\\n",
       "0        A Nortje    7.0    0.0    0.0     0.0    0.0      0.0        7.0   \n",
       "1  AB de Villiers  454.0   33.0   23.0     2.0    5.0      0.0      581.0   \n",
       "2      AD Russell  117.0    9.0    9.0     0.0    0.0      0.0      144.0   \n",
       "3        AJ Finch  268.0   28.0    8.0     2.0    1.0      0.0      328.0   \n",
       "4          AJ Tye    6.0    0.0    1.0     0.0    0.0      0.0        8.0   \n",
       "\n",
       "   wickets  lbw_or_bowled  three_wickets  four_wickets  five_wickets  \\\n",
       "0     22.0            9.0            2.0           0.0           0.0   \n",
       "1      0.0            0.0            0.0           0.0           0.0   \n",
       "2      5.0            1.0            0.0           0.0           0.0   \n",
       "3      0.0            0.0            0.0           0.0           0.0   \n",
       "4      1.0            0.0            0.0           0.0           0.0   \n",
       "\n",
       "   bowl_score  \n",
       "0       630.0  \n",
       "1         0.0  \n",
       "2       133.0  \n",
       "3         0.0  \n",
       "4        25.0  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_data_2020 = pd.merge(batsmen_2020,bowlers_2020,on=\"player\",how=\"outer\").fillna(0)\n",
    "merged_data_2020.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "51e65826",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:35:37.448642Z",
     "iopub.status.busy": "2021-08-20T15:35:37.447972Z",
     "iopub.status.idle": "2021-08-20T15:35:37.475056Z",
     "shell.execute_reply": "2021-08-20T15:35:37.475601Z",
     "shell.execute_reply.started": "2021-08-20T15:34:15.609275Z"
    },
    "papermill": {
     "duration": 0.059782,
     "end_time": "2021-08-20T15:35:37.475787",
     "exception": false,
     "start_time": "2021-08-20T15:35:37.416005",
     "status": "completed"
    },
    "tags": []
   },
   "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>player</th>\n",
       "      <th>runs</th>\n",
       "      <th>fours</th>\n",
       "      <th>sixes</th>\n",
       "      <th>thirty</th>\n",
       "      <th>fifty</th>\n",
       "      <th>century</th>\n",
       "      <th>bat_score</th>\n",
       "      <th>wickets</th>\n",
       "      <th>lbw_or_bowled</th>\n",
       "      <th>three_wickets</th>\n",
       "      <th>four_wickets</th>\n",
       "      <th>five_wickets</th>\n",
       "      <th>bowl_score</th>\n",
       "      <th>allrounder_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A Nortje</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>630.0</td>\n",
       "      <td>4.410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AB de Villiers</td>\n",
       "      <td>454.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>581.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AD Russell</td>\n",
       "      <td>117.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>19.152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AJ Finch</td>\n",
       "      <td>268.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>328.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AJ Tye</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0.200</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           player   runs  fours  sixes  thirty  fifty  century  bat_score  \\\n",
       "0        A Nortje    7.0    0.0    0.0     0.0    0.0      0.0        7.0   \n",
       "1  AB de Villiers  454.0   33.0   23.0     2.0    5.0      0.0      581.0   \n",
       "2      AD Russell  117.0    9.0    9.0     0.0    0.0      0.0      144.0   \n",
       "3        AJ Finch  268.0   28.0    8.0     2.0    1.0      0.0      328.0   \n",
       "4          AJ Tye    6.0    0.0    1.0     0.0    0.0      0.0        8.0   \n",
       "\n",
       "   wickets  lbw_or_bowled  three_wickets  four_wickets  five_wickets  \\\n",
       "0     22.0            9.0            2.0           0.0           0.0   \n",
       "1      0.0            0.0            0.0           0.0           0.0   \n",
       "2      5.0            1.0            0.0           0.0           0.0   \n",
       "3      0.0            0.0            0.0           0.0           0.0   \n",
       "4      1.0            0.0            0.0           0.0           0.0   \n",
       "\n",
       "   bowl_score  allrounder_score  \n",
       "0       630.0             4.410  \n",
       "1         0.0             0.000  \n",
       "2       133.0            19.152  \n",
       "3         0.0             0.000  \n",
       "4        25.0             0.200  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Find allrounder score\n",
    "merged_data_2020['allrounder_score']=(merged_data_2020['bat_score']*merged_data_2020['bowl_score'])/1000\n",
    "merged_data_2020.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "d26c6a1e",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:35:37.537529Z",
     "iopub.status.busy": "2021-08-20T15:35:37.536466Z",
     "iopub.status.idle": "2021-08-20T15:35:37.548040Z",
     "shell.execute_reply": "2021-08-20T15:35:37.547170Z",
     "shell.execute_reply.started": "2021-08-20T15:34:21.269118Z"
    },
    "papermill": {
     "duration": 0.043082,
     "end_time": "2021-08-20T15:35:37.548209",
     "exception": false,
     "start_time": "2021-08-20T15:35:37.505127",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "wicketkeeper_2020 = get_wicketkeepers(season_2020)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "3860ff76",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:35:37.608394Z",
     "iopub.status.busy": "2021-08-20T15:35:37.607592Z",
     "iopub.status.idle": "2021-08-20T15:35:37.622592Z",
     "shell.execute_reply": "2021-08-20T15:35:37.621751Z",
     "shell.execute_reply.started": "2021-08-20T15:34:23.424058Z"
    },
    "papermill": {
     "duration": 0.046159,
     "end_time": "2021-08-20T15:35:37.622770",
     "exception": false,
     "start_time": "2021-08-20T15:35:37.576611",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "# According to score in particular role we sort data and store players name into dictionary. This dictonary contains players name and players role.\n",
    "total_batsmen = 4\n",
    "total_bowlers = 3\n",
    "total_allrounders = 3\n",
    "total_wicketkeepers = 1\n",
    "playing_XI_2020 = {}\n",
    "\n",
    "playing_XI_2020['BAT'] = merged_data_2020.sort_values(by=\"bat_score\",ascending=False).head(total_batsmen)['player'].to_list()\n",
    "playing_XI_2020['WK'] = merged_data_2020.query('player in @wicketkeeper_2020').sort_values(by=\"bat_score\",ascending=False).head(total_wicketkeepers)['player'].to_list()\n",
    "playing_XI_2020['AR'] = merged_data_2020.sort_values(by=\"allrounder_score\",ascending=False).head(total_allrounders)['player'].to_list()\n",
    "playing_XI_2020['BWL'] = merged_data_2020.sort_values(by=\"bowl_score\",ascending=False).head(total_bowlers)['player'].to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "8a36ab3e",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-08-20T15:35:37.684458Z",
     "iopub.status.busy": "2021-08-20T15:35:37.683778Z",
     "iopub.status.idle": "2021-08-20T15:35:37.692694Z",
     "shell.execute_reply": "2021-08-20T15:35:37.692046Z",
     "shell.execute_reply.started": "2021-08-20T15:34:26.303745Z"
    },
    "papermill": {
     "duration": 0.040055,
     "end_time": "2021-08-20T15:35:37.692834",
     "exception": false,
     "start_time": "2021-08-20T15:35:37.652779",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Fantasy dream team for season 2020\n",
      "\n",
      "KL Rahul        BAT\n",
      "S Dhawan        BAT\n",
      "DA Warner       BAT\n",
      "Ishan Kishan    BAT\n",
      "Q de Kock       WK\n",
      "MP Stoinis      AR\n",
      "R Tewatia       AR\n",
      "SM Curran       AR\n",
      "K Rabada        BWL\n",
      "JJ Bumrah       BWL\n",
      "TA Boult        BWL\n"
     ]
    }
   ],
   "source": [
    "print('Fantasy dream team for season 2020\\n')\n",
    "for player_role,players in playing_XI_2020.items():\n",
    "    for player in players:\n",
    "        print(\"{:15} {}\".format(player,player_role))"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  },
  "papermill": {
   "default_parameters": {},
   "duration": 58.81016,
   "end_time": "2021-08-20T15:35:38.431710",
   "environment_variables": {},
   "exception": null,
   "input_path": "__notebook__.ipynb",
   "output_path": "__notebook__.ipynb",
   "parameters": {},
   "start_time": "2021-08-20T15:34:39.621550",
   "version": "2.3.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}