{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## Import Libraries" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "C:\\Users\\Jaikrishna\\anaconda3\\lib\\site-packages\\ipykernel_launcher.py:6: FutureWarning: Passing a negative integer is deprecated in version 1.0 and will not be supported in future version. Instead, use None to not limit the column width.\n", " \n" ] } ], "source": [ "import pandas as pd\n", "import numpy as np\n", "pd.set_option('display.max_rows', None)\n", "pd.set_option('display.max_columns', None) \n", "pd.set_option('display.expand_frame_repr', False)\n", "pd.set_option('max_colwidth', -1)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## IPL ball by ball data" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "df = pd.read_csv(\"ipl_ball_by_ball_data.csv\")" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
match_idseasonstart_datevenueinningsballbatting_teambowling_teamstrikernon_strikerbowlerruns_off_batextraswidesnoballsbyeslegbyespenaltywicket_typeplayer_dismissedother_wicket_typeother_player_dismissed
033598220082008-04-18M Chinnaswamy Stadium10.1Kolkata Knight RidersRoyal Challengers BangaloreSC GangulyBB McCullumP Kumar01NaNNaNNaN1.0NaNNaNNaNNaNNaN
\n", "
" ], "text/plain": [ " match_id season start_date venue innings ball batting_team bowling_team striker non_striker bowler runs_off_bat extras wides noballs byes legbyes penalty wicket_type player_dismissed other_wicket_type other_player_dismissed\n", "0 335982 2008 2008-04-18 M Chinnaswamy Stadium 1 0.1 Kolkata Knight Riders Royal Challengers Bangalore SC Ganguly BB McCullum P Kumar 0 1 NaN NaN NaN 1.0 NaN NaN NaN NaN NaN " ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.head(1)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Data where the striker is MS Dhoni" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [], "source": [ "msd_df=df[(df['striker']=='MS Dhoni')]" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
match_idseasonstart_datevenueinningsballbatting_teambowling_teamstrikernon_strikerbowlerruns_off_batextraswidesnoballsbyeslegbyespenaltywicket_typeplayer_dismissedother_wicket_typeother_player_dismissed
55633598320082008-04-19Punjab Cricket Association Stadium, Mohali17.1Chennai Super KingsKings XI PunjabMS DhoniMEK HusseyJR Hopes00NaNNaNNaNNaNNaNlbwMS DhoniNaNNaN
55733598320082008-04-19Punjab Cricket Association Stadium, Mohali16.6Chennai Super KingsKings XI PunjabMS DhoniMEK HusseyIK Pathan10NaNNaNNaNNaNNaNNaNNaNNaNNaN
\n", "
" ], "text/plain": [ " match_id season start_date venue innings ball batting_team bowling_team striker non_striker bowler runs_off_bat extras wides noballs byes legbyes penalty wicket_type player_dismissed other_wicket_type other_player_dismissed\n", "556 335983 2008 2008-04-19 Punjab Cricket Association Stadium, Mohali 1 7.1 Chennai Super Kings Kings XI Punjab MS Dhoni MEK Hussey JR Hopes 0 0 NaN NaN NaN NaN NaN lbw MS Dhoni NaN NaN \n", "557 335983 2008 2008-04-19 Punjab Cricket Association Stadium, Mohali 1 6.6 Chennai Super Kings Kings XI Punjab MS Dhoni MEK Hussey IK Pathan 1 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN " ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "msd_df.head(2)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## To check last three years" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "C:\\Users\\Jaikrishna\\anaconda3\\lib\\site-packages\\ipykernel_launcher.py:1: SettingWithCopyWarning: \n", "A value is trying to be set on a copy of a slice from a DataFrame.\n", "Try using .loc[row_indexer,col_indexer] = value instead\n", "\n", "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n", " \"\"\"Entry point for launching an IPython kernel.\n" ] } ], "source": [ "msd_df['year']=pd.to_datetime(msd_df['start_date']).dt.year" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [], "source": [ "msd_3yr=msd_df[((msd_df['year']==2021) | (msd_df['year']==2020) | (msd_df['year']==2019))]" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
match_idseasonstart_datevenueinningsballbatting_teambowling_teamstrikernon_strikerbowlerruns_off_batextraswidesnoballsbyeslegbyespenaltywicket_typeplayer_dismissedother_wicket_typeother_player_dismissedyear
165761117536020192019-03-26Arun Jaitley Stadium212.2Chennai Super KingsDelhi CapitalsMS DhoniKM JadhavAR Patel10NaNNaNNaNNaNNaNNaNNaNNaNNaN2019
165764117536020192019-03-26Arun Jaitley Stadium215.5Chennai Super KingsDelhi CapitalsMS DhoniKM JadhavK Rabada00NaNNaNNaNNaNNaNNaNNaNNaNNaN2019
\n", "
" ], "text/plain": [ " match_id season start_date venue innings ball batting_team bowling_team striker non_striker bowler runs_off_bat extras wides noballs byes legbyes penalty wicket_type player_dismissed other_wicket_type other_player_dismissed year\n", "165761 1175360 2019 2019-03-26 Arun Jaitley Stadium 2 12.2 Chennai Super Kings Delhi Capitals MS Dhoni KM Jadhav AR Patel 1 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN 2019\n", "165764 1175360 2019 2019-03-26 Arun Jaitley Stadium 2 15.5 Chennai Super Kings Delhi Capitals MS Dhoni KM Jadhav K Rabada 0 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN 2019" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "msd_3yr.head(2)" ] }, { "cell_type": "code", "execution_count": 10, "metadata": {}, "outputs": [], "source": [ "ms_last_over=msd_3yr[(msd_3yr['ball']>19)&(msd_3yr['wides'].isnull()==True)]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Strike Rate in Last Over (Last 3 years)" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "276.9230769230769" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "100*ms_last_over['runs_off_bat'].sum()/ms_last_over['ball'].count()" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [], "source": [ "MSD_final_ovr_sc= pd.DataFrame(ms_last_over.groupby('striker')['runs_off_bat'].sum()).reset_index()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Last over played" ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "10" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(ms_last_over['match_id'].unique())" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [], "source": [ "MSD_final_ovr_sc['Innings']=len(ms_last_over['match_id'].unique())" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Balls Played" ] }, { "cell_type": "code", "execution_count": 15, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "39" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ms_last_over['ball'].count()" ] }, { "cell_type": "code", "execution_count": 16, "metadata": {}, "outputs": [], "source": [ "MSD_final_ovr_sc['ball']=ms_last_over['ball'].count()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## 4s & 6s" ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "11" ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ms_last_over[(ms_last_over['runs_off_bat']==6)]['ball'].count()" ] }, { "cell_type": "code", "execution_count": 18, "metadata": {}, "outputs": [], "source": [ "MSD_final_ovr_sc['4s']=ms_last_over[(ms_last_over['runs_off_bat']==6)]['ball'].count()" ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "4" ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ms_last_over[(ms_last_over['runs_off_bat']==4)]['ball'].count()" ] }, { "cell_type": "code", "execution_count": 20, "metadata": {}, "outputs": [], "source": [ "MSD_final_ovr_sc['6s']=ms_last_over[(ms_last_over['runs_off_bat']==4)]['ball'].count()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Strike Rate" ] }, { "cell_type": "code", "execution_count": 21, "metadata": {}, "outputs": [], "source": [ "MSD_final_ovr_sc['SR']=100*ms_last_over['runs_off_bat'].sum()/ms_last_over['ball'].count()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Boundary Percentage" ] }, { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [], "source": [ "MSD_final_ovr_sc['Runs from Boundary %']=100*((MSD_final_ovr_sc['4s']*4+MSD_final_ovr_sc['6s']*6)/MSD_final_ovr_sc['runs_off_bat'])" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## MSD Last over scorecard" ] }, { "cell_type": "code", "execution_count": 23, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
strikerruns_off_batInningsball4s6sSRRuns from Boundary %
0MS Dhoni1081039114276.92307762.962963
\n", "
" ], "text/plain": [ " striker runs_off_bat Innings ball 4s 6s SR Runs from Boundary %\n", "0 MS Dhoni 108 10 39 11 4 276.923077 62.962963 " ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" } ], "source": [ "MSD_final_ovr_sc" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Strike Rate in death overs (Last 3 years)" ] }, { "cell_type": "code", "execution_count": 24, "metadata": {}, "outputs": [], "source": [ "ms_death_over=msd_3yr[(msd_3yr['ball']>16)&(msd_3yr['wides'].isnull()==True)]" ] }, { "cell_type": "code", "execution_count": 25, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "178.4688995215311" ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" } ], "source": [ "100*ms_death_over['runs_off_bat'].sum()/ms_death_over['ball'].count()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Dismissed in death overs" ] }, { "cell_type": "code", "execution_count": 26, "metadata": {}, "outputs": [], "source": [ "dismiss_death_ovr=ms_death_over[(ms_death_over['player_dismissed']=='MS Dhoni')]" ] }, { "cell_type": "code", "execution_count": 27, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "9" ] }, "execution_count": 27, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dismiss_death_ovr['ball'].count()" ] }, { "cell_type": "code", "execution_count": 28, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "wicket_type\n", "bowled 2\n", "caught 6\n", "run out 1\n", "Name: ball, dtype: int64" ] }, "execution_count": 28, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dismiss_death_ovr.groupby('wicket_type')['ball'].count()" ] }, { "cell_type": "code", "execution_count": 29, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "21" ] }, "execution_count": 29, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(ms_death_over['match_id'].unique())" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Death over score card" ] }, { "cell_type": "code", "execution_count": 30, "metadata": {}, "outputs": [], "source": [ "MSD_dth_ovr_sc= pd.DataFrame(ms_death_over.groupby('striker')['runs_off_bat'].sum()).reset_index()" ] }, { "cell_type": "code", "execution_count": 31, "metadata": {}, "outputs": [], "source": [ "MSD_dth_ovr_sc['ball']=ms_death_over['ball'].count()" ] }, { "cell_type": "code", "execution_count": 32, "metadata": {}, "outputs": [], "source": [ "MSD_dth_ovr_sc['innings']=ms_death_over['match_id'].nunique()" ] }, { "cell_type": "code", "execution_count": 33, "metadata": {}, "outputs": [], "source": [ "MSD_dth_ovr_sc['4s']=ms_death_over[(ms_death_over['runs_off_bat']==4)]['ball'].count()" ] }, { "cell_type": "code", "execution_count": 34, "metadata": {}, "outputs": [], "source": [ "MSD_dth_ovr_sc['6s']=ms_death_over[(ms_death_over['runs_off_bat']==6)]['ball'].count()" ] }, { "cell_type": "code", "execution_count": 35, "metadata": {}, "outputs": [], "source": [ "MSD_dth_ovr_sc['SR']=100*MSD_dth_ovr_sc['runs_off_bat']/MSD_dth_ovr_sc['ball']" ] }, { "cell_type": "code", "execution_count": 36, "metadata": {}, "outputs": [], "source": [ "MSD_dth_ovr_sc['Runs from Boundary %']=100*((MSD_dth_ovr_sc['4s']*4+MSD_dth_ovr_sc['6s']*6)/MSD_dth_ovr_sc['runs_off_bat'])" ] }, { "cell_type": "code", "execution_count": 37, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
strikerruns_off_batballinnings4s6sSRRuns from Boundary %
0MS Dhoni373209212922178.468966.487936
\n", "
" ], "text/plain": [ " striker runs_off_bat ball innings 4s 6s SR Runs from Boundary %\n", "0 MS Dhoni 373 209 21 29 22 178.4689 66.487936 " ] }, "execution_count": 37, "metadata": {}, "output_type": "execute_result" } ], "source": [ "MSD_dth_ovr_sc" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Last over stats (Last 3 years)" ] }, { "cell_type": "code", "execution_count": 38, "metadata": {}, "outputs": [], "source": [ "df['year']=pd.to_datetime(df['start_date']).dt.year" ] }, { "cell_type": "code", "execution_count": 39, "metadata": {}, "outputs": [], "source": [ "df_3yr=df[((df['year']==2021) | (df['year']==2020) | (df['year']==2019))]" ] }, { "cell_type": "code", "execution_count": 40, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
match_idseasonstart_datevenueinningsballbatting_teambowling_teamstrikernon_strikerbowlerruns_off_batextraswidesnoballsbyeslegbyespenaltywicket_typeplayer_dismissedother_wicket_typeother_player_dismissedyear
164745117535620192019-03-23MA Chidambaram Stadium26.7Chennai Super KingsRoyal Challengers BangaloreSK RainaAT RayuduNA Saini00NaNNaNNaNNaNNaNNaNNaNNaNNaN2019
164746117535620192019-03-23MA Chidambaram Stadium25.5Chennai Super KingsRoyal Challengers BangaloreSK RainaAT RayuduMM Ali10NaNNaNNaNNaNNaNNaNNaNNaNNaN2019
\n", "
" ], "text/plain": [ " match_id season start_date venue innings ball batting_team bowling_team striker non_striker bowler runs_off_bat extras wides noballs byes legbyes penalty wicket_type player_dismissed other_wicket_type other_player_dismissed year\n", "164745 1175356 2019 2019-03-23 MA Chidambaram Stadium 2 6.7 Chennai Super Kings Royal Challengers Bangalore SK Raina AT Rayudu NA Saini 0 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN 2019\n", "164746 1175356 2019 2019-03-23 MA Chidambaram Stadium 2 5.5 Chennai Super Kings Royal Challengers Bangalore SK Raina AT Rayudu MM Ali 1 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN 2019" ] }, "execution_count": 40, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_3yr.head(2)" ] }, { "cell_type": "code", "execution_count": 41, "metadata": {}, "outputs": [], "source": [ "df_last_over=df_3yr[(df_3yr['ball']>19)&(df_3yr['wides'].isnull()==True)]" ] }, { "cell_type": "code", "execution_count": 42, "metadata": {}, "outputs": [], "source": [ "last_over_runs = pd.DataFrame(df_last_over.groupby('striker')['runs_off_bat'].sum().sort_values(ascending=False)).reset_index()" ] }, { "cell_type": "code", "execution_count": 43, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
strikerruns_off_bat
0KA Pollard149
1RA Jadeja134
\n", "
" ], "text/plain": [ " striker runs_off_bat\n", "0 KA Pollard 149 \n", "1 RA Jadeja 134 " ] }, "execution_count": 43, "metadata": {}, "output_type": "execute_result" } ], "source": [ "last_over_runs.head(2)" ] }, { "cell_type": "code", "execution_count": 44, "metadata": {}, "outputs": [], "source": [ "last_over_balls = pd.DataFrame(df_last_over.groupby('striker')['ball'].count().sort_values(ascending=False)).reset_index()" ] }, { "cell_type": "code", "execution_count": 45, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
strikerball
0KA Pollard56
1RA Jadeja46
\n", "
" ], "text/plain": [ " striker ball\n", "0 KA Pollard 56 \n", "1 RA Jadeja 46 " ] }, "execution_count": 45, "metadata": {}, "output_type": "execute_result" } ], "source": [ "last_over_balls.head(2)" ] }, { "cell_type": "code", "execution_count": 46, "metadata": {}, "outputs": [], "source": [ "last_ovr_stats=last_over_runs.merge(last_over_balls,how='left',on='striker')" ] }, { "cell_type": "code", "execution_count": 47, "metadata": {}, "outputs": [], "source": [ "last_ovr_stats['SR']=100*(last_ovr_stats['runs_off_bat']/last_ovr_stats['ball'])" ] }, { "cell_type": "code", "execution_count": 48, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
strikerruns_off_batballSR
0KA Pollard14956266.071429
1RA Jadeja13446291.304348
\n", "
" ], "text/plain": [ " striker runs_off_bat ball SR\n", "0 KA Pollard 149 56 266.071429\n", "1 RA Jadeja 134 46 291.304348" ] }, "execution_count": 48, "metadata": {}, "output_type": "execute_result" } ], "source": [ "last_ovr_stats[last_ovr_stats['runs_off_bat']>30].head(2)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Sorting based on Strike Rate (Minimum 30 runs scored)" ] }, { "cell_type": "code", "execution_count": 49, "metadata": {}, "outputs": [], "source": [ "sort_SR=last_ovr_stats[(last_ovr_stats['runs_off_bat']>30)].sort_values('SR', ascending=False).reset_index()" ] }, { "cell_type": "code", "execution_count": 50, "metadata": {}, "outputs": [], "source": [ "sort_SR.drop('index',axis=1,inplace=True)" ] }, { "cell_type": "code", "execution_count": 51, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
strikerruns_off_batballSR
0HH Pandya12140302.500000
1RA Jadeja13446291.304348
2MP Stoinis9934291.176471
3MS Dhoni10839276.923077
4AB de Villiers9635274.285714
\n", "
" ], "text/plain": [ " striker runs_off_bat ball SR\n", "0 HH Pandya 121 40 302.500000\n", "1 RA Jadeja 134 46 291.304348\n", "2 MP Stoinis 99 34 291.176471\n", "3 MS Dhoni 108 39 276.923077\n", "4 AB de Villiers 96 35 274.285714" ] }, "execution_count": 51, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sort_SR.head(5)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Visualization" ] }, { "cell_type": "code", "execution_count": 52, "metadata": {}, "outputs": [], "source": [ "import matplotlib.pyplot as plt\n", "import seaborn as sns" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Dhoni is in 4th Place (No. of Runs scored in the last over of the innings)" ] }, { "cell_type": "code", "execution_count": 53, "metadata": {}, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAEGCAYAAACKB4k+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAbDElEQVR4nO3de5wcVZ338c+XEMQAIUAGDAk6iHlgERFhQFwUuchjQBdwFwTWR4LGzfoIyIqAogiIi8qisiKChstyESMulyUgCCFCsrKATrgl3LMsQgiQQe4qEOC3f5wzNZWhu6czM909SX/fr9e8pupUddWvz3TPr86pqlOKCMzMzABWa3UAZmY2cjgpmJlZwUnBzMwKTgpmZlZwUjAzs8LqrQ5gKMaPHx+dnZ2tDsPMbKUyf/78pyOio9KylTopdHZ20t3d3eowzMxWKpL+UG2Zu4/MzKzgpGBmZgUnBTMzKzgpmJlZwUnBzMwKTgpmZlZwUjAzs4KTgpmZFZwUzMyssFLf0VzLdkdf2OoQht38Uw9udQhmtopzS8HMzApOCmZmVnBSMDOzgpOCmZkVnBTMzKzgpGBmZgUnBTMzKzgpmJlZoWFJQdJ5kpZKWlhh2VGSQtL4PC9Jp0taJOluSds2Ki4zM6uukS2F84Ep/QslbQLsATxaKt4TmJx/pgNnNTAuMzOromFJISLmAc9UWHQacAwQpbJ9gAsjuRUYJ2lCo2IzM7PKmnpOQdLewOMRcVe/RROBx0rzi3NZpW1Ml9Qtqbunp6dBkZqZtaemJQVJY4CvA8dXWlyhLCqUEREzIqIrIro6OjqGM0Qzs7bXzFFSNwM2Be6SBDAJuF3SDqSWwSaldScBS5oYm5mZ0cSWQkQsiIgNI6IzIjpJiWDbiHgSmAUcnK9C2hF4PiKeaFZsZmaWNPKS1JnALcDmkhZLmlZj9WuAh4FFwNnAFxoVl5mZVdew7qOIOGiA5Z2l6QAObVQsZmZWH9/RbGZmBScFMzMrOCmYmVmhmZekWos8etJ7Wh3CsHv78QtaHYLZKsktBTMzKzgpmJlZwUnBzMwKTgpmZlZwUjAzs4KTgpmZFZwUzMys4KRgZmYFJwUzMys4KZiZWcFJwczMCk4KZmZWcFIwM7OCk4KZmRWcFMzMrNCwpCDpPElLJS0slZ0q6X5Jd0u6QtK40rJjJS2S9ICkjzYqLjMzq66RLYXzgSn9ymYDW0XE1sCDwLEAkrYEDgTenV9zpqRRDYzNzMwqaNiT1yJinqTOfmXXl2ZvBfbL0/sAv4iIV4D/kbQI2AG4pVHxWXva6Uc7tTqEYXfz4Te3OgRbhbTynMJngWvz9ETgsdKyxbnsTSRNl9Qtqbunp6fBIZqZtZeWJAVJXwdeAy7uLaqwWlR6bUTMiIiuiOjq6OhoVIhmZm2pYd1H1UiaCnwc2D0iev/xLwY2Ka02CVjS7NjMzNpdU1sKkqYAXwH2jog/lxbNAg6U9BZJmwKTgd81MzYzM2tgS0HSTGAXYLykxcAJpKuN3gLMlgRwa0R8PiLukfRL4F5St9KhEfF6o2IzM7PKGnn10UEVis+tsf7JwMmNisfMzAbmO5rNzKzgpGBmZgUnBTMzKzgpmJlZwUnBzMwKTgpmZlZwUjAzs4KTgpmZFZwUzMys4KRgZmYFJwUzMys0fehsMxsZ5u784VaHMOw+PG9uq0NY6bmlYGZmBScFMzMrOCmYmVnBScHMzApOCmZmVnBSMDOzgpOCmZkVGpYUJJ0naamkhaWy9SXNlvRQ/r1eLpek0yUtknS3pG0bFZeZmVXXyJbC+cCUfmVfBeZExGRgTp4H2BOYnH+mA2c1MC4zM6uiYUkhIuYBz/Qr3ge4IE9fAOxbKr8wkluBcZImNCo2MzOrrNnnFDaKiCcA8u8Nc/lE4LHSeotz2ZtImi6pW1J3T09PQ4M1M2s3I2XsI1Uoi0orRsQMYAZAV1dXxXXMzFbEGV++qtUhDLvDvv83g3pds1sKT/V2C+XfS3P5YmCT0nqTgCVNjs3MrO01OynMAqbm6anAlaXyg/NVSDsCz/d2M5mZWfMMmBTyP+r/J+n4PP92STvU8bqZwC3A5pIWS5oGfBfYQ9JDwB55HuAa4GFgEXA28IVBvRszMxuSes4pnAm8AewGnAS8CFwGbF/rRRFxUJVFu1dYN4BD64jFzMwaqJ6k8P6I2FbSHQAR8aykNRocl5mZtUA95xSWSRpFvhpIUgep5WBmZquYepLC6cAVwIaSTgZ+C3ynoVGZmVlLDNh9FBEXS5pPOhcgYN+IuK/hkZmZWdMNmBQkXRQRnwbur1BmZmarkHq6j95dnsnnF7ZrTDhmZtZKVZOCpGMlvQhsLekFSS/m+aX03XRmZmarkKpJISK+ExHrAKdGxNiIWCf/bBARxzYxRjMza5J6TjQfmx+GMxlYs1Q+r5GBmZlZ89VzovlzwBGkQeruBHYkDV+xW2NDMzOzZqvnRPMRpCEt/hARuwLvA/wgAzOzVVA9SeHliHgZQNJbIuJ+YPPGhmVmZq1Qz9hHiyWNA/4DmC3pWfysAzOzVVI9J5o/kSdPlHQjsC5wbUOjMjOzllihh+xExFxgHnBMY8IxM7NWqnXz2iaSZki6WtLnJI2R9H3gQWDD5oVoZmbNUqv76EJgLumBOlOAW4F7gK0j4skmxGZmZk1WKymsHxEn5unrJD0FbB8RrzQ+LDMza4Wa5xQkrSdpfUnrA08CY0rzgybpS5LukbRQ0kxJa0raVNJtkh6SdImf7mZm1ny1ksK6wPzSz1jg9jzdPdgdSpoIfBHoioitgFHAgcApwGkRMRl4Fpg22H2YmdngVO0+iojOBu/3rZKWAWOAJ0jDZvx9Xn4BcCJwVgNjMDOzflboktThEBGPA98DHiUlg+dJrY/nIuK1vNpiYGKzYzMza3dNTwp5xNV9gE2BjYG1gD0rrBpVXj9dUrek7p4eD8FkZjacmp4UgI8A/xMRPRGxDLgc+GtgnKTe7qxJVBlKIyJmRERXRHR1dHQ0J2IzszZRV1KQ9EFJn8nTHZI2HcI+HwV2zDfDCdgduBe4EdgvrzMVP93NzKzpBkwKkk4AvgL0Pm1tNPCzwe4wIm4DLiVdybQgxzAj7+NISYuADYBzB7sPMzMbnHpGSf0E6RkKtwNExBJJ6wxlpxFxAnBCv+KHgR2Gsl0zMxuaerqPXo2IIJ/4lbRWY0MyM7NWqScp/FLST0kngv8BuAE4p7FhmZlZK9TzPIXvSdoDeIH0xLXjI2J2wyMzM7OmGzApSNozIq4FZpfKPh8RP2loZGZm1nT1dB99Q9JuvTOSvkK6+czMzFYx9Vx9tDdwtaSjSc9V2CKXmZnZKqaecwpPS9qbdIJ5PrBfvhrJzMxWMVWTgqQXSZehKv9eA3gnsJ+kiIixzQnRzMyapdbQ2UO6Qc3MzFY+tVoKW0TE/ZK2rbQ8Im5vXFhmZtYKtc4pHAlMB75fYVmQHopjZmarkFrdR9MlrQYcFxE3NzEmMzNrkZr3KUTEG6SnpJmZWRuo5+a16yX9XX72gZmZrcLquXntSNIjM1+T9DL5ElVfkmpmtuqp5+Y1X5pqZtYm6nny2px6yszMbOVX6z6FNYExwHhJ65G6jQDGAhs3ITYzM2uyWt1H/wj8EykBzKcvKbwA/LjBcZmZWQvUuk/hh8APJR0eET8azp1KGkd6ettWpBvhPgs8AFwCdAKPAJ+MiGeHc79mZlZb1XMKkraX9LbehCDpYElXSjpd0vpD3O8PgV9HxBbAe4H7gK8CcyJiMjAnz5uZWRPVOtH8U+BVAEk7A98FLgSeB2YMdoeSxgI7A+cCRMSrEfEc6cE9F+TVLgD2Hew+zMxscGolhVER8UyePgCYERGXRcQ3gHcNYZ/vBHqAf5N0h6RzJK0FbBQRTwDk3xtWerGk6ZK6JXX39PQMIQwzM+uvZlKQ1HvOYXfgN6Vl9dz0Vs3qwLbAWRHxPuBPrEBXUUTMiIiuiOjq6OgYQhhmZtZfraQwE5gr6UrgL8B/Akh6F6kLabAWA4sj4rY8fykpSTwlaULexwRg6RD2YWZmg1A1KUTEycCXgfOBD5YewbkacPhgdxgRTwKPSdo8F+0O3AvMAqbmsqnAlYPdh5mZDU7NbqCIuLVC2YPDsN/DgYslrQE8DHyGlGx+KWka8Ciw/zDsx8zMVsBQzg0MWkTcCXRVWLR7s2MxM7M+9QydbWZmbcJJwczMCk4KZmZWcFIwM7OCk4KZmRWcFMzMrOCkYGZmBScFMzMrOCmYmVnBScHMzApOCmZmVnBSMDOzgpOCmZkVnBTMzKzgpGBmZgUnBTMzKzgpmJlZwUnBzMwKTgpmZlZoWVKQNErSHZKuzvObSrpN0kOSLpG0RqtiMzNrV61sKRwB3FeaPwU4LSImA88C01oSlZlZG2tJUpA0CfgYcE6eF7AbcGle5QJg31bEZmbWzlrVUvhX4BjgjTy/AfBcRLyW5xcDEyu9UNJ0Sd2Sunt6ehofqZlZG2l6UpD0cWBpRMwvF1dYNSq9PiJmRERXRHR1dHQ0JEYzs3a1egv2uROwt6S9gDWBsaSWwzhJq+fWwiRgSQtiMzNra01vKUTEsRExKSI6gQOB30TEp4Abgf3yalOBK5sdm5lZuxtJ9yl8BThS0iLSOYZzWxyPmVnbaUX3USEibgJuytMPAzu0Mh4zs3Y3kloKZmbWYk4KZmZWcFIwM7OCk4KZmRWcFMzMrOCkYGZmBScFMzMrOCmYmVnBScHMzApOCmZmVnBSMDOzgpOCmZkVnBTMzKzgpGBmZgUnBTMzKzgpmJlZwUnBzMwKTgpmZlZwUjAzs0LTk4KkTSTdKOk+SfdIOiKXry9ptqSH8u/1mh2bmVm7a0VL4TXgyxHxV8COwKGStgS+CsyJiMnAnDxvZmZN1PSkEBFPRMTtefpF4D5gIrAPcEFe7QJg32bHZmbW7lp6TkFSJ/A+4DZgo4h4AlLiADas8prpkroldff09DQrVDOzttCypCBpbeAy4J8i4oV6XxcRMyKiKyK6Ojo6GhegmVkbaklSkDSalBAujojLc/FTkibk5ROApa2IzcysnbXi6iMB5wL3RcQPSotmAVPz9FTgymbHZmbW7lZvwT53Aj4NLJB0Zy77GvBd4JeSpgGPAvu3IDYzs7bW9KQQEb8FVGXx7s2MxczMluc7ms3MrOCkYGZmBScFMzMrOCmYmVnBScHMzApOCmZmVnBSMDOzgpOCmZkVnBTMzKzgpGBmZgUnBTMzKzgpmJlZwUnBzMwKTgpmZlZwUjAzs4KTgpmZFZwUzMys4KRgZmYFJwUzMyuMuKQgaYqkByQtkvTVVsdjZtZORlRSkDQK+DGwJ7AlcJCkLVsblZlZ+xhRSQHYAVgUEQ9HxKvAL4B9WhyTmVnbUES0OoaCpP2AKRHxuTz/aeD9EXFYaZ3pwPQ8uznwQNMDfbPxwNOtDmKEcF30cV30cV30GQl18Y6I6Ki0YPVmRzIAVShbLmtFxAxgRnPCqY+k7ojoanUcI4Hroo/roo/ros9Ir4uR1n20GNikND8JWNKiWMzM2s5ISwq/ByZL2lTSGsCBwKwWx2Rm1jZGVPdRRLwm6TDgOmAUcF5E3NPisOoxorqzWsx10cd10cd10WdE18WIOtFsZmatNdK6j8zMrIWcFMzMrLDKJwVJL5Wm95L0kKS3l8rukjSzxutPlPS4pDslLZS09wD7O1HSUXn6/HzvxbDEP1wkvV56P1dJGtdv+ZckvSxp3Sqv75S0cAX3OWBdSDpJ0kdWZLsrqn99SjpE0hl5uvjblZY/Iml8he08ImlB/vxcL+ltwxRfxf01g6SQdFFpfnVJPZKuzvMbSbo6v+d7JV1TZTu9n6978rpHSlotLyvqexji/bykg4djW6VtDlQHh+T5O3Md/EOFbYyRdHH+fCyU9FtJa0saJ+kLdcSwsaRL61jvmv7f3eGwyieFXpJ2B35Eujnu0Vz2V6Q62FnSWjVeflpEbAPsD5zX+wFvQIzNOvH/l4jYJiK2Ap4BDu23/CDSlWCfaFI8AETE8RFxQzP3OUS7RsR7gW7ga60OZhj8CdhK0lvz/B7A46XlJwGzI+K9EbElUG1sst7P17vzNvYCThjuYCPiJxFx4TBvdqA6ALgk/z/YBfi2pI36LT8CeCoi3pO/Y9OAZcA4YMCkEBFLImLAg8mI2CsinhtovRXVFklB0oeAs4GPRcR/lxb9PXARcD1QswUAEBH3Aa8B4yW9Q9IcSXfn32+v9VpJx0v6fT5ymCFJufwmSd+WNBc4Il+Oe0te91uDfMsr4hZgYinOzYC1geNIyaGm3Gr4T0m355+/zuWSdEY+mvoVsGHpNdtJmitpvqTrJE3I5UVrolp9jVDzgHcBSDpLUnc+Sv5m7wq5BfDNXEcLJG2RyzfILY07JP2UfAOnpG9JOqL0+pMlfTEfcc4pbWe4h4G5FvhYnj4IKLeiJ5DuJQIgIu4eaGMRsZQ0AsFhpb/hxpJ+rdRq/5fedSUdVDq6PqVU/lJ+/3dJurX3n7AqtOyGSa066P/e/ht4R79FEyglkoh4ICJeAb4LbJZbGafm78ip+f0ukHQALN8Szy2Ty6vU1yOSxktaS9Kvcv0s7N3OoEXEKv1DytDPAFtXWPZg/oP+X2BWldefCByVp99PuplOwFXA1Fz+WeA/Kqx/PrBfnl6/tM2LgL/J0zcBZ5aWzQIOztOHAi81oE5eyr9HAf9Oaj31LjsO+AbpgOERYMMKr+8EFubpMcCaeXoy0J2n/xaYnfexMfAcsB8wGvgvoCOvdwDp0uO66msY3vvrwJ2ln0eBM0p/u8f7LX8VGF9hO4/0lgNnAKeU487v+6bez11e//A8/QXgnDx9OnB8nv4Y6Q7+8bmOb8/lq5H++WxAuox8bC4fDywiX0U4HJ8LYGvgUmDN/P53Aa7Oyz+a/443Al8HNq71+epX9iywEXAI8DCwbt7HH0g3rG6c/xYd+T3+Btg3vzbo+778C3Bc/+/acH43BqiDQ0qfl3cCS8uf1Vy+TS6/BfhnYHL/702e/zv6viMb5fc/geW/XxXrq/wZzNs5u7TddYdSB+3QUlhG+ic0rVwoaXugJyL+AMwBtpW0XpVtfEnSncD3gAMi1fwHgJ/n5RcBHxwgjl0l3SZpAbAb8O7SsktK0zvRd2RyEY3x1vx+/gisT/pg9joQ+EVEvAFcTuoyq2U0cHZ+X/9OGt0WYGdgZkS8HhFLSF9ySONVbQXMzjEcR7pzvb9a9TUUvV0b20TqAji+3/LT+i2vdUf9jfk9jAW+k8s+Kel24I4cc3mU38vz7/mkLz6kevoZQET8ivTPk4h4BPijpPeRDlruiIg/kg5Ivi3pbuAGUiuvf/fFoEU6+u8kHSFf02/ZdaR/hGcDWwB3SKo4fk4F5ZbenIh4PiJeBu4lHZhtD9wUET0R8RpwMaluICXmq/N0ue4aolYdZAfkv/tM4B8j4pl+r7+TVE+nkr5fv1fqqu7vg/R9R54C5pLqob9K9VW2APiIpFMkfSginq/3vVYyom5ea5A3gE8CN0j6WkR8O5cfBGwh6ZE8P5aUcc+psI3TIuJ7A+yn6g0fktYEzgS6IuIxSSeSsn6vP9W7rWHyl4jYRulE8tWkFsnpkrYmHe3Pzi39NUhHKT+usa0vAU8B7yUd0b5cWlbpfQi4JyI+UG2DddTXSLFrRBQDm0naFDgK2D4inpV0PsvH/Ur+/TrLf/eq/b3PIR0pvg04L5d9inQ0vV1ELMuf3+Gum1mkA6BdSK2TvkDTP8CfAz9XOvm6M3BZrY1JeifpPS/NRa+UFvfWRa3uwWX5QKy8fqNVrQPSOYXD3vSKkoh4iXQQcLmkN0jnVfrXU71dopXqq7yvByVtl/fxHUnXR8RJdW77TdqhpUBE/Bn4OPApSdOUThTvT2rad0ZEJ2mI7gH70Ev+i3RUDemL+tsa6/Z+aZ+WtDapG6Wam/ttt2HyEcUXgaMkjSa9/xN76yQiNgYmSup/ZFK2LvBEbll8mtQUhtTPfqCkUfmcwa65/AGgQ9IHACSNltS/FbAi9TWSjCUl+Odzv/eedbxmHvnvLGlPoNxavQKYQjp6vC6XrQsszQlhV9581DgczgNOiogF5UJJu0kak6fXATYjdXlUlVsSPyF1udQ62LkN+HDuIx9F+izOHcJ7GKqKdVAPSTv19jooDdezJanb50VgndKq80itjlG5nnYGfjeI/W0M/DkifkZKZNuu6DbK2qGlAKQjHElTSH+Ip4HHI6J8VcE8YEtJEyLiiTo2+UXSlUhHAz3AZ2rs+zlJZ5OaeY+Qruyp5gjSUdgRDHAENhwi4g5Jd5ES0YG8+R/ZFbn8lFLZ6vQdvZwJXCZpf1Jf859Kr9uN9J4fJH/BI+JVpZPJp+eWyurAvwK9w5nECtbXiBERd0m6g/ReHiYl+IF8E5iZu5zmUvonm+vqRuC5iHg9F18MXCWpm9Tfff9wvoe838XADyss2g44Q9JrpAPKcyKi0t+mt3tyNOnCjIuAHwywzyckHUv6DAm4JiKuHMLbGJIadVCPzYCz8on11YBfAZdFREi6OZ9EvhY4htQNfReptXhMRDwpqXMF9/ce4NTcIlkG/P9Bxg14mAsbhHzFy6ci4pPDvN2rgB9ExI3Dud2VVW7R3g7sHxEPtToeaw9t01Kw4SHpJFJX2yHDvN3zSFcy1eqGaxtKj6G9GrjCCcGayS0FMzMrtMWJZjMzq4+TgpmZFZwUzMys4KRgbU99o3repdL4TTXWr2u0S7OVkU80W9uT9FJErJ2nPwp8LSI+XGP9TtJYOFs1J0Kz5nFLwWx5Y8njD6n6iKT9R7ucIGme+p5R8aH8+pfyeDTzJd0gaQelUXEfVn4uh6qPMrtLXvdSSfcrjc8/kkeKtVWEWwrW9iS9Trp7ek3SKJW7RcR8pedbjImIF5QefHMraWyod1BqKUj6Mmmk2JPzEA1jIuJFSQHsFRHXSroCWIs0EuqWwAV5/KkxwBsR8bKkyaQB0rok7QJcSRpUbwnp7uijI8L3cVhD+eY1szxAIEAek+lCSVvRNyLpzqSBFauNSPp70pAno0lDqN+Zy18Ffp2nFwCv5DGLFtA30udo0tAR25AGO/s/pe3+Lg+3QB42ohPf3GcN5u4js5KIuIU0Rn0Hy49Iug1pNNg3jUgaEfNIg5k9DlykvkdElkf3fIM8XlQePLD3gKw8ymwXaWTaXjVHxzRrBCcFsxKlJ6KNIj1rotqIpMuNdplHkV0aEWcD57Jio1RWG2XWrCV85GHWN6onpC6jqRHxuqSKI5JGxB/7jXa5EDha0jLSk7tW5GHy1UaZNWsJn2g2M7OCu4/MzKzgpGBmZgUnBTMzKzgpmJlZwUnBzMwKTgpmZlZwUjAzs8L/As63bVhA6nagAAAAAElFTkSuQmCC\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "sns.barplot(data=last_ovr_stats.head(5),x='striker',y='runs_off_bat')\n", "plt.xlabel('Batsman')\n", "plt.ylabel('Strike Rate')\n", "plt.show()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Dhoni is in 4th Place (Strike Rate in the last over of the innings)" ] }, { "cell_type": "code", "execution_count": 54, "metadata": {}, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAEGCAYAAACKB4k+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAbaElEQVR4nO3de7xcVX338c+XEECuAXLAEIIHMRUBIcKBYrEI0SrQVwWegiZtuVhsbAsWL2DFUow8pUhReUSEGoQSEEEqUDCiEBBIQW65QRIuEjFATEzC/SK3hN/zx1qzz85kzpw5J2dmTnK+79frvGbP2pf57T17zm+vtfdeWxGBmZkZwAbtDsDMzAYPJwUzMys4KZiZWcFJwczMCk4KZmZW2LDdAayNkSNHRmdnZ7vDMDNbp8yaNeuZiOioNW6dTgqdnZ3MnDmz3WGYma1TJD3Z0zg3H5mZWcFJwczMCk4KZmZWcFIwM7OCk4KZmRWcFMzMrOCkYGZmhaYlBUmbSLpf0oOSFkj6ei7fWdJ9kh6X9GNJG+XyjfP7hXl8Z7NiMzOz2ppZU3gDGB8RewHjgEMk7Q+cA5wXEWOB54ET8vQnAM9HxHuA8/J0ZmbWQk27oznS03teyW+H578AxgN/lcunApOBi4DD8zDAT4ALJCn6+RSgfU69vF9xD2azzj223SGY2XquqecUJA2TNBdYDkwHfgO8EBEr8ySLgdF5eDTwNEAe/yKwbY1lTpI0U9LMFStWNDN8M7Mhp6lJISJWRcQ4YEdgP+B9tSbLr6ozrrzMKRHRFRFdHR01+3MyM7N+asnVRxHxAnAHsD8wQlKl2WpHYEkeXgyMAcjjtwKea0V8ZmaWNPPqow5JI/LwO4CPAo8AtwNH5cmOA27Iwzfm9+Txv+zv+QQzM+ufZnadPQqYKmkYKflcExHTJD0MXC3p34A5wCV5+kuAKyQtJNUQJjQxNjMzq6GZVx89BHygRvkTpPML1eWvA0c3Kx4zM+vdOv2QHWvMU2e+v90hDLidzpjXr/kO+O4BAxxJ+939ubvbHYKtR9zNhZmZFZwUzMys4KRgZmYFJwUzMys4KZiZWcFJwczMCk4KZmZWcFIwM7OCk4KZmRV8R7PZEHXngR9udwgD7sMz7mx3COs81xTMzKzgmoKZDXkXfOmn7Q5hwJ30rb/o13yuKZiZWcFJwczMCk4KZmZWcFIwM7OCk4KZmRWcFMzMrOCkYGZmBScFMzMrOCmYmVnBScHMzApOCmZmVnBSMDOzQtOSgqQxkm6X9IikBZJOzuWTJf1O0tz8d1hpntMkLZT0mKSPNys2MzOrrZm9pK4EvhQRsyVtAcySND2POy8ivlmeWNJuwARgd2AH4FZJfxQRq5oYo5mZlTStphARSyNidh5+GXgEGF1nlsOBqyPijYj4LbAQ2K9Z8ZmZ2Zpack5BUifwAeC+XHSSpIckXSpp61w2Gni6NNti6icRMzMbYE1PCpI2B64FPh8RLwEXAbsA44ClwLcqk9aYPWosb5KkmZJmrlixoklRm5kNTU1NCpKGkxLClRFxHUBELIuIVRHxNnAx3U1Ei4Expdl3BJZULzMipkREV0R0dXR0NDN8M7Mhp5lXHwm4BHgkIr5dKh9VmuxIYH4evhGYIGljSTsDY4H7mxWfmZmtqZlXHx0AHAPMkzQ3l30VmChpHKlpaBHwWYCIWCDpGuBh0pVLJ/rKIzOz1mpaUoiIu6h9nuCmOvOcBZzVrJjMzKw+39FsZmYFJwUzMys4KZiZWcFJwczMCk4KZmZWcFIwM7OCk4KZmRWcFMzMrOCkYGZmBScFMzMrOCmYmVnBScHMzApOCmZmVnBSMDOzgpOCmZkVnBTMzKzgpGBmZgUnBTMzKzgpmJlZwUnBzMwKTgpmZlZwUjAzs4KTgpmZFZwUzMys4KRgZmYFJwUzMys0LSlIGiPpdkmPSFog6eRcvo2k6ZIez69b53JJOl/SQkkPSdq7WbGZmVltzawprAS+FBHvA/YHTpS0G/AV4LaIGAvclt8DHAqMzX+TgIuaGJuZmdXQtKQQEUsjYnYefhl4BBgNHA5MzZNNBY7Iw4cDl0dyLzBC0qhmxWdmZmtqyTkFSZ3AB4D7gO0jYimkxAFslycbDTxdmm1xLqte1iRJMyXNXLFiRTPDNjMbcpqeFCRtDlwLfD4iXqo3aY2yWKMgYkpEdEVEV0dHx0CFaWZmNJAU8gngv5F0Rn6/k6T9Glm4pOGkhHBlRFyXi5dVmoXy6/JcvhgYU5p9R2BJY6thZmYDoZGawoXAB4GJ+f3LwPd6m0mSgEuARyLi26VRNwLH5eHjgBtK5cfmJLQ/8GKlmcnMzFpjwwam+eOI2FvSHICIeF7SRg3MdwBwDDBP0txc9lXgG8A1kk4AngKOzuNuAg4DFgJ/AD7d+GqYmdlAaCQpvCVpGLl9X1IH8HZvM0XEXdQ+TwDwkRrTB3BiA/GYmVmTNNJ8dD5wPbCdpLOAu4CzmxqVmZm1Ra81hYi4UtIs0tG9gCMi4pGmR2ZmZi3Xa1KQdEVEHAM8WqPMzMzWI400H+1efpPPL+zTnHDMzKydekwKkk6T9DKwp6SXJL2c3y+n+zJSMzNbj/SYFCLi7IjYAjg3IraMiC3y37YRcVoLYzQzsxZp5ETzabl767HAJqXyGc0MzMzMWq+RE82fAU4mdTsxl9QN9j3A+OaGZmZmrdbIieaTgX2BJyPiYFJvp+6e1MxsPdRIUng9Il4HkLRxRDwKvLe5YZmZWTs00s3FYkkjgP8Bpkt6Hvdeama2XmrkRPOReXCypNuBrYCfNzUqMzNriz49ZCci7gRmAF9uTjhmZtZO9W5eGyNpiqRpkj4jaVNJ3wJ+TfcjNM3MbD1Sr/nocuBO0pPTDgHuBRYAe0bE71sQm5mZtVi9pLBNREzOwzdLWgbsGxFvND8sMzNrh7onmvOdzJUH5fwe2FTSZgAR8VyTYzMzsxarlxS2Amax+tPTZufXAN7drKDMzKw9ekwKEdHZwjjMzGwQ6NMlqWZmtn5zUjAzs4KTgpmZFRpKCpI+JOnTebhD0s7NDcvMzNqh16Qg6WvAPwOVp60NB37YzKDMzKw9GqkpHAl8AngVICKWAFs0MygzM2uPRpLCmxERpHsTqNy81htJl0paLml+qWyypN9Jmpv/DiuNO03SQkmPSfp4X1fEzMzWXiNJ4RpJ3wdGSPo74FbgBw3Mdxmpz6Rq50XEuPx3E4Ck3YAJwO55ngslDWtkBczMbOA08jyFb0r6M+Al0hPXzoiI6Q3MN0NSZ4NxHA5cnftV+q2khcB+pGdBm5lZizRyovnQiJgeEadGxCkRMV3S36/FZ54k6aHcvLR1LhsNPF2aZnEuqxXPJEkzJc1cscKPijYzG0iNNB/9q6TxlTeS/pl0ZN8fFwG7AOOApcC3KoutMW3UWkBETImIrojo6ujo6GcYZmZWSyPPaP4EME3SqaT2/l1zWZ9FxLLKsKSLgWn57WJgTGnSHfFzoM3MWq7XmkJEPENKAt8DdgCOioi3+vNhkkaV3h4JVK5MuhGYIGnjfGPcWOD+/nyGmZn1X481BUkvk5pwlF83InWXfZSkiIgt6y1Y0lXAQcBISYuBrwEHSRqXl7cI+CxARCyQdA3wMLASODEiVq3dqpmZWV/V6zp7rW5Qi4iJNYovqTP9WcBZa/OZZma2durVFHaNiEcl7V1rfETMrlVuZmbrrnonmr8ITKL7CqGyAMbXKDczs3VYveajSZI2AE6PiLtbGJOZmbVJ3auPIuJt4JstisXMzNqskZvXbpH0l5Jq3WBmZmbrkUZuXvsisBmwUtLr5EtUe7sk1czM1j2NdIjnZyeYmQ0RjXSId1sjZWZmtu6rd5/CJsCmpDuSt6a707otSd1dmJnZeqZe89Fngc+TEsAsupPCS6R+kMzMbD1T7z6F7wDfkfS5iPhuC2MyM7M26fGcgqR9Jb2zkhAkHSvpBknnS9qmdSGamVmr1DvR/H3gTQBJBwLfAC4HXgSmND80MzNrtXrnFIZFxHN5+FPAlIi4FrhW0tzmh2ZmZq1Wr6YwTFIlaXwE+GVpXCM3vZmZ2Tqm3j/3q4A7JT0DvAb8L4Ck95CakMzMbD1T7+qjs/JNaqOAWyIi8qgNgM+1IjgzM2utus1AEXFvjbJfNy8cMzNrp0Z6STUzsyHCScHMzApOCmZmVnBSMDOzgpOCmZkVnBTMzKzgpGBmZoWmJQVJl0paLml+qWwbSdMlPZ5ft87lyr2vLpT0kKS9mxWXmZn1rJk1hcuAQ6rKvgLcFhFjgdvye4BDgbH5bxJwURPjMjOzHjQtKUTEDOC5quLDgal5eCpwRKn88kjuBUZIGtWs2MzMrLZWn1PYPiKWAuTX7XL5aODp0nSLc9kaJE2SNFPSzBUrVjQ1WDOzoWawnGhWjbKoUUZETImIrojo6ujoaHJYZmZDS6uTwrJKs1B+XZ7LFwNjStPtCCxpcWxmZkNeq5PCjcBxefg44IZS+bH5KqT9gRcrzUxmZtY6TXuCmqSrgIOAkZIWA18jPef5GkknAE8BR+fJbwIOAxYCfwA+3ay4zMysZ01LChExsYdRH6kxbQAnNisWMzNrzGA50WxmZoOAk4KZmRWcFMzMrOCkYGZmBScFMzMrOCmYmVnBScHMzApOCmZmVnBSMDOzgpOCmZkVnBTMzKzgpGBmZgUnBTMzKzgpmJlZwUnBzMwKTgpmZlZwUjAzs4KTgpmZFZwUzMys4KRgZmYFJwUzMys4KZiZWcFJwczMCk4KZmZWcFIwM7PChu34UEmLgJeBVcDKiOiStA3wY6ATWAR8MiKeb0d8ZmZDVTtrCgdHxLiI6MrvvwLcFhFjgdvyezMza6HB1Hx0ODA1D08FjmhjLGZmQ1K7kkIAt0iaJWlSLts+IpYC5Nft2hSbmdmQ1ZZzCsABEbFE0nbAdEmPNjpjTiKTAHbaaadmxWdmNiS1paYQEUvy63LgemA/YJmkUQD5dXkP806JiK6I6Oro6GhVyGZmQ0LLk4KkzSRtURkGPgbMB24EjsuTHQfc0OrYzMyGunY0H20PXC+p8vk/iohfSHoAuEbSCcBTwNFtiM3MbEhreVKIiCeAvWqUPwt8pNXxmJlZt8F0SaqZmbWZk4KZmRWcFMzMrOCkYGZmBScFMzMrOCmYmVnBScHMzApOCmZmVnBSMDOzgpOCmZkVnBTMzKzgpGBmZgUnBTMzKzgpmJlZwUnBzMwKTgpmZlZwUjAzs4KTgpmZFZwUzMys4KRgZmYFJwUzMys4KZiZWcFJwczMCk4KZmZWcFIwM7OCk4KZmRUGXVKQdIikxyQtlPSVdsdjZjaUDKqkIGkY8D3gUGA3YKKk3doblZnZ0DGokgKwH7AwIp6IiDeBq4HD2xyTmdmQoYhodwwFSUcBh0TEZ/L7Y4A/joiTStNMAiblt+8FHmt5oGsaCTzT7iAGCW+Lbt4W3bwtug2GbfGuiOioNWLDVkfSC9UoWy1rRcQUYEprwmmMpJkR0dXuOAYDb4tu3hbdvC26DfZtMdiajxYDY0rvdwSWtCkWM7MhZ7AlhQeAsZJ2lrQRMAG4sc0xmZkNGYOq+SgiVko6CbgZGAZcGhEL2hxWIwZVc1abeVt087bo5m3RbVBvi0F1otnMzNprsDUfmZlZGzkpmJlZYb1NCpJeqXp/vKQL8vBkSadUjV8kaWSN5SySNE/Sg5JukfTOAYqv5ue1gqRVkuZKmi/pp5JGVI3/gqTXJW3Vw/ydkub38TMvy/eh1JvmTEkf7cty+0tSSLqi9H5DSSskTcvvj8/v50p6WNLf1VjGppKuzPvHfEl3Sdpc0ghJ/9hADDtI+kkD091U/R01QwPbZHtJ0/Jv4WFJN/WwnMr+tSBP+0VJG+Rxxe9wAOL9e0nH9mO+I/O67loq65T0Wo77QUm/kvTeBpbV635dmvYgSfdUlW0oaZmkUeX9X9IdkrrycPG/QtKv+rKu/bHeJoUBdnBE7AXMBL7a7mAGwGsRMS4i9gCeA06sGj+RdCXYka0MKiLOiIhbW/RxrwJ7SHpHfv9nwO+qpvlxRIwDDgL+XdL2VeNPBpZFxPvztjwBeAsYAfSaFCJiSUT0+g8lIg6LiBd6m24A9LZNzgSmR8ReEbEb0FPfZJX9a/e8jMOArw10sBHxnxFxeT9mnQjcRbq6sew3Oe69gKkM/G99BrCjpM5S2UeB+RGxtJH9PyL+pNEPU9Ln//FOCn0zA3gPgKSLJM3MR0Nfr0yQs/rXJc3OR5C75vJtc01jjqTvk2/Uk/R/JZ1cmv8sSf+UjzhvKy2nWd193AOMLn3+LsDmwOmkH09d+Qjrf3OcsyX9SS6XpAvyEeXPgO1K8+wj6U5JsyTdLGlULi+OuiSdIemBfAQ+RVKtGxvX1s+BP8/DE4Grak0UEcuB3wDvqho1itI/zYh4LCLeAL4B7JKPOs/N2+LcvC7zJH0KVq9x5SPo6yT9QtLjkv6jstzKkaKkzST9LB/Jzq8sZ4DV2yajSPcSVdb3od4WlrfdJOCk0ne4Qw/rOVHdta5zSuWv5N/Fg5LurSRn1ajx90bS5sABpARenRTKtgSerzF/n/fr0rZ4G/hvoPy9TSBv40ZqHSq1gEg6Nf9GHqr8D8r71COSLgRmA2Pyciv73hfqLb8S6Hr5B6wC5pb+ngIuyOMmk37M5fFvAiNrLGdRpRy4ADgnD2+TX4cBdwB7lqb/XB7+R+AHefh84Iw8/OekO7VHAp3A7Fy+Aemfz7aky4W3zOUjgYXkq8UGYNu8Uor9v0ldi1TGnQ78a45lEbBdjfk7SUc3AJsCm+ThscDMPPx/gOn5M3YAXgCOAoYDvwI68nSfIl16DHAZcFR5++bhK4C/GOD94xVgT+AnwCZ5HzgImJbHH1/aX94NLC/HlMvH5fJ7gH8DxlZvn/z+L0vbYnvSvjiqajseDzwBbJXjeRIYU94H83IuLi13qxZvk4/n7/F24F+AHertX1Vlz+d1r7meeR95Cugg7fu/BI7I80bl+wf+Azi99Ds+pY/r+DfAJXn4V8Depe/stbzOvwGWAjvVmL/P+3XV/PsCc/Lwxnn/2brG/n8H0FX+/qt+ux8jXdoq0m91GnBgXo+3gf3zdPuQaneVzx/R2zZan2sKlSrsuEhNAGdUjT+vany9O6dvlzSXdPRwdi77pKTZwBxgd1KvrhXX5ddZpC8J0hf2Q4CI+Bn5KCQiFgHPSvoA6YueExHPkr7sf5f0EHAr6Wi+uvmiv96R1+dZYBvSTl4xAbg60lHNdcDRvSxrOHCxpHmkBFPZDgcCV0XEqohYQvqRQ+qvag9geo7hdNKd69UOlnRfXu540jYeUJGOdDtJR8S12sc/lWO8CvhsRDxXNf9cUsI4l7QdH5D0vhrL+RDd22IZcCfpn0O12yLixYh4HXiYNWsm84CPSjpH0p9GxIuNrmuj6m2TiLiZtL4XA7sCcyTV7D+nhnJNr9Z67gvcERErImIlcCVpH4J0wDYtD5d/U/0xkdTRJvm1XBuuNB/tAnye2vcTrNV+HREPAJsrna84FLg3ItaokTTgY/lvDqlGsCvpoAzgyYi4Nw8/Abxb0nclHQK81NuCB9XNa4PYwRFRdGAlaWfgFGDfiHhe0mWko56KN/LrKlbfxj3dFPID0hHUO4FLc9lfk46a9omItyQtqvqMtfFaRIxTOpE8jXRO4XxJe5J2rOm5pr8Raaf6Xp1lfQFYBuxFOmJ5vTSu1voKWBARH+xpgZI2AS4kHSk9LWkyA7fu1W4Evkk6It62atyPo9QZYy0R8QopeV4n6W1S+/m1VZM12vT1Rmm4et8hIn4taZ/8GWdLuiUizmxw2X3R4zbJifFHwI+UTkAfyJrruxpJ7yatz/JcVGs9622jtyIf5lJjuzRK0rakA4w9JAXpaD8kfbnG5DcC/9XDovq1X5dcTTr4eh89NFk2QMDZEfH91QrT+YpXi0DT/6e9SLW8E4FPAn9bb8Hrc02hmbYkbfgXc/vmoQ3MM4P0jx5JhwJbl8ZdDxxCOlq6OZdtBSzPCeFg1jxqXGv5SPOfgFMkDScdNU2OiM78twMwWlK9z94KWJprFseQfmiQ1neCpGG5bfXgXP4Y0CHpgwCShkuqrgVUEsAzuQ24oas7+ulS4MyImNfXGSUdIGnrPLwRqZb0JPAysEVp0hmkWsewfGR9IHB/Pz5vB+APEfFD0j/tvfu6jAbV3CaSxkvaNA9vAexCavLpUV7f/yQ1xdW7U/Y+4MP53Mkw0r5451qsQy1HAZdHxLvy/j0G+C2pJlftQ6RmpGprs19XXEVqxhpP/7vxuRn42/z7QNJoSdtVT6R01dIGEXEtqVm4133GNYV+iIgHJc0BFpCOpO9uYLavA1flJqc7Kf2YIuJNSbcDL0TEqlx8JfBTSTNJ7ZyPDuQ6lD57jqQHSUcuE1gzwV2fy88plW1I99HehcC1ko4mtTW/WppvPKnJ49fkH3he16NINZOt8rL+H2lb5kniBUkX53kXka6EaoqIWAx8p5+z7wJclE+gbgD8DLg2IkLS3UonkX8OfBn4IPAg6SjzyxHxe61+FUoj3g+cm2skbwH/0M+466qzTfYBLpC0krS+P8jNIdUqzZPDgZWkc0Lf7uUzl0o6jbQPCbgpIm5Yi9WoZSLpIoCya4G/Iu3fu+S4RWqy+kyNZfR3vy5ExMOS/gDMiohXq8c3IiJuyU2V9+Ra/SukRLOqatLRwH+p+yqk03pbtru5GATyFzYbODoiHm93PL1RuhLqryPikwO83J8C346I2wdyuWbWONcU2kzpcaPTgOvXkYRwJulpeMcP8HIvJV3JdNdALtfM+sY1BTMzK/hEs5mZFZwUzMys4KRgZmYFJwUb8tTdq+eDKvXfVGf6hnpBNVsX+USzDXmSXomIyk1AHwe+GhEfrjN9J6k/oD1aE6FZ67imYLa6ondM9dxTbXUvqKMkzVD3Myr+NM//Su6naJakWyXtp9RP/hOSPpGn6amX2YPytD+R9KjScxua0VOs2WpcU7AhT9Iq0h2qm5B6Lx0fEbMkbQhsGhEv5e4C7iX1DfUuSjUFSV8i9RR7Vu6iYdOIeDn3r3NYRPxc0vXAZqQecncDpub+pzYF3o6I1yWNJXW21iXpIOAGUkeAS0h3zZ8aEb6Pw5rKN6+Z5Q4CAXLfNZdL2oPunmoPJHVH3FNPtQ8Al+b+o/4n954KqauEX+ThecAbuS+reXT39Dmc1HXEOFIXBX9UWu79ucsJcvcLnfjmPmsyNx+ZlUTEPaRnF3Swek+140i9wa7RW2tEzCB1cvc74Ap1PyKy3Lvn2+T+onLngZUDsnIvs12knmkr6vaaatYMTgpmJUpPyhtGetZETz3VrtYLau5FdnlEXAxcQt96L+2pl1mztvCRh1l3r56QmoyOi4hVkmr2VBsRz1b1gjofOFXSW6TeKvvyMPmeepk1awufaDYzs4Kbj8zMrOCkYGZmBScFMzMrOCmYmVnBScHMzApOCmZmVnBSMDOzwv8HtNuUMmnDo+EAAAAASUVORK5CYII=\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "sns.barplot(data=sort_SR.head(5),x='striker',y='SR')\n", "plt.xlabel('Batsman')\n", "plt.ylabel('Strike Rate')\n", "plt.show()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## MSD Overall Data (from 2019 to 2021)" ] }, { "cell_type": "code", "execution_count": 55, "metadata": {}, "outputs": [], "source": [ "msd_ovrll=msd_3yr[(msd_3yr['wides'].isnull()==True)]" ] }, { "cell_type": "code", "execution_count": 56, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "653" ] }, "execution_count": 56, "metadata": {}, "output_type": "execute_result" } ], "source": [ "msd_ovrll['runs_off_bat'].sum()" ] }, { "cell_type": "code", "execution_count": 67, "metadata": {}, "outputs": [], "source": [ "msd_ovrll_sc = pd.DataFrame(msd_ovrll.groupby('striker')['runs_off_bat'].sum().sort_values(ascending=False)).reset_index()" ] }, { "cell_type": "code", "execution_count": 68, "metadata": {}, "outputs": [], "source": [ "msd_ovrll_sc['Innings']=msd_ovrll['match_id'].nunique()" ] }, { "cell_type": "code", "execution_count": 69, "metadata": {}, "outputs": [], "source": [ "msd_ovrll_sc['ball']=msd_ovrll['ball'].count()" ] }, { "cell_type": "code", "execution_count": 70, "metadata": {}, "outputs": [], "source": [ "msd_ovrll_sc['6s']=msd_ovrll[(msd_ovrll['runs_off_bat']==6)]['ball'].count()" ] }, { "cell_type": "code", "execution_count": 71, "metadata": {}, "outputs": [], "source": [ "msd_ovrll_sc['4s']=msd_ovrll[(msd_ovrll['runs_off_bat']==4)]['ball'].count()" ] }, { "cell_type": "code", "execution_count": 64, "metadata": {}, "outputs": [], "source": [ "msd_ovrll_sc = pd.DataFrame(msd_ovrll.groupby('striker')['runs_off_bat'].sum().sort_values(ascending=False)).reset_index()" ] }, { "cell_type": "code", "execution_count": 72, "metadata": {}, "outputs": [], "source": [ "msd_ovrll_sc['SR']=100*msd_ovrll_sc['runs_off_bat']/msd_ovrll_sc['ball']" ] }, { "cell_type": "code", "execution_count": 73, "metadata": {}, "outputs": [], "source": [ "msd_ovrll_sc['Runs from Boundary %']=((msd_ovrll_sc['4s']*4+msd_ovrll_sc['6s']*6)/msd_ovrll_sc['runs_off_bat'])*100" ] }, { "cell_type": "code", "execution_count": 74, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
strikerruns_off_batInningsball6s4sSRRuns from Boundary %
0MS Dhoni653285113142127.7886554.211332
\n", "
" ], "text/plain": [ " striker runs_off_bat Innings ball 6s 4s SR Runs from Boundary %\n", "0 MS Dhoni 653 28 511 31 42 127.78865 54.211332 " ] }, "execution_count": 74, "metadata": {}, "output_type": "execute_result" } ], "source": [ "msd_ovrll_sc" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## MSD year wise Data" ] }, { "cell_type": "code", "execution_count": 75, "metadata": {}, "outputs": [], "source": [ "msd_year_wise=msd_3yr[(msd_3yr['wides'].isnull()==True)]" ] }, { "cell_type": "code", "execution_count": 76, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc=pd.DataFrame(msd_year_wise.groupby('year')['runs_off_bat'].sum()).reset_index()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Balls Played" ] }, { "cell_type": "code", "execution_count": 77, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc['balls']=0" ] }, { "cell_type": "code", "execution_count": 78, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc.at[0, 'balls'] = msd_year_wise[(msd_year_wise['year']==2019)]['runs_off_bat'].count()" ] }, { "cell_type": "code", "execution_count": 79, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc.at[1, 'balls'] = msd_year_wise[(msd_year_wise['year']==2020)]['runs_off_bat'].count()" ] }, { "cell_type": "code", "execution_count": 80, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc.at[2, 'balls'] = msd_year_wise[(msd_year_wise['year']==2021)]['runs_off_bat'].count()" ] }, { "cell_type": "code", "execution_count": 81, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc['SR']=100*msd_yr_ws_sc['runs_off_bat']/msd_yr_ws_sc['balls']" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## 4s" ] }, { "cell_type": "code", "execution_count": 82, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc['4s']=0" ] }, { "cell_type": "code", "execution_count": 83, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc.at[0, '4s'] = msd_year_wise[(msd_year_wise['runs_off_bat']==4)&(msd_year_wise['year']==2019)]['runs_off_bat'].count()" ] }, { "cell_type": "code", "execution_count": 84, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc.at[1, '4s'] = msd_year_wise[(msd_year_wise['runs_off_bat']==4)&(msd_year_wise['year']==2020)]['runs_off_bat'].count()" ] }, { "cell_type": "code", "execution_count": 85, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc.at[2, '4s'] = msd_year_wise[(msd_year_wise['runs_off_bat']==4)&(msd_year_wise['year']==2021)]['runs_off_bat'].count()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## 6s" ] }, { "cell_type": "code", "execution_count": 86, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc['6s']=0" ] }, { "cell_type": "code", "execution_count": 87, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc.at[0, '6s'] = msd_year_wise[(msd_year_wise['runs_off_bat']==6)&(msd_year_wise['year']==2019)]['runs_off_bat'].count()" ] }, { "cell_type": "code", "execution_count": 88, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc.at[1, '6s'] = msd_year_wise[(msd_year_wise['runs_off_bat']==6)&(msd_year_wise['year']==2020)]['runs_off_bat'].count()" ] }, { "cell_type": "code", "execution_count": 89, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc.at[2, '6s'] = msd_year_wise[(msd_year_wise['runs_off_bat']==6)&(msd_year_wise['year']==2021)]['runs_off_bat'].count()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Dismissed" ] }, { "cell_type": "code", "execution_count": 90, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc['Out']=0" ] }, { "cell_type": "code", "execution_count": 91, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc.at[0, 'Out'] = msd_year_wise[(msd_year_wise['player_dismissed']=='MS Dhoni')&(msd_year_wise['year']==2019)]['runs_off_bat'].count()" ] }, { "cell_type": "code", "execution_count": 92, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc.at[1, 'Out'] = msd_year_wise[(msd_year_wise['player_dismissed']=='MS Dhoni')&(msd_year_wise['year']==2020)]['runs_off_bat'].count()" ] }, { "cell_type": "code", "execution_count": 93, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc.at[2, 'Out'] = msd_year_wise[(msd_year_wise['player_dismissed']=='MS Dhoni')&(msd_year_wise['year']==2021)]['runs_off_bat'].count()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Innings" ] }, { "cell_type": "code", "execution_count": 94, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc['innings']=0" ] }, { "cell_type": "code", "execution_count": 95, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc.at[0, 'innings'] = msd_year_wise[(msd_year_wise['year']==2019)]['match_id'].nunique()" ] }, { "cell_type": "code", "execution_count": 96, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc.at[1, 'innings'] = msd_year_wise[(msd_year_wise['year']==2020)]['match_id'].nunique()" ] }, { "cell_type": "code", "execution_count": 97, "metadata": {}, "outputs": [], "source": [ "msd_yr_ws_sc.at[2, 'innings'] = msd_year_wise[(msd_year_wise['year']==2021)]['match_id'].nunique()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Year Wise Data" ] }, { "cell_type": "code", "execution_count": 98, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
yearruns_off_batballsSR4s6sOutinnings
02019416309134.6278322223412
12020200172116.279070167812
220213730123.3333334134
\n", "
" ], "text/plain": [ " year runs_off_bat balls SR 4s 6s Out innings\n", "0 2019 416 309 134.627832 22 23 4 12 \n", "1 2020 200 172 116.279070 16 7 8 12 \n", "2 2021 37 30 123.333333 4 1 3 4 " ] }, "execution_count": 98, "metadata": {}, "output_type": "execute_result" } ], "source": [ "msd_yr_ws_sc" ] }, { "cell_type": "code", "execution_count": 99, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 99, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYYAAAEGCAYAAABhMDI9AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAVxklEQVR4nO3df7DddX3n8edLQPE3vy6YJqGxbbqK3Rrxirh0WAVrgW4NdnWrUzWr7KSdwopra4XObNW6jLWt0trdYRoNGhwFGcSSYWwtIqw/QS8KAUwtUUEikdwqIgwjNvjeP87nLuebXJJ7knvOucl9PmbOnO/38/18v3mf+WbyyvfX55uqQpKkGY8bdwGSpIXFYJAkdRgMkqQOg0GS1GEwSJI6Dh53AfvqqKOOqhUrVoy7DEnar9x0003/WlUTsy3b74NhxYoVTE1NjbsMSdqvJLnrsZZ5KkmS1GEwSJI6DAZJUofBIEnqMBgkSR0GgySpw2CQJHUYDJKkDoNBktSx3z/5PIjnv/WScZewKNz0l68fdwmS9oFHDJKkDoNBktRhMEiSOgwGSVLHSIIhyUFJvp7k6jb/zCQ3JrkjyceTPL61P6HNb2nLV4yiPknSo0Z1xHAusLlv/j3AhVW1ErgPOKu1nwXcV1W/BFzY+kmSRmjowZBkGfCbwAfbfIBTgCtalw3AmW16dZunLT+19Zckjcgojhj+Gvhj4Gdt/kjgR1W1o81vBZa26aXA3QBt+f2tf0eStUmmkkxNT08Ps3ZJWnSGGgxJ/hOwvapu6m+epWvNYdmjDVXrqmqyqiYnJmZ9ZakkaS8N+8nnk4CXJzkDOBR4Gr0jiMOSHNyOCpYB97T+W4HlwNYkBwNPB3445BolSX2GesRQVedX1bKqWgG8GvhsVf0ucB3wytZtDXBVm97Y5mnLP1tVuxwxSJKGZ1zPMbwNeEuSLfSuIaxv7euBI1v7W4DzxlSfJC1aIxtEr6quB65v098GTpilz0+AV42qJknSrnzyWZLUYTBIkjoMBklSh8EgSeowGCRJHQaDJKnDYJAkdRgMkqQOg0GS1GEwSJI6DAZJUofBIEnqMBgkSR0GgySpw2CQJHUM+53Phyb5SpJbktye5J2t/cNJvpPk5vZZ1dqT5P1JtiTZlOT4YdYnSdrVsF/U8zBwSlU9mOQQ4AtJ/qEte2tVXbFT/9OBle3zQuCi9i1JGpFhv/O5qurBNntI++zuHc6rgUvaejcAhyVZMswaJUldQ7/GkOSgJDcD24FrqurGtuiCdrrowiRPaG1Lgbv7Vt/a2iRJIzL0YKiqR6pqFbAMOCHJrwDnA88CXgAcAbytdc9sm9i5IcnaJFNJpqanp4dUuSQtTiO7K6mqfgRcD5xWVdva6aKHgQ8BJ7RuW4HlfastA+6ZZVvrqmqyqiYnJiaGXLkkLS7DvitpIslhbfqJwEuBf565bpAkwJnAbW2VjcDr291JJwL3V9W2YdYoSeoa9l1JS4ANSQ6iF0KXV9XVST6bZILeqaObgd9v/T8FnAFsAR4C3jDk+iRJOxlqMFTVJuB5s7Sf8hj9Czh7mDVJknbPJ58lSR0GgySpw2CQJHUYDJKkDoNBktRhMEiSOgwGSVKHwSBJ6jAYJEkdBoMkqcNgkCR1GAySpA6DQZLUYTBIkjoMBklSh8EgSeoY9qs9D03ylSS3JLk9yTtb+zOT3JjkjiQfT/L41v6ENr+lLV8xzPokSbsa9hHDw8ApVfVcYBVwWnuX83uAC6tqJXAfcFbrfxZwX1X9EnBh6ydJGqGhBkP1PNhmD2mfAk4BrmjtG4Az2/TqNk9bfmqSDLNGSVLX0K8xJDkoyc3AduAa4FvAj6pqR+uyFVjappcCdwO05fcDR86yzbVJppJMTU9PD/snSNKiMvRgqKpHqmoVsAw4AXj2bN3a92xHB7VLQ9W6qpqsqsmJiYn5K1aSNLq7kqrqR8D1wInAYUkObouWAfe06a3AcoC2/OnAD0dVoyRp+HclTSQ5rE0/EXgpsBm4Dnhl67YGuKpNb2zztOWfrapdjhgkScNz8J677JMlwIYkB9ELocur6uok3wAuS/K/gK8D61v/9cBHkmyhd6Tw6iHXJ0nayVCDoao2Ac+bpf3b9K437Nz+E+BVw6xJkrR7PvksSeowGCRJHQaDJKnDYJAkdRgMkqQOg0GS1GEwSJI65hwMSXZ5vmC2NknS/m2QI4bz59gmSdqP7fHJ5ySnA2cAS5O8v2/R04Ads68lSdpfzWVIjHuAKeDlwE197Q8A/2MYRUmSxmePwVBVtwC3JPlYVf3bCGqSJI3RIIPorUjybuA44NCZxqr6hXmvSpI0NoNcfP4QcBG96wovAS4BPjKMoiRJ4zNIMDyxqq4FUlV3VdU7gFOGU5YkaVwGOZX0kySPA+5Icg7wPeDo4ZQlSRqXQY4Y3gw8CXgT8HzgdTz6Gs5ZJVme5Lokm5PcnuTc1v6OJN9LcnP7nNG3zvlJtiT5ZpLfGPwnSZL2xZyPGKrqqwDtqOFNVfXAHFbbAfxhVX0tyVOBm5Jc05ZdWFV/1d85yXH0Xuf5HODngM8k+eWqemSudUqS9s0gQ2JMJrkV2ATcmuSWJM/f3TpVta2qvtamHwA2A0t3s8pq4LKqeriqvgNsYZZXgEqShmeQU0kXA39QVSuqagVwNr07leYkyQp673++sTWdk2RTkouTHN7algJ39622lVmCJMnaJFNJpqanpwf4CZKkPRkkGB6oqs/PzFTVF+g9/bxHSZ4CfAJ4c1X9mN5tr78IrAK2Ae+d6TrL6rVLQ9W6qpqsqsmJiYkBfoIkaU/mMlbS8W3yK0n+DriU3j/WvwNcP4f1D6EXCh+tqisBqurevuUfAK5us1uB5X2rL6M3JIckaUTmcvH5vTvNv71vepf/zfdLEmA9sLmq3tfXvqSqtrXZVwC3temNwMeSvI/exeeVwFfmUKMkaZ7MZaykl8xlQ0nWVNWGnZpPondb661Jbm5tfwK8JskqesFyJ/B77c+6PcnlwDfo3dF0tnckSdJoDfKA256cC3SCoV2HmO26waceayNVdQFwwTzWJUkawHy+2nO2AJAk7WfmMxh2e71BkrR/8IhBktSxx2DoG9/opD10/eK8VCRJGqu5HDG8oX3/7e46VdU5+16OJGnc5nJX0uYkdwITSTb1tQeoqvrVoVQmSRqLuTzH8JokzwA+Dbx8+CVJksZpLkNiXFtVpyb5dFXdNYqiJEnjM5dTSUuS/Efgt5Jcyk53H80Mqy1JOjDMJRj+FDiP3oB279tpWeF7nyXpgDKXawxXAFck+Z9V9a4R1CRJGqNBXu35riQvB05uTddX1dW7W0eStP8Z5NWe76Y3UN432ufc1iZJOoAMMrrqbwKrqupnAEk2AF8Hzh9GYZKk8Rh0rKTD+qafPp+FSJIWhkGOGN4NfD3JdfRuWT0ZjxYk6YAz5yOGqroUOBG4sn1eVFWXzSxP8pyd10myPMl1STYnub1vQL4jklyT5I72fXhrT5L3J9mSZFPf+6YlSSMy0KmkqtpWVRur6qqq+v5Oiz8yyyo7gD+sqmfTC5WzkxxH77mIa6tqJXBtmwc4nd57nlcCa4GLBqlPkrTvhvo+hhYkX2vTDwCbgaXAah59DegG4Mw2vRq4pHpuAA5LsmQea5Qk7cF8vvN5t29wS7ICeB5wI3BMVW2DXngkObp1Wwrc3bfa1ta2badtraV3RMGxxx47D6Vrf/DdP/v34y7hgHfsn9467hK0AMznEcNjSvIU4BPAm6vqx7vrOkvbLoFTVeuqarKqJicmJuarTEkS8xsMP52tMckh9ELho1V1ZWu+d+YUUfve3tq3Asv7Vl8G3DOPNUqS9mCQJ59PSvLkNv3aJO9L8vMzy6vqxFnWCbAe2FxV/QPwbQTWtOk1wFV97a9vdyedCNw/c8pJkjQagxwxXAQ8lOS5wB8DdwGX7GGdk4DXAackubl9zgD+HPj1JHcAv97mAT4FfBvYAnwA+IMB6pMkzYNBLj7vqKpKshr4m6pan2TN7laoqi8w+3UDgFNn6V/A2QPUJEmaZ4MEwwNJzgdeC5yc5CDgkOGUJUkal0FOJf0O8DBwVnu4bSnwl0OpSpI0NoO8j+H79L3Braq+y56vMUiS9jOD3JX0221so/uT/DjJA0l290yCJGk/NMg1hr8AfquqNg+rGEnS+A1yjeFeQ0GSDnyDHDFMJfk48Pf0LkID0Pc0syTpADBIMDwNeAh4WV9b0Xs3gyTpADHIXUlvGGYhkqSFYc7BkORDzD7S6RvntSJJ0lgNcirp6r7pQ4FX4MinknTAGeRU0if655NcCnxm3iuSJI3VvryPYSXg69Mk6QAzpyOG9l6FR4AH+5q/D7xtGEVJksZnTsHQhtu+uaqOH3ZBkqTxGuRU0peSvGBolUiSFoRBguEU4IYk30qyKcmtSTbtboUkFyfZnuS2vrZ3JPneTm90m1l2fpItSb6Z5DcG/zmSpH01yO2qp+/F9j8M/G92HZ77wqr6q/6GJMcBrwaeA/wc8Jkkv1xVj+zFnytJ2kuD3K5616Abr6rPJVkxx+6rgcuq6mHgO0m2ACcAXx70z5Uk7b19uV11X5zTTkddnOTw1rYUuLuvz9bWtoska5NMJZmanp4edq2StKiMIxguAn4RWAVsA97b2jNL312G4ACoqnVVNVlVkxMTE8OpUpIWqZEHQ1XdW1WPVNXPgA/QO10EvSOE5X1dl+GQG5I0ciMPhiRL+mZfAczcsbQReHWSJyR5Jr0nq78y6vokabEb5K6kgbXxlF4MHJVkK/B24MVJVtE7TXQn8HsAVXV7ksuBbwA7gLO9I0mSRm+owVBVr5mlef1u+l8AXDC8iiRJezKuu5IkSQuUwSBJ6jAYJEkdBoMkqcNgkCR1GAySpA6DQZLUYTBIkjoMBklSh8EgSeowGCRJHQaDJKnDYJAkdRgMkqQOg0GS1GEwSJI6hhoMSS5Osj3JbX1tRyS5Jskd7fvw1p4k70+yJcmmJMcPszZJ0uyGfcTwYeC0ndrOA66tqpXAtW0e4HR673leCawFLhpybZKkWQw1GKrqc8APd2peDWxo0xuAM/vaL6meG4DDkiwZZn2SpF2N4xrDMVW1DaB9H93alwJ39/Xb2tp2kWRtkqkkU9PT00MtVpIWm4V08TmztNVsHatqXVVNVtXkxMTEkMuSpMVlHMFw78wpova9vbVvBZb39VsG3DPi2iRp0RtHMGwE1rTpNcBVfe2vb3cnnQjcP3PKSZI0OgcPc+NJLgVeDByVZCvwduDPgcuTnAV8F3hV6/4p4AxgC/AQ8IZh1iZJmt1Qg6GqXvMYi06dpW8BZw+zHknSni2ki8+SpAXAYJAkdRgMkqQOg0GS1GEwSJI6DAZJUofBIEnqMBgkSR0GgySpw2CQJHUYDJKkDoNBktRhMEiSOgwGSVKHwSBJ6jAYJEkdQ31Rz+4kuRN4AHgE2FFVk0mOAD4OrADuBP5LVd03rholaTEa9xHDS6pqVVVNtvnzgGuraiVwbZuXJI3QuINhZ6uBDW16A3DmGGuRpEVpnMFQwD8luSnJ2tZ2TFVtA2jfR8+2YpK1SaaSTE1PT4+oXElaHMZ2jQE4qaruSXI0cE2Sf57rilW1DlgHMDk5WcMqUJIWo7EdMVTVPe17O/BJ4ATg3iRLANr39nHVJ0mL1ViCIcmTkzx1Zhp4GXAbsBFY07qtAa4aR32StJiN61TSMcAnk8zU8LGq+sckXwUuT3IW8F3gVWOqT5IWrbEEQ1V9G3juLO0/AE4dfUWSpBnjvPgsaZE46W9PGncJi8IX//sX52U7C+05BknSmBkMkqQOg0GS1GEwSJI6DAZJUofBIEnqMBgkSR0GgySpw2CQJHUYDJKkDoNBktRhMEiSOgwGSVKHwSBJ6jAYJEkdCy4YkpyW5JtJtiQ5b9z1SNJis6CCIclBwP8BTgeOA16T5LjxViVJi8uCCgbgBGBLVX27qn4KXAasHnNNkrSopKrGXcP/l+SVwGlV9d/a/OuAF1bVOTv1WwusbbP/DvjmSAsdraOAfx13Edpr7r/914G+736+qiZmW7DQ3vmcWdp2Sa6qWgesG34545dkqqomx12H9o77b/+1mPfdQjuVtBVY3je/DLhnTLVI0qK00ILhq8DKJM9M8njg1cDGMdckSYvKgjqVVFU7kpwDfBo4CLi4qm4fc1njtihOmR3A3H/7r0W77xbUxWdJ0vgttFNJkqQxMxgkSR0Gw4glWZ7kuiSbk9ye5NzWfkSSa5Lc0b4Pb+3PSvLlJA8n+aOdtnVuktvadt48jt+z2OzF/vvdJJva50tJntu3LYd/GaF53ncXJ9me5LZx/Z6hqio/I/wAS4Dj2/RTgX+hN/zHXwDntfbzgPe06aOBFwAXAH/Ut51fAW4DnkTvJoLPACvH/fsO9M9e7L//ABzepk8HbmzTBwHfAn4BeDxwC3DcuH/fgfyZr33X5k8GjgduG/fvGsbHI4YRq6ptVfW1Nv0AsBlYSm/ojw2t2wbgzNZne1V9Ffi3nTb1bOCGqnqoqnYA/xd4xQh+wqK2F/vvS1V1X2u/gd6zOeDwLyM3j/uOqvoc8MMRlT5yBsMYJVkBPA+4ETimqrZB7y8wvSOF3bkNODnJkUmeBJxB9+FADdle7L+zgH9o00uBu/uWbW1tGoF93HcHvAX1HMNikuQpwCeAN1fVj5PZRgN5bFW1Ocl7gGuAB+mditgx74VqVoPuvyQvofePy6/NNM3SzXvHR2Ae9t0BzyOGMUhyCL2/mB+tqitb871JlrTlS4Dte9pOVa2vquOr6mR6h7V3DKtmPWrQ/ZfkV4EPAqur6get2eFfxmCe9t0Bz2AYsfT+e7Ie2FxV7+tbtBFY06bXAFfNYVtHt+9jgd8GLp3farWzQfdf2zdXAq+rqn/p6+/wLyM2j/vugOeTzyOW5NeAzwO3Aj9rzX9C71zn5cCxwHeBV1XVD5M8A5gCntb6P0jv7pUfJ/k8cCS9C9NvqaprR/pjFqG92H8fBP4zcFfru6PaiJ1JzgD+mkeHf7lgZD9kEZrnfXcp8GJ6Q3PfC7y9qtaP6KcMncEgSerwVJIkqcNgkCR1GAySpA6DQZLUYTBIkjoMBklSh8EgLQBJDhp3DdIMg0EaUJJ3zYzl3+YvSPKmJG9N8tU2fv87+5b/fZKb2jsA1va1P5jkz5LcCLxoxD9DekwGgzS49bQhFJI8jt5wFvcCK+kNp70KeH6Sk1v/N1bV84FJ4E1JjmztT6Y3nv8Lq+oLo/wB0u44uqo0oKq6M8kPkjwPOAb4Or2XKb2sTQM8hV5QfI5eGMy8K2N5a/8B8Ai9Ad2kBcVgkPbOB4H/CjwDuBg4FXh3Vf1df6ckLwZeCryoqh5Kcj1waFv8k6p6ZFQFS3PlqSRp73wSOI3ekcKn2+eNbax/kixto98+HbivhcKzgBPHVbA0Vx4xSHuhqn6a5DrgR+1//f+U5NnAl9uLXx4EXgv8I/D7STYB36T3ikhpQXN0VWkvtIvOX6M3RLMvSNIBxVNJ0oCSHAdsAa41FHQg8ohBktThEYMkqcNgkCR1GAySpA6DQZLUYTBIkjr+H068ek4gJO4EAAAAAElFTkSuQmCC\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "sns.barplot(data=msd_yr_ws_sc,x='year',y='runs_off_bat')" ] }, { "cell_type": "code", "execution_count": 100, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
match_idseasonstart_datevenueinningsballbatting_teambowling_teamstrikernon_strikerbowlerruns_off_batextraswidesnoballsbyeslegbyespenaltywicket_typeplayer_dismissedother_wicket_typeother_player_dismissedyear
033598220082008-04-18M Chinnaswamy Stadium10.1Kolkata Knight RidersRoyal Challengers BangaloreSC GangulyBB McCullumP Kumar01NaNNaNNaN1.0NaNNaNNaNNaNNaN2008
\n", "
" ], "text/plain": [ " match_id season start_date venue innings ball batting_team bowling_team striker non_striker bowler runs_off_bat extras wides noballs byes legbyes penalty wicket_type player_dismissed other_wicket_type other_player_dismissed year\n", "0 335982 2008 2008-04-18 M Chinnaswamy Stadium 1 0.1 Kolkata Knight Riders Royal Challengers Bangalore SC Ganguly BB McCullum P Kumar 0 1 NaN NaN NaN 1.0 NaN NaN NaN NaN NaN 2008" ] }, "execution_count": 100, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.head(1)" ] }, { "cell_type": "code", "execution_count": 101, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "C:\\Users\\Jaikrishna\\anaconda3\\lib\\site-packages\\ipykernel_launcher.py:1: SettingWithCopyWarning: \n", "A value is trying to be set on a copy of a slice from a DataFrame.\n", "Try using .loc[row_indexer,col_indexer] = value instead\n", "\n", "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n", " \"\"\"Entry point for launching an IPython kernel.\n" ] } ], "source": [ "msd_df['year']=pd.to_datetime(msd_df['start_date']).dt.year" ] }, { "cell_type": "code", "execution_count": 102, "metadata": {}, "outputs": [], "source": [ "msd_df_dbi=msd_df[(msd_df['wides'].isnull()==True)]" ] }, { "cell_type": "code", "execution_count": 103, "metadata": {}, "outputs": [], "source": [ "dubai_df=pd.DataFrame(msd_df_dbi[(msd_df_dbi['venue']=='Dubai International Cricket Stadium')|\n", " (msd_df_dbi['venue']=='Sheikh Zayed Stadium')|\n", " (msd_df_dbi['venue']=='Sharjah Cricket Stadium')].groupby('year')['match_id'].nunique()).reset_index()" ] }, { "cell_type": "code", "execution_count": 104, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
yearInnings
020145
1202012
\n", "
" ], "text/plain": [ " year Innings\n", "0 2014 5 \n", "1 2020 12 " ] }, "execution_count": 104, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dubai_df.rename(columns={'match_id':'Innings'})" ] }, { "cell_type": "code", "execution_count": 105, "metadata": {}, "outputs": [], "source": [ "dubai_df_runs=pd.DataFrame(msd_df_dbi[(msd_df_dbi['venue']=='Dubai International Cricket Stadium')|\n", " (msd_df_dbi['venue']=='Sheikh Zayed Stadium')|\n", " (msd_df_dbi['venue']=='Sharjah Cricket Stadium')].groupby('year')['runs_off_bat'].sum()).reset_index()" ] }, { "cell_type": "code", "execution_count": 106, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
yearruns_off_bat
0201490
12020200
\n", "
" ], "text/plain": [ " year runs_off_bat\n", "0 2014 90 \n", "1 2020 200 " ] }, "execution_count": 106, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dubai_df_runs" ] }, { "cell_type": "code", "execution_count": 107, "metadata": {}, "outputs": [], "source": [ "dubai_df_balls=pd.DataFrame(msd_df_dbi[(msd_df_dbi['venue']=='Dubai International Cricket Stadium')|\n", " (msd_df_dbi['venue']=='Sheikh Zayed Stadium')|\n", " (msd_df_dbi['venue']=='Sharjah Cricket Stadium')].groupby('year')['ball'].count()).reset_index()" ] }, { "cell_type": "code", "execution_count": 108, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
yearball
0201459
12020172
\n", "
" ], "text/plain": [ " year ball\n", "0 2014 59 \n", "1 2020 172 " ] }, "execution_count": 108, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dubai_df_balls" ] }, { "cell_type": "code", "execution_count": 109, "metadata": {}, "outputs": [], "source": [ "dubai_df=dubai_df.merge(dubai_df_runs,how='left',on='year')" ] }, { "cell_type": "code", "execution_count": 110, "metadata": {}, "outputs": [], "source": [ "dubai_df=dubai_df.merge(dubai_df_balls,how='left',on='year')" ] }, { "cell_type": "code", "execution_count": 111, "metadata": {}, "outputs": [], "source": [ "dubai_df['SR']=100*dubai_df['runs_off_bat']/dubai_df['ball']" ] }, { "cell_type": "code", "execution_count": 112, "metadata": {}, "outputs": [], "source": [ "dubai_df.rename(columns={'match_id':'Innings'},inplace=True)" ] }, { "cell_type": "code", "execution_count": 113, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
yearInningsruns_off_batballSR
0201459059152.542373
1202012200172116.279070
\n", "
" ], "text/plain": [ " year Innings runs_off_bat ball SR\n", "0 2014 5 90 59 152.542373\n", "1 2020 12 200 172 116.279070" ] }, "execution_count": 113, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dubai_df" ] }, { "cell_type": "code", "execution_count": 114, "metadata": {}, "outputs": [], "source": [ "dubai_full=df[(df['venue']=='Dubai International Cricket Stadium')|\n", " (df['venue']=='Sheikh Zayed Stadium')|\n", " (df['venue']=='Sharjah Cricket Stadium')]" ] }, { "cell_type": "code", "execution_count": 115, "metadata": {}, "outputs": [], "source": [ "dubai_df_all=pd.DataFrame(dubai_full.groupby('striker')['runs_off_bat'].sum().sort_values(ascending=False)).reset_index()" ] }, { "cell_type": "code", "execution_count": 116, "metadata": {}, "outputs": [], "source": [ "dubai_df_ball=pd.DataFrame(dubai_full.groupby('striker')['ball'].count().sort_values(ascending=False)).reset_index()" ] }, { "cell_type": "code", "execution_count": 117, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
strikerball
0KL Rahul645
1DA Warner570
2S Dhawan512
3V Kohli492
4MK Pandey481
5SS Iyer433
6Q de Kock423
7AT Rayudu417
8SA Yadav406
9D Padikkal398
10AJ Finch389
11F du Plessis382
12Shubman Gill382
13AB de Villiers372
14Ishan Kishan361
15RG Sharma351
16SR Watson348
17SV Samson327
18RR Pant319
19MA Agarwal318
20EJG Morgan314
21SPD Smith296
22JM Bairstow284
23GJ Maxwell270
24AM Rahane268
25KA Pollard264
26N Rana260
27RV Uthappa259
28MP Stoinis250
29KS Williamson241
30MS Dhoni234
31JC Buttler233
32CH Gayle232
33KD Karthik217
34N Pooran215
35BA Stokes207
36RA Jadeja189
37R Tewatia187
38RA Tripathi186
39WP Saha178
40RD Gaikwad173
41DR Smith171
42PP Shaw170
43HH Pandya167
44BB McCullum157
45M Vijay155
46SM Curran145
47JP Duminy132
48SO Hetmyer127
49PJ Cummins120
50JH Kallis119
51PK Garg116
52Mandeep Singh111
53CA Pujara109
54S Dube109
55Yuvraj Singh106
56AR Patel103
57PA Patel103
58SP Narine102
59DA Miller99
60V Shankar99
61Washington Sundar98
62V Sehwag97
63KH Pandya92
64SK Raina84
65Gurkeerat Singh83
66AD Russell82
67CJ Anderson82
68SS Tiwary81
69R Parag81
70JR Philippe80
71KM Jadhav78
72AP Tare78
73DJ Hooda74
74Abdul Samad68
75JC Archer66
76G Gambhir65
77TK Curran63
78Abhishek Sharma59
79LRPL Taylor56
80MEK Hussey54
81JO Holder54
82MK Lomror54
83K Rabada52
84CA Lynn52
85STR Binny52
86R Ashwin51
87AM Nayar50
88GJ Bailey49
89Shakib Al Hasan46
90DJG Sammy45
91YBK Jaiswal44
92JDS Neesham44
93S Gopal41
94R Dhawan40
95YV Takawale39
96Y Venugopal Rao37
97KP Pietersen35
98CM Gautam34
99MA Starc33
100CJ Jordan33
101KL Nagarkoti32
102JA Morkel32
103Rashid Khan32
104KK Nair32
105N Jagadeesan31
106SN Khan30
107AT Carey29
108LH Ferguson29
109NA Saini27
110K Gowtham27
111HV Patel25
112VR Aaron25
113MK Tiwary24
114R Bhatia24
115T Banton22
116CH Morris21
117M Manhas21
118DS Kulkarni21
119SN Thakur21
120Harbhajan Singh21
121Kuldeep Yadav21
122KV Sharma20
123YK Pathan20
124Sandeep Sharma20
125JD Unadkat18
126DW Steyn18
127BR Dunk18
128CV Varun16
129S Nadeem16
130MM Ali16
131NM Coulter-Nile15
132P Simran Singh15
133Mohammed Siraj14
134NJ Maddinson14
135Shivam Mavi14
136JL Pattinson13
137P Dubey13
138R Rampaul13
139Ravi Bishnoi12
140DL Chahar12
141TU Deshpande12
142JP Faulkner12
143RK Singh11
144I Udana11
145IK Pathan11
146Imran Tahir10
147AS Rajpoot10
148S Rana9
149MS Bisla9
150DJ Bravo9
151AB Dinda8
152BJ Hodge8
153Mohammad Nabi8
154MG Johnson8
155AJ Tye7
156Z Khan7
157Mohammed Shami7
158R Vinay Kumar7
159A Nortje6
160Kartik Tyagi6
161UT Yadav6
162PP Ojha5
163SP Goswami5
164B Kumar5
165T Natarajan5
166A Mishra5
167YS Chahal5
168RD Chahar4
169M Prasidh Krishna4
170NV Ojha4
171M Morkel4
172M Ashwin4
173JJ Bumrah4
174SL Malinga4
175TG Southee4
176PP Chawla3
177Arshdeep Singh3
178NS Naik3
179Mujeeb Ur Rahman3
180PV Tambe2
181SS Cottrell2
182L Balaji2
183KK Ahmed2
184DR Sams2
185Shahbaz Ahmed1
186TA Boult1
187MR Marsh1
\n", "
" ], "text/plain": [ " striker ball\n", "0 KL Rahul 645 \n", "1 DA Warner 570 \n", "2 S Dhawan 512 \n", "3 V Kohli 492 \n", "4 MK Pandey 481 \n", "5 SS Iyer 433 \n", "6 Q de Kock 423 \n", "7 AT Rayudu 417 \n", "8 SA Yadav 406 \n", "9 D Padikkal 398 \n", "10 AJ Finch 389 \n", "11 F du Plessis 382 \n", "12 Shubman Gill 382 \n", "13 AB de Villiers 372 \n", "14 Ishan Kishan 361 \n", "15 RG Sharma 351 \n", "16 SR Watson 348 \n", "17 SV Samson 327 \n", "18 RR Pant 319 \n", "19 MA Agarwal 318 \n", "20 EJG Morgan 314 \n", "21 SPD Smith 296 \n", "22 JM Bairstow 284 \n", "23 GJ Maxwell 270 \n", "24 AM Rahane 268 \n", "25 KA Pollard 264 \n", "26 N Rana 260 \n", "27 RV Uthappa 259 \n", "28 MP Stoinis 250 \n", "29 KS Williamson 241 \n", "30 MS Dhoni 234 \n", "31 JC Buttler 233 \n", "32 CH Gayle 232 \n", "33 KD Karthik 217 \n", "34 N Pooran 215 \n", "35 BA Stokes 207 \n", "36 RA Jadeja 189 \n", "37 R Tewatia 187 \n", "38 RA Tripathi 186 \n", "39 WP Saha 178 \n", "40 RD Gaikwad 173 \n", "41 DR Smith 171 \n", "42 PP Shaw 170 \n", "43 HH Pandya 167 \n", "44 BB McCullum 157 \n", "45 M Vijay 155 \n", "46 SM Curran 145 \n", "47 JP Duminy 132 \n", "48 SO Hetmyer 127 \n", "49 PJ Cummins 120 \n", "50 JH Kallis 119 \n", "51 PK Garg 116 \n", "52 Mandeep Singh 111 \n", "53 CA Pujara 109 \n", "54 S Dube 109 \n", "55 Yuvraj Singh 106 \n", "56 AR Patel 103 \n", "57 PA Patel 103 \n", "58 SP Narine 102 \n", "59 DA Miller 99 \n", "60 V Shankar 99 \n", "61 Washington Sundar 98 \n", "62 V Sehwag 97 \n", "63 KH Pandya 92 \n", "64 SK Raina 84 \n", "65 Gurkeerat Singh 83 \n", "66 AD Russell 82 \n", "67 CJ Anderson 82 \n", "68 SS Tiwary 81 \n", "69 R Parag 81 \n", "70 JR Philippe 80 \n", "71 KM Jadhav 78 \n", "72 AP Tare 78 \n", "73 DJ Hooda 74 \n", "74 Abdul Samad 68 \n", "75 JC Archer 66 \n", "76 G Gambhir 65 \n", "77 TK Curran 63 \n", "78 Abhishek Sharma 59 \n", "79 LRPL Taylor 56 \n", "80 MEK Hussey 54 \n", "81 JO Holder 54 \n", "82 MK Lomror 54 \n", "83 K Rabada 52 \n", "84 CA Lynn 52 \n", "85 STR Binny 52 \n", "86 R Ashwin 51 \n", "87 AM Nayar 50 \n", "88 GJ Bailey 49 \n", "89 Shakib Al Hasan 46 \n", "90 DJG Sammy 45 \n", "91 YBK Jaiswal 44 \n", "92 JDS Neesham 44 \n", "93 S Gopal 41 \n", "94 R Dhawan 40 \n", "95 YV Takawale 39 \n", "96 Y Venugopal Rao 37 \n", "97 KP Pietersen 35 \n", "98 CM Gautam 34 \n", "99 MA Starc 33 \n", "100 CJ Jordan 33 \n", "101 KL Nagarkoti 32 \n", "102 JA Morkel 32 \n", "103 Rashid Khan 32 \n", "104 KK Nair 32 \n", "105 N Jagadeesan 31 \n", "106 SN Khan 30 \n", "107 AT Carey 29 \n", "108 LH Ferguson 29 \n", "109 NA Saini 27 \n", "110 K Gowtham 27 \n", "111 HV Patel 25 \n", "112 VR Aaron 25 \n", "113 MK Tiwary 24 \n", "114 R Bhatia 24 \n", "115 T Banton 22 \n", "116 CH Morris 21 \n", "117 M Manhas 21 \n", "118 DS Kulkarni 21 \n", "119 SN Thakur 21 \n", "120 Harbhajan Singh 21 \n", "121 Kuldeep Yadav 21 \n", "122 KV Sharma 20 \n", "123 YK Pathan 20 \n", "124 Sandeep Sharma 20 \n", "125 JD Unadkat 18 \n", "126 DW Steyn 18 \n", "127 BR Dunk 18 \n", "128 CV Varun 16 \n", "129 S Nadeem 16 \n", "130 MM Ali 16 \n", "131 NM Coulter-Nile 15 \n", "132 P Simran Singh 15 \n", "133 Mohammed Siraj 14 \n", "134 NJ Maddinson 14 \n", "135 Shivam Mavi 14 \n", "136 JL Pattinson 13 \n", "137 P Dubey 13 \n", "138 R Rampaul 13 \n", "139 Ravi Bishnoi 12 \n", "140 DL Chahar 12 \n", "141 TU Deshpande 12 \n", "142 JP Faulkner 12 \n", "143 RK Singh 11 \n", "144 I Udana 11 \n", "145 IK Pathan 11 \n", "146 Imran Tahir 10 \n", "147 AS Rajpoot 10 \n", "148 S Rana 9 \n", "149 MS Bisla 9 \n", "150 DJ Bravo 9 \n", "151 AB Dinda 8 \n", "152 BJ Hodge 8 \n", "153 Mohammad Nabi 8 \n", "154 MG Johnson 8 \n", "155 AJ Tye 7 \n", "156 Z Khan 7 \n", "157 Mohammed Shami 7 \n", "158 R Vinay Kumar 7 \n", "159 A Nortje 6 \n", "160 Kartik Tyagi 6 \n", "161 UT Yadav 6 \n", "162 PP Ojha 5 \n", "163 SP Goswami 5 \n", "164 B Kumar 5 \n", "165 T Natarajan 5 \n", "166 A Mishra 5 \n", "167 YS Chahal 5 \n", "168 RD Chahar 4 \n", "169 M Prasidh Krishna 4 \n", "170 NV Ojha 4 \n", "171 M Morkel 4 \n", "172 M Ashwin 4 \n", "173 JJ Bumrah 4 \n", "174 SL Malinga 4 \n", "175 TG Southee 4 \n", "176 PP Chawla 3 \n", "177 Arshdeep Singh 3 \n", "178 NS Naik 3 \n", "179 Mujeeb Ur Rahman 3 \n", "180 PV Tambe 2 \n", "181 SS Cottrell 2 \n", "182 L Balaji 2 \n", "183 KK Ahmed 2 \n", "184 DR Sams 2 \n", "185 Shahbaz Ahmed 1 \n", "186 TA Boult 1 \n", "187 MR Marsh 1 " ] }, "execution_count": 117, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dubai_df_ball" ] }, { "cell_type": "code", "execution_count": 118, "metadata": {}, "outputs": [], "source": [ "dubai_df_all=dubai_df_all.merge(dubai_df_ball,how='left',on='striker')" ] }, { "cell_type": "code", "execution_count": 119, "metadata": {}, "outputs": [], "source": [ "dubai_df_all['SR']=100*dubai_df_all['runs_off_bat']/dubai_df_all['ball']" ] }, { "cell_type": "code", "execution_count": 120, "metadata": {}, "outputs": [], "source": [ "dubai_df_all=dubai_df_all[dubai_df_all['runs_off_bat']>100].sort_values('SR',ascending=False).reset_index()" ] }, { "cell_type": "code", "execution_count": 121, "metadata": {}, "outputs": [], "source": [ "dubai_df_all.drop('index',axis=1,inplace=True)" ] }, { "cell_type": "code", "execution_count": 122, "metadata": {}, "outputs": [], "source": [ "dubai_df_all=dubai_df_all.head(10)" ] }, { "cell_type": "code", "execution_count": 123, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
strikerruns_off_batballSR
0JC Archer11366171.212121
1HH Pandya283167169.461078
2Abdul Samad11368166.176471
3N Pooran353215164.186047
4DA Miller15599156.565657
5KA Pollard413264156.439394
6GJ Maxwell408270151.111111
7RA Jadeja281189148.677249
8MA Agarwal466318146.540881
9SO Hetmyer185127145.669291
\n", "
" ], "text/plain": [ " striker runs_off_bat ball SR\n", "0 JC Archer 113 66 171.212121\n", "1 HH Pandya 283 167 169.461078\n", "2 Abdul Samad 113 68 166.176471\n", "3 N Pooran 353 215 164.186047\n", "4 DA Miller 155 99 156.565657\n", "5 KA Pollard 413 264 156.439394\n", "6 GJ Maxwell 408 270 151.111111\n", "7 RA Jadeja 281 189 148.677249\n", "8 MA Agarwal 466 318 146.540881\n", "9 SO Hetmyer 185 127 145.669291" ] }, "execution_count": 123, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dubai_df_all" ] }, { "cell_type": "code", "execution_count": 149, "metadata": {}, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAA7MAAAHwCAYAAAB0TTiEAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAgAElEQVR4nOzdebxtZV0/8M9XccgBUbmaDIoDzhMIqJkKTmmZaGpAmWgqWlb+TH8OWUr1o6w0h5zCHMCcyFTQNDEHSBMUUEHCAXGAULgmIs4i398fax3v5njOuede7hnW9f1+vc7r7P2s6dlrr732+qznWWtXdwcAAACm5EprXQEAAADYUsIsAAAAkyPMAgAAMDnCLAAAAJMjzAIAADA5wiwAAACTI8wC8FNV9aqq+rPx8f5Vdd5a1+mKqqp7VtXnttG89qiqrqodtuW4i0z/naq62czzB1TVO7diPu+tqkO39bhsO1V1tar6bFXdYK3rAjAlwizAdqKqfrmq/quqLq6qb1bVR6tq33HYY6rqI5ubR3c/qbv/cgXq1lX13TGg/U9V/X1VXXmZ016hUN3d/9ndt9ra6ddKd1+ru8+ZKfqrJM+fezKu0wtmw3JV7VBVF1ZVz8znQd191DKXuexxV1NV3aiqjquq88fXvce84VerqtdW1ber6utV9cfzht93DIvfq6oPVdVNlljWl6vq++O2+vWqen1VXWtlXtmgu3+Y5LVJnrmSywHY3gizANuBqtoxybuT/EOS6yXZNcmfJ/nhFsxjWeHyCrhTd18ryb2THJTkd1d4eduN8aTEdbr7pHmDvpXkQTPPfzXJRatWsdVzWZJ/T/LwRYYfnmTPJDdJckCSZ1TVA5OkqnZO8vYkf5bhs3FKkrduZnm/Pm6rd06yV5JnX8H6L8ebkhxaVVdbhWUBbBeEWYDtwy2TpLvf3N0/6e7vd/fx3X16Vd0myauS3H1sbfpWkowtTq+sqvdU1XeTHDCW/b+FFlBVf1RV/11Vu43PH1xVn6qqb40twndcTkW7++wkH80QFObm/diqOquqLqmqc6rqiWP5NZO8N8kuY92/U1W7VNWVqupZVfXFqvrfqjqmqq63SL0v17I7trw9vapOH1ux31pVV19k2itX1Quq6htVdU6SX5s3/MtVdb+Z54dX1T/Pm83vji2KX6uqp82Mu19VfWxcf1+rqpdV1VVnhndV3WJ8+qAkJyxQxTckefTM80cnOXpeHT9cVY8fHz+mqj4yvqaLqupLVfWgJcb9aFW9aKzjOVX1S2P5uWML8KELTTu7rHmv5/er6gvj+/yXVXXzcR18e3wPf/r6Z3X3Bd39iiSfWGj4+Lr/srsv6u6zkrw6yWPGYb+R5Mzu/pfu/kGG4Hunqrr1IvOaXe7Xk7wvl99Wl/M6nzS+zouq6uVVVeOwW1TVCeN2942qeuvMss7LcCLibpurFwADYRZg+/D5JD+pqqOq6kFVdd25AePB/ZOSfGzsurrTzHS/leSIJNdOsmg35Bquo31Mknt393lVtXeGbpFPTHL9JP+Y5LjltCqNIeKeSc6eKb4wyYOT7JjksUleVFV7d/d3MwS588e6X6u7z0/yR0kemqGVd5cMIeDlm1v2jN9M8sAkN01yx2wKPvM9YazXXkn2SfKILVjGnAMytBo+IMmzZsLvT5I8NcnOSe6e5L5Jfn+RedwhyULX/b4zyb2qaqeq2inDej12M/W56zivnZP8bZLXzIWtRcY9PcN7/KYkb0myb5JbJHlUkpfVlnXBfWCSu2QIbM9IcmSS306ye5LbJzlkC+aVJBm39V2SfHqm+NNJbjc+vt3ssHGb+uLM8KXmvVuG7e/szY07z4MzrKc7ZdjWfmUs/8skxye5bpLdMvSkmHXWOA0AyyDMAmwHuvvbSX45SWdoldpYwzWGN9zMpMd290e7+7Kx1Wq+qqq/z3AwfkB3bxzLn5DkH7v75LEl+KgMXZqXalU6bWwBPivJh5O8Yqb+/9bdX+zBCRkO+O+5xLyemOQ53X3eeL3h4UkeUcu/2dJLu/v87v5mkndlpuVtnt9M8uLuPncc96+XOf9Zf97d3+3uM5K8LmNg6+5Tu/uk7r60u7+c4YTAvReZx05JLlmg/Adj/Q9KcnCS48aypXylu1/d3T9JclSSGyVZbDv5Une/bhz3rRlC51909w+7+/gkP8oQbJfrb7r72919ZpLPJDm+u8/p7osztMDvtQXzmjMXpi+eKbs4wwmaueEX5/Jmhy/knVV1SZJzM5xoed4W1un53f2t7v5qkg9l0/b14wxdoXfp7h909/wTSJdkeK8BWAZhFmA70d1ndfdjunu3DK1cuyR58WYmO3czw3dKcliSvx4Dx5ybJHna2P30WzV0Xd59XOZi9s4QLA7K0OJ3zbkBY2vySTXcuOpbGa793HmJed0kyTtmln1WhpbOzYX3OV+fefy9bApE8+2Sy6+jryxz/rPmT79LklTVLavq3TXcZOjbGW7wtNhrviiLh6+jM3Sz/Zkuxov46Wvv7u+NDxd7/RfMPP7+OM38si1pmZ0/7RWZ15zvjP93nCnbMZvC/3fmDZs/fCEP7e5rJ9k/ya2z9La4kMW2r2ckqSQfr6ozq2r+dePXznAdNADLIMwCbIe6+7NJXp8h1CZDi+2Co25mVhdl6DL5uqq6x0z5uUmO6O6dZv6u0d1v3ky9uruPSfKxJM9NhjvRJvnXJC9IcsOxG/R7Mhz0L1bHc5M8aN7yr97d/7OZ17OlvpYhpM+58bzh301yjZnnv7jAPOZPf/74+JVJPptkz+7eMcmfZNNrnu/0jNdFL+A/s6l1dbN3rF5By1kX21x3X5ThfZrtnnunJGeOj8+cHVbDddg3nxm+1LxPyPA5esFM8Va/zu7+enc/obt3ydC74BUz10UnyW1y+e7SACxBmAXYDlTVravqabXp5ky7Z+jOOnf32wuS7LbYDXaW0t0fznBd4zuq6q5j8auTPKmq7lqDa1bVr1XVUl03Zz0/yWFV9YtJrprkakk2Jrl0vCHRA2bGvSDJ9avqOjNlr0pyRI0/sVJVG6rqwC19bctwTJI/qqrdxmsznzVv+KeSHFxVV6mqxa6p/bOqukZV3S7D9cBzN/25dpJvJ/nOeB3x7y1Rj/dkkS7I3d1Jfj3JQ8bHa+VTSX5jfK23SPK4bTnzGm7SNXdN9tXq8jftOjrJn1bVdcd1+YQMITRJ3pHk9lX18HGa5yY5fTzhsxwvTnL/qprrKrzVr7OqHjn3Gc1woqgz9ChIVe2a4W7L8+9YDcAihFmA7cMlGbrunjxel3pShmsS5+6e+8EMLVFfr6pvbOnMu/v9GYLYcVV1l+4+JUNgeFmGg/Kzs/hNlBaa3xkZ7s77f7v7kgw3dDpmnNdvZbj2c27czyZ5c5Jzxm7FuyR5yTjO8eO1jSeNr39be3WGu9l+OslpGX7iZdafZWjluyjDTyG9aYF5nJBh/XwgyQvGa02T5OkZXusl43IW/bmY7j4tycUzJxPmDz9zvA51Lb0owzW0F2S4FveN23j+38+mLsWfHZ/PeV6Gmzp9JcP6/rvu/vckGa/zfniGG51dlGE7OXi5Cx2nPzrDe51csde5b4bP6HcybL9P6e4vjcN+K8lR4zXgACxDre1JXABgOarqAUl+v7sfutZ1Ydsau9p/Osm9uvvCta4PwFQIswAAAEyObsYAAABMjjALAADA5AizAAAATI4wCwAAwOTssNYVuCJ23nnn3mOPPda6GgAAAKyAU0899RvdvWGhYZMOs3vssUdOOeWUta4GAAAAK6CqvrLYMN2MAQAAmBxhFgAAgMkRZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyRFmAQAAmBxhFgAAgMkRZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyRFmAQAAmBxhFgAAgMkRZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyRFmAQAAmJwd1roCK+0u//fota7Cunbq3z16rasAAACwxbTMAgAAMDnCLAAAAJMjzAIAADA52/01s6y8r/7FHda6CuvajZ97xlpXAQAAtjtaZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyRFmAQAAmBxhFgAAgMkRZgEAAJgcvzMLE3GPf7jHWldh3froH350rasAAMAq0zILAADA5AizAAAATI4wCwAAwOQIswAAAEyOG0ABjE64173Xugrr1r1PPGGtqwAAcDlaZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyRFmAQAAmJwVC7NV9dqqurCqPjOv/A+r6nNVdWZV/e1M+bOr6uxx2K+sVL0AAACYvpX8aZ7XJ3lZkqPnCqrqgCQHJrljd/+wqm4wlt82ycFJbpdklyT/UVW37O6frGD9AAAAmKgVa5nt7hOTfHNe8e8leX53/3Ac58Kx/MAkb+nuH3b3l5KcnWS/laobAAAA07ba18zeMsk9q+rkqjqhqvYdy3dNcu7MeOeNZQAAAPAzVrKb8WLLu26SuyXZN8kxVXWzJLXAuL3QDKrqsCSHJcmNb3zjFaomAAAA69lqt8yel+TtPfh4ksuS7DyW7z4z3m5Jzl9oBt19ZHfv0937bNiwYcUrDAAAwPqz2mH2nUnukyRVdcskV03yjSTHJTm4qq5WVTdNsmeSj69y3QAAAJiIFetmXFVvTrJ/kp2r6rwkz0vy2iSvHX+u50dJDu3uTnJmVR2T5L+TXJrkye5kDAAAwGJWLMx29yGLDHrUIuMfkeSIlaoPAAAA24/V7mYMAAAAV5gwCwAAwOQIswAAAEzOav/OLAA/x172tHetdRXWtT944a9vk/kc8ahHbJP5bI+e889vW+sqALCNaJkFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmZ4e1rgAAwNScdcQH17oK69ZtnnOfta4C8HNCyywAAACTI8wCAAAwOcIsAAAAkyPMAgAAMDnCLAAAAJPjbsYAAKw7hx9++FpXYV2zfkDLLAAAABMkzAIAADA5wiwAAACTI8wCAAAwOW4ABQAAP4eO+Zf91roK69pvPvLja10FNkPLLAAAAJOjZRYAAGCF3Olt71vrKqxbn37Er1yh6bXMAgAAMDnCLAAAAJMjzAIAADA5wiwAAACTI8wCAAAwOcIsAAAAkyPMAgAAMDnCLAAAAJMjzAIAADA5KxZmq+q1VXVhVX1mgWFPr6quqp3H51VVL62qs6vq9Krae6XqBQAAwPStZMvs65M8cH5hVe2e5P5JvjpT/KAke45/hyV55QrWCwAAgIlbsTDb3Scm+eYCg16U5BlJeqbswCRH9+CkJDtV1Y1Wqm4AAABM26peM1tVD0nyP9396XmDdk1y7szz88YyAAAA+Bk7rNaCquoaSZ6T5AELDV6grBcoS1UdlqErcm584xtvs/oBAAAwHavZMnvzJDdN8umq+nKS3ZKcVlW/mKEldveZcXdLcv5CM+nuI7t7n+7eZ8OGDStcZQAAANajVQuz3X1Gd9+gu/fo7j0yBNi9u/vrSY5L8ujxrsZ3S3Jxd39tteoGAADAtKzkT/O8OcnHktyqqs6rqsctMfp7kpyT5Owkr07y+ytVLwAAAKZvxa6Z7e5DNjN8j5nHneTJK1UXAAAAti+rejdjAAAA2BaEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmZ8XCbFW9tqourKrPzJT9XVV9tqpOr6p3VNVOM8OeXVVnV9XnqupXVqpeAAAATN9Ktsy+PskD55W9P8ntu/uOST6f5NlJUlW3TXJwktuN07yiqq68gnUDAABgwlYszHb3iUm+Oa/s+O6+dHx6UpLdxscHJnlLd/+wu7+U5Owk+61U3QAAAJi2tbxm9neTvHd8vGuSc2eGnTeWAQAAwM9YkzBbVc9JcmmSN84VLTBaLzLtYVV1SlWdsnHjxpWqIgAAAOvYqofZqjo0yYOT/HZ3zwXW85LsPjPabknOX2j67j6yu/fp7n02bNiwspUFAABgXVrVMFtVD0zyzCQP6e7vzQw6LsnBVXW1qrppkj2TfHw16wYAAMB07LBSM66qNyfZP8nOVXVekudluHvx1ZK8v6qS5KTuflJ3n1lVxyT57wzdj5/c3T9ZqboBAAAwbSsWZrv7kAWKX7PE+EckOWKl6gMAAMD2Yy3vZgwAAABbRZgFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJmfFwmxVvbaqLqyqz8yUXa+q3l9VXxj/X3csr6p6aVWdXVWnV9XeK1UvAAAApm8lW2Zfn+SB88qeleQD3b1nkg+Mz5PkQUn2HP8OS/LKFawXAAAAE7fZMDu2mj6qqp47Pr9xVe23uem6+8Qk35xXfGCSo8bHRyV56Ez50T04KclOVXWj5b4IAAAAfr4sp2X2FUnunuSQ8fklSV6+lcu7YXd/LUnG/zcYy3dNcu7MeOeNZQAAAPAzlhNm79rdT07ygyTp7ouSXHUb16MWKOsFR6w6rKpOqapTNm7cuI2rAQAAwBQsJ8z+uKqunDFcVtWGJJdt5fIumOs+PP6/cCw/L8nuM+PtluT8hWbQ3Ud29z7dvc+GDRu2shoAAABM2XLC7EuTvCPJDarqiCQfSfLXW7m845IcOj4+NMmxM+WPHq/PvVuSi+e6IwMAAMB8O2xuhO5+Y1WdmuS+GboDP7S7z9rcdFX15iT7J9m5qs5L8rwkz09yTFU9LslXkzxyHP09SX41ydlJvpfksVv+UgAAAPh5sdkwW1Vv6O7fSfLZBcoW1d2HLDLovguM20mevLm6AAAAQLK8bsa3m30yXj97l5WpDgAAAGzeomG2qp5dVZckuWNVfbuqLhmfX5hN17oCAADAqls0zHb3X3f3tZP8XXfv2N3XHv+u393PXsU6AgAAwOUs5wZQz66q6ybZM8nVZ8pPXMmKAQAAwGKWcwOoxyd5Sobffv1Ukrsl+ViS+6xs1QAAAGBhy7kB1FOS7JvkK919QJK9kmxc0VoBAADAEpYTZn/Q3T9Ikqq6Wnd/NsmtVrZaAAAAsLjNdjNOcl5V7ZTknUneX1UXJTl/ZasFAAAAi1vODaAeNj48vKo+lOQ6Sd67orUCAACAJSynm/FPdfcJSU5M8oyVqQ4AAABs3qJhtqp2r6ojq+rdVfX4qrpGVb0wyeeT3GD1qggAAACXt1Q346OTnJDkX5M8MMlJSc5Mcsfu/voq1A0AAAAWtFSYvV53Hz4+fl9VXZBk3+7+4cpXCwAAABa35A2gquq6SWp8+vUk16iqayZJd39zhesGAAAAC1oqzF4nyanZFGaT5LTxfye52UpVCgAAAJayaJjt7j1WsR4AAACwbFv00zwAAACwHgizAAAATI4wCwAAwOQsK8xW1S9X1WPHxxuq6qYrWy0AAABY3GbDbFU9L8kzkzx7LLpKkn9eyUoBAADAUpbTMvuwJA9J8t0k6e7zk1x7JSsFAAAAS1lOmP1Rd3eG35ZNVV1zZasEAAAAS1tOmD2mqv4xyU5V9YQk/5Hkn1a2WgAAALC4HTY3Qne/oKrun+TbSW6V5Lnd/f4VrxkAAAAsYrNhtqoe1N3vTfL+mbIndferVrRmAAAAsIjldDP+s6q6z9yTqnpmkgNXrkoAAACwtM22zGa4k/G7q+r/JnlgkluPZQAAALAmlnPN7Deq6iEZbvx0apJHjHc3BgAAgDWxaJitqksy/BxPjf+vmuRmSR5RVd3dO65OFQEAAODyFg2z3X3t1awIAAAALNdSLbO37u7PVtXeCw3v7tNWrloAAACwuKWumf3jJIcleeECwzrJfRYoBwAAgBW3VDfjw6rqSkn+tLs/uop1AgAAgCUt+Tuz3X1ZkhesUl0AAABgWZYMs6Pjq+rhVVUrXhsAAABYhs3+zmyGa2evmeTSqvpBxp/q8dM8AAAArJXNhlk/0QMAAMB6s9luxlX1geWUAQAAwGpZ6ndmr57kGkl2rqrrZuhenCQ7JtllFeoGAAAAC1qqm/ETk/yfDMH11GwKs99O8vIrstCqemqSx2f4vdozkjw2yY2SvCXJ9ZKcluR3uvtHV2Q5AAAAbJ8W7Wbc3S/p7psmeXp336y7bzr+3am7X7a1C6yqXZP8UZJ9uvv2Sa6c5OAkf5PkRd29Z5KLkjxua5cBAADA9m3RMFtV+1bVL3b3P4zPH11Vx1bVS6vqeldwuTsk+YWq2iFDV+avJblPkreNw49K8tAruAwAAAC2U0vdAOofk/woSarqXkmen+ToJBcnOXJrF9jd/5PkBUm+miHEXpyhG/O3uvvScbTzkuy60PRVdVhVnVJVp2zcuHFrqwEAAMCELRVmr9zd3xwfH5TkyO7+1+7+syS32NoFjjeTOjDJTTNcj3vNJA9aYNReaPruPrK79+nufTZs2LC11QAAAGDClgyzYzfgJLlvkg/ODNvs79Mu4X5JvtTdG7v7x0nenuSXkuw0s7zdkpx/BZYBAADAdmypMPvmJCdU1bFJvp/kP5Okqm6RoWvw1vpqkrtV1TWqqjIE5f9O8qEkjxjHOTTJsVdgGQAAAGzHFm1h7e4jquoDGX4y5/junuv2e6Ukf7i1C+zuk6vqbRl+fufSJJ/McA3uvyV5S1X9v7HsNVu7DAAAALZvS3YX7u6TFij7/BVdaHc/L8nz5hWfk2S/KzpvAAAAtn9LdTMGAACAdUmYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZHmAUAAGByhFkAAAAmR5gFAABgcoRZAAAAJkeYBQAAYHKEWQAAACZnTcJsVe1UVW+rqs9W1VlVdfequl5Vvb+qvjD+v+5a1A0AAID1b61aZl+S5N+7+9ZJ7pTkrCTPSvKB7t4zyQfG5wAAAPAzVj3MVtWOSe6V5DVJ0t0/6u5vJTkwyVHjaEcleehq1w0AAIBpWIuW2Zsl2ZjkdVX1yar6p6q6ZpIbdvfXkmT8f4M1qBsAAAATsBZhdockeyd5ZXfvleS72YIuxVV1WFWdUlWnbNy4caXqCAAAwDq2FmH2vCTndffJ4/O3ZQi3F1TVjZJk/H/hQhN395HdvU9377Nhw4ZVqTAAAADry6qH2e7+epJzq+pWY9F9k/x3kuOSHDqWHZrk2NWuGwAAANOwwxot9w+TvLGqrprknCSPzRCsj6mqxyX5apJHrlHdAAAAWOfWJMx296eS7LPAoPuudl0AAACYnrX6nVkAAADYasIsAAAAkyPMAgAAMDnCLAAAAJMjzAIAADA5wiwAAACTI8wCAAAwOcIsAAAAkyPMAgAAMDnCLAAAAJMjzAIAADA5wiwAAACTI8wCAAAwOcIsAAAAkyPMAgAAMDnCLAAAAJMjzAIAADA5wiwAAACTI8wCAAAwOcIsAAAAkyPMAgAAMDnCLAAAAJMjzAIAADA5wiwAAACTI8wCAAAwOcIsAAAAkyPMAgAAMDnCLAAAAJMjzAIAADA5wiwAAACTI8wCAAAwOcIsAAAAkyPMAgAAMDnCLAAAAJMjzAIAADA5wiwAAACTI8wCAAAwOcIsAAAAkyPMAgAAMDlrFmar6spV9cmqevf4/KZVdXJVfaGq3lpVV12rugEAALC+rWXL7FOSnDXz/G+SvKi790xyUZLHrUmtAAAAWPfWJMxW1W5Jfi3JP43PK8l9krxtHOWoJA9di7oBAACw/q1Vy+yLkzwjyWXj8+sn+VZ3Xzo+Py/JrmtRMQAAANa/VQ+zVfXgJBd296mzxQuM2otMf1hVnVJVp2zcuHFF6ggAAMD6thYts/dI8pCq+nKSt2ToXvziJDtV1Q7jOLslOX+hibv7yO7ep7v32bBhw2rUFwAAgHVm1cNsdz+7u3fr7j2SHJzkg93920k+lOQR42iHJjl2tesGAADANKyn35l9ZpI/rqqzM1xD+5o1rg8AAADr1A6bH2XldPeHk3x4fHxOkv3Wsj4AAABMw3pqmQUAAIBlEWYBAACYHGEWAACAyRFmAQAAmBxhFgAAgMkRZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyRFmAQAAmBxhFgAAgMkRZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyRFmAQAAmBxhFgAAgMkRZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyRFmAQAAmBxhFgAAgMkRZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyRFmAQAAmBxhFgAAgMkRZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyYIpY0sAABpeSURBVBFmAQAAmBxhFgAAgMkRZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyRFmAQAAmJxVD7NVtXtVfaiqzqqqM6vqKWP59arq/VX1hfH/dVe7bgAAAEzDWrTMXprkad19myR3S/Lkqrptkmcl+UB375nkA+NzAAAA+BmrHma7+2vdfdr4+JIkZyXZNcmBSY4aRzsqyUNXu24AAABMw5peM1tVeyTZK8nJSW7Y3V9LhsCb5AaLTHNYVZ1SVads3LhxtaoKAADAOrJmYbaqrpXkX5P8n+7+9nKn6+4ju3uf7t5nw4YNK1dBAAAA1q01CbNVdZUMQfaN3f32sfiCqrrROPxGSS5ci7oBAACw/q3F3YwryWuSnNXdfz8z6Lgkh46PD01y7GrXDQAAgGnYYQ2WeY8kv5PkjKr61Fj2J0men+SYqnpckq8meeQa1A0AAIAJWPUw290fSVKLDL7vatYFAACAaVrTuxkDAADA1hBmAQAAmBxhFgAAgMkRZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyRFmAQAAmBxhFgAAgMkRZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyRFmAQAAmBxhFgAAgMkRZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyRFmAQAAmBxhFgAAgMkRZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyRFmAQAAmBxhFgAAgMkRZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyRFmAQAAmBxhFgAAgMkRZgEAAJgcYRYAAIDJEWYBAACYHGEWAACAyRFmAQAAmBxhFgAAgMlZd2G2qh5YVZ+rqrOr6llrXR8AAADWn3UVZqvqyklenuRBSW6b5JCquu3a1goAAID1Zl2F2ST7JTm7u8/p7h8leUuSA9e4TgAAAKwz6y3M7prk3Jnn541lAAAA8FPV3Wtdh5+qqkcm+ZXufvz4/HeS7NfdfzgzzmFJDhuf3irJ51a9olfMzkm+sdaV2M5ZxyvPOl4d1vPKs45XnnW8OqznlWcdrzzreOVNcR3fpLs3LDRgh9WuyWacl2T3mee7JTl/doTuPjLJkatZqW2pqk7p7n3Wuh7bM+t45VnHq8N6XnnW8cqzjleH9bzyrOOVZx2vvO1tHa+3bsafSLJnVd20qq6a5OAkx61xnQAAAFhn1lXLbHdfWlV/kOR9Sa6c5LXdfeYaVwsAAIB1Zl2F2STp7vckec9a12MFTbaL9IRYxyvPOl4d1vPKs45XnnW8OqznlWcdrzzreOVtV+t4Xd0ACgAAAJZjvV0zCwAAAJslzC6iqr4z/r9lVb2nqs6uqrOq6piquuEi0zy1qn5QVdfZiuV9uKq2mzuLLWRunc48f0xVvWx8fHhVPX3e8C9X1c4LzOfLVXVGVX26qo6vql/cRvVbcHnrVVU9rKq6qm49U7Z/Vb17GdP+dN0vMc4eVfWZBcqvVFUvrarPjO/DJ6rqplv3KrbcQtvKWhvfhxfOPH96VR2+wHiPqaqNVfWpqvrvqnrCqlZ0wqrqJ+N6O3P87P9xVV1p3jgvqar/mV8+M3z/8b163EzZXmPZ08fnf1FV9xsf/3S/PLX9w5aY3TdX1a9W1Req6sYzZZ+uqjcvMf3h43r/1LhfeMhmlnf4zPp+fVU9YlvVf72pqhtW1Zuq6pyqOrWqPlZVDxuHLbi/Xs52uor1X/J7ej2a2Vd8pqreVVU7zRu+5LHaYt99m1nmZrfj2X3LVIzb3Btmnu8wfoe9e954x1bVx5Yxv2WNt1q2xf5nG9ThOeP32unjdnvXsfyqVfXiqvriuE8+tqp2W2Qel/t+Ws6xYFXduap+ddu+mrUhzC6hqq6e5N+SvLK7b9Hdt0nyyiQL/s5RkkMy3JH5YYvMb0WuUa6qK6/EfNe5A7r7TklOSfIna12ZNXJIko9kuOv3ajooyS5J7tjdd8iwvX9rleuw3vwwyW8sM+y8tbvvnGT/JH9Vi5wcW66V2q+sQ9/v7jt39+2S3D/JryZ53tzAMcA+LMm5Se61xHzOyLANzzk4yafnnnT3c7v7P65oZae4X66q+yb5hyQP7O6vjmW3yXCscK+quuYSk79o3K4fmeS1i51Q2AZ1nMz2XlWV5J1JTuzum3X3XTJsbwsekM6z5HbKkub2FbdP8s0kT543fMljtZWyrfYtq+y7SW5fVb8wPr9/kv+ZHWE8WbB3kp2WOrG93PG2RA0mm2Wq6u5JHpxk7+6+Y5L7ZfgOS5K/SnLtJLfs7j0z7EvePu5XtoU7Z/geXTUr9b042Q1glfxWko9197vmCrr7Q929UGvVzZNcK8mfZthRzpU/pqr+pareleT4sewZtall8fkzs3lkVX28qj5fVfccx71yVf1dDa1fp1fVE8fy/avqQ1X1pgxfej+vTkxyiySpqldW1SnjGa4/nxthPGP151V12rjebz2WX7+Glt1PVtU/Jqmx/C+r6ikz0x9RVX9UVdeqqg/MzOfA1X2pm1TVtZLcI8nj8rNhdseqekcNLX+vmtvRV9Vjx23rhHHauXld7sxkbb6V40ZJvtbdlyVJd5/X3ReN0y71HvxVDa0Sp1TV3lX1vvGM45PmXtNi63c8c/m5qvqPJLfa8jW24i7NcEOFpy53gu6+MMkXk9ykqq5XVe8cP+MnVdUdk2SJ8sOr6siqOj7J0TW0JPznuO5Oq6pfGsfbv4bWxbdV1Wer6o3b8ItwzYzr7rAkfzDzeg5I8pkMJxwPWWzaJF9NcvUaWswqyQOTvHdu4PzPw0Kq6lHjvvpTVfWPc1/QVfWdGlpfTk5y961+gWtg/M55dZJf6+4vzgz6rSRvyPD9tWSLa5J091kZPg87V9VNxs/06eP/Gy81bVU9d/yu+8y4fc/tkz887j9OSPKUGn6+72PjuH+5lS95NdwnyY+6+1VzBd39le7+h2VMu7nt9Anj6/90Vf1rVV1jLD+2qh49Pn7i+Jm/QVWdOpbdqYbWthuPz79YVdeoqg3jfD4x/t3jZ2o0TR9Lsuvck1rkWG0xS+xbq6peNn7P/luSG8xMc5eqOqGGlvj3VdWNxvKf7lsW29bXqfcm+bXx8SFJ5vfSeHiSdyV5S5Y+ub7geFV18/H77RPj/nOuZ+SCxwTje3JWVb0iyWlJfqeq/n4c9pSqOmdmvh8ZH6/X9X2jJN/o7h8mSXd/o7vPHz/Pj03y1O7+yTjsdRlOnN9nSxZQVdesqteOr/+TVXVgDT9/+hdJDhq/xw6q4bjiqBqOi79cVb9RVX87rvt/r6qrVNV9q+odM/O+f1W9fXz8gHG/fFoNuedaY/mXx/X/kQwnO7c5YXZpt09y6jLHnfuA/2eSW1XVDWaG3T3Jod19n6p6UJKHJrnr2LL4tzPj7dDd+yX5P9nU4vC4JBd3975J9k3yhNp0Rmu/JM/p7ttuxWtbC78wfmg+VVWfyvBBmvXUecN3WcY8H5xNYf45449A3zHJvWs88B99o7v3znCgO9dN6nlJPtLde2X4PeO5A63XJDk0+Wlrz8FJ3pjkB0keNs7ngCQvXMMd4kOT/Ht3fz7JN6tq75lh+yV5WpI7JLl5hhbDGyX58wwh9v5Jrsg2c0ySXx/fpxdW1V4zw5Z6D87t7rtn+Iy8Pskjktwtm7aDBddvVc21ZuyV5DcyfA7Wo5cn+e1a5mUGVXWzJDdLcnaG9+aT45nZP0ly9DjaYuVJcpckB3b3byW5MMn9x3V3UJKXzoy3V4Z9ym3H5W0XB6ndfU6G77C5fe3cPvgdSR5cVVdZYvK3ZfhS/aUMB0M/XO5ya2ipPCjJPcaWyJ8k+e1x8DWTfKa779rdH9mCl7PWrpbk2CQP7e7Pzht2UJK3Zli3yzn4v2uSy5JsTPKyJEeP2+8bc/ntciEv6+59xxa1X8iwf5+zU3ffu7tfmOQlGXpM7Zvk65t9dWvndhm2r6211Hb69nFd3SnJWRmOFZLhJM9zazg58bQkfzie/Ll6Ve2Y5J4ZejTds6pukuTC7v5ehnX6onGdPjzJP12Beq8LNZxkum+G7/c5Sx2rLWSxfevDMpxYvUOSJ2R4jzLud/4hySPGlvjXJjligfkuta2vN29JcnANvRXvmOTkecPn1unm9hGLjfeSJC8Zt73zZ8qXOua6VYZ9y14Zfs7znmP5PZP8b1XtmuSXM7zPyfpd38cn2b2GhoZXVNW9x/JbJPlqd3973vinZNivLORDM8fPs5/f5yT54Lh+D0jyd0mukuS5GXuKdfdbx3FvnuHExYFJ/jnJh8YeeN8fyz+Y5DZVNddD9bFJXldDr7Q/TXK/8f06Jckfz9ThB939y939luWumC0hzG47Byd5y9ha9fZc/uzD+7v7m+Pj+yV53fjlkZnyjNMlQ4DeY3z8gCSPHjfOk5NcP8me47CPd/eXtvULWUFzXX/uPB4EPnfe8BfNG37+AvOY86FxneyY5K/Hst+sqtOSfDLDh302sC20bu+V4cOa7v63JBeNj7+cYWe4V4b1/8nu/t8MLbd/VVWnJ/mPDGd7r1AX0SvgkAxfMBn/z34xfLy7zxnP5r05ww79rkk+3N0bu/tHGQ5Ot0p3n5fhi+TZGQ5aP1BD98Rk6fdg7oDijCQnd/cl3b0xyQ9q6H602Pq9Z5J3dPf3xh377IHJujHW7egkf7SZUQ8at903J3niuA/45QytX+nuDya5/hiKFytPkuO6+/vj46skeXVVnZHkX3L59f7xsfX8siSfyqbtf3sw13J31Qzdpd45vg8nZ/jsLuaYDPvohVoZNue+GU4kfGJ8H++b4SRBMgTbf93C+a0HP07yX9kUiJIkVbVvko3d/ZUkH0iyd1Vdd5F5PHVcHy9IclAPP5Vw9yRvGoe/IcP2vJQDqurkcTu+Ty5/0Da7z7pHNr1vb8hEVNXLa2hJ/cQyJ1lqO719DS2GZ2Q4mXK7JOnuCzJ8t34oydNmjjH+K8N6u1eG7ov3yrBvnTvYv1+Sl43v4XEZevhceyte5nrwC+Pr+N8k10vy/plhSx2rLWSxfeu9kry5u3/S3ednOMhPhu/G2yd5/1iHP83C3cqX2tbXle4+PcP3xiGZ99OZNVwmc4sMDQOfT3JpVd1+/jw2M97dM6zbZNP+Iln6mOsr3X3SWL+vJ7nWuL3uPs5j/va9Ltd3d38nw/fJYRlOAL61qh6T4bUv9HMzi5Unw+V3c8fPj58pf0CSZ43b44eTXD2bGm/me293/zjDcdqVk/z7WH5Gkj3G/fobkjxqPG67e4aW+7tl+Gx8dFzOoUluMjPfrT7mXI7JXHuyRs5Mcu/NjTS2Pu2ZYeeVJFdNck6GlppkuObgp6Nn8Q1x7qzrT7LpvakMZ1bfN2+Z+8+b78+bA7r7G3NPxtbqpyfZt7svqqrXZ/jAzllo3SaLvxf/lOQxSX4xw5nVZDhg2JDkLt3946r68rxlrIqqun6GnfHtq6oz7HC6qp4xjjL/NfUi5XMuzXhiazzredXN1WHsEvPeJO+tqguSPLSGrj3LeQ8uy+VbGC7L8J4stX6n8htiL87QgvK6JcZ5a3f/wbyyhVr4e4ny5PKf/6cmuSDJnTK8lz+YGTa7rudv/5M1tmz/JEPLya8nuU6SM8Z98DWSfC/DPQ9+Rnd/vap+nKGXwlMytqosd9FJjuruZy8w7AdzXcIm5rIkv5nkP6rqT7r7r8byQ5LcevwsJsPJw8Va7V7U3S/YzHIW/RyPrT6vSLJPd59bww3UZvcf87/vprBPODPD+kqSdPeTxxaMU5Yz8Wa209dnaEn/9Hjwu//MsDtkCHKzvZv+M8PB/U0ytMI/M8M6nLtJzJWS3H3mBFmSZO06H10h3+/uO48n/t6d4ZrZly7jWG0hS+1bFwsbZ469kBa0jG19PTouw4mq/TM0qsw5KMl1k3xpXKc7Zjhh8Kfzpl/ueLOWOiaYvz/4WIZWws9l2NZ/N0PQetp6X9/jd8aHk3x4DNuHZgj3N6mqa3f3JTOj752hq/aWqCQP7+7PXa5wvNHUPHPdnS+rqh+P4TXZdJyWDMc378rwWfiX7r50PHZ8f3cv1jK/onlFy+zS3pTkl6pq7lqBVNUDq+oO88Y7JMnh3b3H+LdLkl3HLjzzHZ/kd2vT9S3X20wd3pfk9+a6zNVwd+WlbsLx82rHDB+Wi8czgA9axjQnZuweWEP379kWh3dkuEZp3wzvQTIcLF847lQPyOXPOq2mR2ToXnOTcXvbPcmXsqnVY78arim7UoYvkI9kaKnav4brhK+Sy5+N/nKGM4PJ0LVkqe6ZqeF6113Gx1fK0O3oK9m692DWYuv3xCQPq6pfGM+8/voWznfVjK0gx2ReC9cyzG6L+2foFv/tJcrnu042Xcf8OxlOcGy3xi5Or8rQdawz7IMfP7cPTnLTJA+Y288u4rlJnrkV4fMDSR5RY/fEGq5rXqt9wTYz9hZ6cIau8o8bP9uPzHCjt7n1emCW0dV4xn9l07Vxv51hX7SYuYPLb9RwrdVS1y1/dN5816sPZuje+3szZUttkwtZbDu9dpKvjfvzn66Dqtovw753ryRPr02XJZ2Y5FFJvjDuJ76ZoTfDR8fhxyf5g5n53HkL67nudPfFGXrKPH1cT1tyrDZnsX3riRm63l65/n979x4iZ3XGcfz7i0ovRPtXYkuQBtTYhhbXJooXkC7UVEGhUlITUps0fxVaYy+oCArR1NZStFhsipiEphAKlpBCoDRrNbrb1sXIJm7qtnUt0RYNRoRYDWlSkqd/PGfI28nuzE4ynUvy+/y1e97LnJl59933OZfn5DSewVL+N2COMrEPynmG9b2ArVzrvWIT8GBE1OdoWU4mjKvdI2rTguo12m+UE40+1WNbeeYaJhvTh8mRYYPAkXIN9OznLekySZdWigbIXudDwGbgUZ3IyfA18v7x7MlnamgHcEcJONGJqWHvk/eRlpSRCG+RDRG/KMWjwHWSajlsPippQavnPlUOZqegzJZ4pLRQ3kxeBJOSJsjeugN1hywjg5+qbUzxBx0RvyNbuF4qXfHN0txvACaAMWWq+Cc4Q3pW2ikiXiZvYK+QN90/Nj4CyPmI1yuHxS4hE27UzneUHKb1VOUhYguwWNJL5MND/dyyTlnOydfbVjJRC2QL5cNkMpx95BDd/cDasu33/O88rifJ+a0vksORm7WgzQW2l+txnOzZffwUv4OqKT/fiBgjh6jsKe9zZNoz9IZHgFaXcFlLvvdx8rtb2aS83npgpaRRYAFn5qiN2pz7V8hreAh4oASsX6TSC1seBP5Ag4aPiPhTRPym1UpExAT5T3yofC9Pk0k8+l5pjLmRfH+3AG9GRDVz6TCwsDy8z8Qa4Ovlc7qd7F2c7rUPkveivWTWzkZDce8EvqkcrtvyUnidUhpavkTeX/eVe+xmslcU8n95w/naDa7T+8lGyqcp90pJHyI/w9XlgfN7ZGZplekzkN8h5N/HwSjJ+8jvarEyWdcE8I2W33APiojdZBboZcz8Wa36vUx3b90GTJLX68+B58vrHSWDpR9Jepn8v1XtUY8Wr/WeUKaqPFYtkzSfHK46WtlvH/Cvaq/fDPb7NvDd8vfxCeC9slsrz1wj5BDj4fLM9k9K41mPf96zgc3KRGLj5FDdtWXbvWTv56uSJsnGxVsrvaUztY7spBgvz221pHk7yfv5Hkm3TXv01LaQeVAmACKnjK0CflXexyjwqekPby+1/pmc+SRdDjwZmYzJzkKlV2IMWBoRk92uj5mZnVmUWfPnRcTdTXe2jlFmzV0REV9p83m3A49GxM52nrfflQbJwxERkpYByyOia6tFWHPKtad3R8TGbtcF3MN3EuUyIWvIliI7C0laSM6z2eZA1szM2k3SRjJRUFsDJjs9kh4kh9OvavN5N5FDRPspy3mnLCKTj4lcs351l+tjDSiX+TpEjvzoCe6ZNTMzMzMzs77jObNmZmZmZmbWdxzMmpmZmZmZWd9xMGtmZmZmZmZ9x8GsmZlZiyQdK0sa/FnSrytrh3/Q4Xo8V5auqP2+WNJznayDmZlZtziYNTMza93hiBiIiM8AR+nAupxKU/3fnivppv/365uZmfUaB7NmZmanZwS4pFogabakZySNSdpb1q5E0rqyvmhtv4ckrSk/3yVpl6RxSQ+UsvmS/iJpPbn29UVTvP6PgfvqC8uxI6UOY5KuLeWfl/S8pKckvSrpYUkrJL1Y6npx2W+OpK2lTrskXdeWT8vMzKxNHMyamZmdIknnAjcBe+s2/Ru4NSI+BwwCj5R1FDcCK8uxs4BlwBZJS4BLgauAAWCRpOvLuS4DfhkRV0TEG1NU4wXgiKTBuvIDwA2lDrcBP61suxy4E/gscDuwICKuAjYAd5R9HgN+EhFXAl8u28zMzHrGud2ugJmZWR/6iKQ95ecRMkitEvCDEpAeB+YBF0bE65LelXQFcCGwOyLeLcHsEmB3OX42Gdz+A3gjIkab1Of7ZO/sPZWy84DHJQ0Ax4AFlW27ImI/gKS/A0OlfC8ZfAN8AViYMTgAF0g6PyLeb1IXMzOzjnAwa2Zm1rrDETHQYPsKYA6wKCL+I+l14MNl2wZgFfBxYFMpE/DDiHiiehJJ84FDzSoTEc9KWgdcXSn+DvA22Qs7i+wtrjlS+fl45ffjnHg2mAVcExGHm72+mZlZN3iYsZmZWft9DDhQAtlB4JOVbduAG4ErgR2lbAewWtJsAEnzJM1t8TUfAu6uq8P+iDhODiU+p8XzDQHfqv1SenjNzMx6hntmzczM2m8LsL0sm7MH+GttQ0QclbQTOBgRx0rZkKRPAy+UYb0fAF8lhwfPSET8VtI7laL1wFZJS4GdzKCHt84a4GeSxsnnhWE6kLXZzMxsphQR3a6DmZnZWaMkfhoDlkbEZLfrY2Zm1q88zNjMzKxDJC0EXgOecSBrZmZ2etwza2ZmZmZmZn3HPbNmZmZmZmbWdxzMmpmZmZmZWd9xMGtmZmZmZmZ9x8GsmZmZmZmZ9R0Hs2ZmZmZmZtZ3HMyamZmZmZlZ3/kvaCyjVet+ZWgAAAAASUVORK5CYII=\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "plt.figure(figsize=(16,8))\n", "sns.barplot(data=dubai_df_all,x='striker',y='SR')\n", "plt.title('Strike Rate in dubai(Minimum 100 Runs)')\n", "plt.xlabel('Player Name')\n", "plt.ylabel('Strike Rate')\n", "plt.show()" ] }, { "cell_type": "code", "execution_count": 150, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
yearInningsruns_off_batballSR
0201459059152.542373
1202012200172116.279070
\n", "
" ], "text/plain": [ " year Innings runs_off_bat ball SR\n", "0 2014 5 90 59 152.542373\n", "1 2020 12 200 172 116.279070" ] }, "execution_count": 150, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dubai_df" ] }, { "cell_type": "code", "execution_count": 153, "metadata": {}, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAEWCAYAAACJ0YulAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAeO0lEQVR4nO3de5hcVZnv8e+PcDvcBCQgSQhBDSAoBGlQB0EQZYBxuIwioGJQJHAGFUe8gKOAw0Q5I4gyXDQIQo6IoJHLOKjhRARUoiQxBjKJcpFLSEgCBJJwNcl7/lirdjZFdXd1p6t20vX7PE89vfda+/JW9a56a6+9ay1FBGZmZgDrVR2AmZmtPZwUzMys4KRgZmYFJwUzMys4KZiZWcFJwczMCk4K6yhJ35H0lTx9oKR5Vce0piTtL+nPA7StUZJC0voDuWw36y+X9PrS/CGSburHdn4uaexAL2sDR9JGkuZK2rbqWFrFSaECkt4p6XeSnpX0tKTfSton150o6Te9bSMiTo2I81oQW0h6Ln/QPS7pm5KGNLnuGiWniLgrInbp7/pViYjNIuKhUtHXgPNrM/k1XVhOOpLWl7RIUpS2c1hEXNPkPptetp0kbS/pFknz8/MeVVe/kaSrJC2V9ISkz9bVH5w/dJ+XdLukHXvY18OSXsjH6hOSrpa0WWueWRIRLwFXAV9s5X6q5KTQZpK2AH4G/CewNTAc+CrwUh+20dSH9BrYMyI2A94FHAt8vMX7GzRycn9NREytq3oGOKw0fziwpG2Btc8q4BfA+7upPxcYDewIHAR8QdKhAJK2AX4KfIX03pgGXN/L/v4xH6tjgL2As9Yw/mb8EBgraaM27Kv9IsKPNj6ALuCZbureBLwIrASW15YDrgYuB24FngPek8v+PdcfCMwrbefTwP8AI/L8+4CZpA+m3wF79BBfAG8szd8AXFqa/xgwB1gGPASckss3BV4gfSgsz49hpC8eZwIPAk/l7W3dzb7rn8fDwOeAWcCzpA+IjbtZdwhwAfBkjuu0/FzWL23rPaXlzwV+kKdH5WXHAfOBBcAZpWX3Be7Or98C4BJgw0avGXA28L0Gr+mXgR+Xyn4C/Gt6CxZlvwY+kadPBH6Tn9MS4K/AYT0s+1vgohzjQ8Df5fLHgEXA2EbrlvdVF+8/A/fn//N5wBvya7A0/w83rP8f1D3n9fN2RtWVPw4cUpo/D/hRnh4H/K5UVzumdu1mH/X/0/8A/ruPz/PU/DyXAJcCynVvBO4gHXdPAtfX7ft+4F1Vf5604uEzhfb7C7BS0jWSDpO0Va0iIuaQDtK7IzVJbFla70PAeGBz0odFQ/k6w4mkA3aepLeSTndPAV4LfBe4pZlvOZJ2BfYHHigVLyIlmS1ICeIiSW+NiOdI34Tn59g3i4j5pAR1FOmsYxir33zN+iBwKLATsEd+bo2cnOPai5R4P9CHfdQcRPoWewhwpqT35PKVwL8A2wDvAA4mfWg28hag0XWRm4ADJG0paUvS63pzL/G8LW9rG9IH3pWS1MOys0j/4x8CPwL2IX24fQS4pI9NK4cCewNvB74ATAA+DOwAvBk4vg/bAiAf68OAP5WK/wTsnqd3L9flY+rBUn1P2x5BOv4e6G3ZOu8jvU57ko61v8/l5wGTga2AEaQz+7I5eZ1Bx0mhzSJiKfBO0reUK4DFuQ12u15WvTkifhsRqyLixQb1kvRN0kF9UEQszuUnA9+NiN9HxMpI7dAvkd7s3Zkh6TnSgf9r4LJS/P8dEQ9GcgfpjbN/D9s6BfjXiJgXqT32XOADfbioe3FEzI+Ip4H/IjUTNPJB4FsR8Vhe9utNbr/sqxHxXETcC3yf/MEXEdMjYmpErIiIh0mJ9V3dbGNL0rfrei/m+I8FjgNuyWU9eSQiroiIlcA1wPZAd8fJXyPi+3nZ60kf3v8WES9FxGTgZVKCaNb/iYilETEbuA+YHBEPRcSzwM9Jybevaknp2VLZs6QvOrX6Z3mlcn0jN0laxuozonP6GNP5EfFMRDwK3M7q4+tvpCauYRHxYkTUfxFbRvpfDzpOChWIiDkRcWJEjCB96xoGfKuX1R7rpX5L0un31/Mbt2ZH4AxJz9QepA+MYT1s662kN+ixpG+gm9Yq8tnN1HyB/BlS2/g2PWxrR+DG0r7nkL5595YEa54oTT/P6g+WesN45Wv0SJPbL6tffxiApJ0l/SxfzFxKupDc3XNeQvcfYhOBj+bHxCbiKZ57RDyfJ7t7/gtL0y/kderL+nKmUL/ummyrZnn+u0WpbAtWJ9HldXX19Y0cFRGbk5oed6XnY7GR7o6vLwAC/iBptqT662qbk5rqBh0nhYpFxFzS9YE314q6W7SXTS0hnQp/X9J+pfLHgPERsWXpsUlEXNdLXBERN5Dakc+GdOcIMInUzr1dbt66lfTm6S7Gx0ht4eX9bxwRj/fyfPpqASnZ1Yysq38O2KQ0/7oG26hff36evhyYC4yOiC2AL7H6OdebBezcTd1drP623+sdZi3UzGsx4CJiCen/VG522ROYnadnl+skbUq6ljGbXuSz1qtJx2ZNv59nRDwRESdHxDDS2e5lkspnWm/ilc1gg4aTQptJ2lXSGbkNFEk7kJopanerLARGSNqwr9uOiF+T2n1vlPS2XHwFcKqktynZVNI/SOrplLzsfGCcpNcBGwIbAYuBFZIOI7W/1ywEXivpNaWy7wDja7cWShoq6ci+Prcm3AB8WtKI3HZ9Zl39TOA4SRtI6u6aw1ckbSJpd9L1ktqdL5uTLrAuz9dZ/ncPcdxKN01LERHAPwJH5OmqzAT+KT/XNwInDeTGJW1MOk4ANsrzNROBL0vaKr+WJ5M+zAFuBN4s6f15nbOBWfmLUzO+BbxXUq0JqN/PU9Ixtfco6QtXkM5wkTScdHdU/R1mg4KTQvstIzXJ/D63208ltdmeket/Rfpm9ISkJ/u68Yi4jfSBdoukvSNiGumNdwnp4H6A7i/WNtrevaS7MD4fEctIF45vyNv6EKltvLbsXOA64KHcXDQM+HZeZnJu+52an/9AuwL4Jenb2wzSrY1lXyF961xCugX4hw22cQfp9ZkCXJDb4iHdAfUh0v/uCnq4TTIiZgDPlpJyff3s3E5fpYtI1xgWkq5VXDvA23+B1U1Fc/N8zTmki8ePkF7vb0TELwDydbD3k26oWEI6To5rdqd5/Ymk/zWs2fPch/QeXU46fk+PiL/mug8B1+RrZIOOqv3CYjb4SDoE+OeIOKrqWGxg5SbUPwEHRMSiquNpBScFMzMruPnIzMwKTgpmZlZwUjAzs0K/ugpeW2yzzTYxatSoqsMwM1unTJ8+/cmIGNqobp1OCqNGjWLatGlVh2Fmtk6R1O0v/t18ZGZmBScFMzMrOCmYmVnBScHMzApOCmZmVnBSMDOzQsuSgqQdJN0uaU4epOL0XL61pNsk3Z//bpXLJeliSQ9ImpWHkTQzszZq5ZnCCtLg528iDf14mqTdSP3cT4mI0aQuimv93h9GGh93NGkEsctbGJuZmTXQsqQQEQty3/LkfvjnAMOBI0l9m5P/1roXPhKYmEf8mgpsKWn7VsVnZmav1pZfNEsaRRro+/ekYRwXQEockrbNiw3nlWPkzstlC+q2NY50JsHIkfUjLpoNHo/+21uqDsHWQiPPvrel22/5hWZJm5HG9f1MRCztadEGZa8a7CEiJkREV0R0DR3asOsOMzPrp5YmBUkbkBLCtRFRGx5xYa1ZKP+tjV40j1cOnD6C1QOnm5lZG7Ty7iMBVwJzIuKbpapbgLF5eixwc6n8o/kupLcDz9aamczMrD1aeU1hP+AE4F5JM3PZl4DzgRsknQQ8ChyT624FDicNnP48afB5MzNro5YlhYj4DY2vEwAc3GD5AE5rVTxmZtY7/6LZzMwKTgpmZlZwUjAzs4KTgpmZFZwUzMys4KRgZmYFJwUzMys4KZiZWcFJwczMCk4KZmZWcFIwM7OCk4KZmRWcFMzMrOCkYGZmBScFMzMrOCmYmVmhlcNxXiVpkaT7SmXXS5qZHw/XRmSTNErSC6W677QqLjMz614rh+O8GrgEmFgriIhja9OSLgSeLS3/YESMaWE8ZmbWi1YOx3mnpFGN6iQJ+CDw7lbt38zM+q6qawr7Awsj4v5S2U6S/ijpDkn7VxSXmVlHa2XzUU+OB64rzS8ARkbEU5L2Bm6StHtELK1fUdI4YBzAyJEj2xKsmVmnaPuZgqT1gX8Crq+VRcRLEfFUnp4OPAjs3Gj9iJgQEV0R0TV06NB2hGxm1jGqaD56DzA3IubVCiQNlTQkT78eGA08VEFsZmYdrZW3pF4H3A3sImmepJNy1XG8sukI4ABglqQ/AT8BTo2Ip1sVm5mZNdbKu4+O76b8xAZlk4BJrYrFzMya4180m5lZwUnBzMwKTgpmZlZwUjAzs4KTgpmZFZwUzMys4KRgZmYFJwUzMys4KZiZWcFJwczMCk4KZmZWcFIwM7OCk4KZmRWcFMzMrOCkYGZmBScFMzMrOCmYmVmhlcNxXiVpkaT7SmXnSnpc0sz8OLxUd5akByT9WdLftyouMzPrXivPFK4GDm1QflFEjMmPWwEk7UYau3n3vM5lkoa0MDYzM2ugZUkhIu4Enm5y8SOBH0XESxHxV+ABYN9WxWZmZo1VcU3hk5Jm5ealrXLZcOCx0jLzctmrSBonaZqkaYsXL251rGZmHaXdSeFy4A3AGGABcGEuV4Nlo9EGImJCRHRFRNfQoUNbE6WZWYdqa1KIiIURsTIiVgFXsLqJaB6wQ2nREcD8dsZmZmZtTgqSti/NHg3U7ky6BThO0kaSdgJGA39oZ2xmZgbrt2rDkq4DDgS2kTQPOAc4UNIYUtPQw8ApABExW9INwP8AK4DTImJlq2IzM7PGWpYUIuL4BsVX9rD8eGB8q+IxM7Pe+RfNZmZWcFIwM7OCk4KZmRWcFMzMrOCkYGZmBScFMzMrOCmYmVnBScHMzApOCmZmVnBSMDOzgpOCmZkVnBTMzKzgpGBmZgUnBTMzKzgpmJlZodekoOQjks7O8yMl7dvbemZmtu5p5kzhMuAdQG3QnGXApS2LyMzMKtNMUnhbRJwGvAgQEUuADXtbSdJVkhZJuq9U9g1JcyXNknSjpC1z+ShJL0iamR/f6efzMTOzNdBMUvibpCGkcZWRNBRY1cR6VwOH1pXdBrw5IvYA/gKcVap7MCLG5MepTWzfzMwGWDNJ4WLgRmBbSeOB3wBf722liLgTeLqubHJErMizU4ERfQvXzMxaaf3eFoiIayVNBw4GBBwVEXMGYN8fB64vze8k6Y/AUuDLEXFXo5UkjQPGAYwcOXIAwjAzs5pek4Kk/xsRJwBzG5T1i6R/BVYA1+aiBcDIiHhK0t7ATZJ2j4il9etGxARgAkBXV1f0NwYzM3u1ZpqPdi/P5OsLe/d3h5LGAu8DPhwRARARL0XEU3l6OvAgsHN/92FmZv3TbVKQdJakZcAekpZKWpbnFwE392dnkg4FvggcERHPl8qH5mSDpNcDo4GH+rMPMzPrv26TQkR8PSI2B74REVtExOb58dqIOKu79WokXQfcDewiaZ6kk4BLgM2B2+puPT0AmCXpT8BPgFMj4umGGzYzs5Zp5kLzWZK2In1737hUfmcv6x3foPjKbpadBEzqLRYzM2utZi40fwI4nXT76Ezg7aQzgHe3NjQzM2u3Zi40nw7sAzwSEQcBewGLWxqVmZlVopmk8GJEvAggaaOImAvs0tqwzMysCr02HwHzch9FN5EuEC8B5rc2LDMzq0IzF5qPzpPnSrodeA3w85ZGZWZmlejTIDsRcQdwJ/CF1oRjZmZV6unHaztImiDpZ5I+IWkTSReSejfdtn0hmplZu/TUfDQRuIP0+4FDSb2azgb2iIgn2hCbmZm1WU9JYeuIODdP/1LSQmCfiHip9WGZmVkVerzQnH/JrDz7BLCJpE0B3A2Fmdng01NSeA0wndVJAWBG/hvA61sVlJmZVaPbpBARo9oYh5mZrQX6dEuqmZkNbk4KZmZWcFIwM7NCU0lB0jslfSxPD5W0U2vDMjOzKvSaFCSdQxpCszba2gbAD1oZlJmZVaOZM4WjgSOA5wAiYj5pSM1eSbpK0iJJ95XKtpZ0m6T789+tcrkkXSzpAUmzJL2170/HzMzWRDNJ4eWICNJvE6j9eK1JV5O6yCg7E5gSEaOBKXke4DDSkJ+jgXHA5X3Yj5mZDYBmksINkr4LbCnpZOD/Ad9rZuN5HOf6Xz4fCVyTp68BjiqVT4xkat7f9s3sx8zMBkYz4ylcIOm9wFLSiGtnR8Rta7DP7SJiQd72Akm1HleHA4+VlpuXyxaUV5Y0jnQmwciRI9cgDDMzq9drUpB0WET8HLitVHZqRHxngGNRg7J4VUHEBGACQFdX16vqzcys/5ppPvqKpHfXZiR9kdTU018La81C+e+iXD4P2KG03Ag87KeZWVs1kxSOAL4maX9J44F9c1l/3QKMzdNjgZtL5R/NdyG9HXi21sxkZmbt0cw1hSclHUG6wDwd+EC+G6lXkq4DDgS2kTQPOAc4n3Tx+iTgUeCYvPitwOHAA8DzwMf69lTMzGxNdZsUJC0jtekr/92Q1F32ByRFRGzR28Yj4vhuqg5usGwApzUTtJmZtUZPXWc39QM1MzMbPHo6U9g1IuZ298viiJjRqNzMzNZdPV1T+Czp9wAXNqgL4N0Nys3MbB3WU/PROEnrAV+OiN+2MSYzM6tIj7ekRsQq4II2xWJmZhXr9ZZUYLKk9wM/bfZW1HXJ3p+fWHUIthaa/o2PVh2CWSWaSQqfBTYFVkh6kXyLajO3pJqZ2bqlmR+v+dZUM7MO0czIa1OaKTMzs3VfT79T2BjYhNRFxVas7sV0C2BYG2IzM7M266n56BTgM6QEMJ3VSWEpcGmL4zIzswr09DuFbwPflvSpiPjPNsZkZmYV6faagqR9JL2ulhAkfVTSzZIulrR1+0I0M7N26elC83eBlwEkHUDq8noi8Cx55DMzMxtcerqmMCQins7TxwITImISMEnSzNaHZmZm7dbTmcIQSbWkcTDwq1JdMz96MzOzdUxPH+7XAXdIehJ4AbgLQNIbSU1IZmY2yPR099H4/CO17YHJpX6P1gM+1d8dStoFuL5U9HrgbGBL4GRgcS7/UkTc2t/9mJlZ3/XYDBQRUxuU/WVNdhgRfwbGAEgaAjwO3Egak/miiHCvrGZmFem1m4sWOxh4MCIeqTgOMzOj+qRwHOnaRc0nJc2SdFXuWuNVJI2TNE3StMWLFzdaxMzM+qmypCBpQ+AI4Me56HLgDaSmpQU0HgaUiJgQEV0R0TV06NC2xGpm1imqPFM4DJgREQsBImJhRKzMo71dAexbYWxmZh2pyqRwPKWmI0nbl+qOBu5re0RmZh2ukh+hSdoEeC+pJ9aa/5A0Bgjg4bo6MzNrg0qSQkQ8D7y2ruyEKmIxM7PVqr77yMzM1iJOCmZmVnBSMDOzgpOCmZkVnBTMzKzgpGBmZgUnBTMzKzgpmJlZwUnBzMwKTgpmZlZwUjAzs4KTgpmZFZwUzMys4KRgZmYFJwUzMys4KZiZWcFJwczMCpWMvAYg6WFgGbASWBERXZK2Bq4HRpGG5PxgRCypKkYzs05T9ZnCQRExJiK68vyZwJSIGA1MyfNmZtYmVSeFekcC1+Tpa4CjKozFzKzjVJkUApgsabqkcblsu4hYAJD/blu/kqRxkqZJmrZ48eI2hmtmNvhVdk0B2C8i5kvaFrhN0txmVoqICcAEgK6urmhlgGZmnaayM4WImJ//LgJuBPYFFkraHiD/XVRVfGZmnaiSpCBpU0mb16aBQ4D7gFuAsXmxscDNVcRnZtapqmo+2g64UVIthh9GxC8k3QPcIOkk4FHgmIriMzPrSJUkhYh4CNizQflTwMHtj8jMzGDtuyXVzMwq5KRgZmYFJwUzMys4KZiZWcFJwczMCk4KZmZWcFIwM7OCk4KZmRWcFMzMrOCkYGZmBScFMzMrOCmYmVnBScHMzApOCmZmVnBSMDOzgpOCmZkVnBTMzKzQ9qQgaQdJt0uaI2m2pNNz+bmSHpc0Mz8Ob3dsZmadrorhOFcAZ0TEDEmbA9Ml3ZbrLoqICyqIyczMqCApRMQCYEGeXiZpDjC83XGYmdmrVXpNQdIoYC/g97nok5JmSbpK0lbdrDNO0jRJ0xYvXtymSM3MOkNlSUHSZsAk4DMRsRS4HHgDMIZ0JnFho/UiYkJEdEVE19ChQ9sWr5lZJ6gkKUjagJQQro2InwJExMKIWBkRq4ArgH2riM3MrJNVcfeRgCuBORHxzVL59qXFjgbua3dsZmadroq7j/YDTgDulTQzl30JOF7SGCCAh4FTKojNzKyjVXH30W8ANai6td2xmJnZK/kXzWZmVnBSMDOzgpOCmZkVnBTMzKzgpGBmZgUnBTMzKzgpmJlZwUnBzMwKTgpmZlZwUjAzs4KTgpmZFZwUzMys4KRgZmYFJwUzMys4KZiZWcFJwczMCk4KZmZWWOuSgqRDJf1Z0gOSzqw6HjOzTrJWJQVJQ4BLgcOA3UjjNu9WbVRmZp1jrUoKwL7AAxHxUES8DPwIOLLimMzMOsb6VQdQZzjwWGl+HvC28gKSxgHj8uxySX9uU2ydYBvgyaqDWBvogrFVh2Cv5GOz5hwNxFZ27K5ibUsKjZ5tvGImYgIwoT3hdBZJ0yKiq+o4zOr52Gyfta35aB6wQ2l+BDC/oljMzDrO2pYU7gFGS9pJ0obAccAtFcdkZtYx1qrmo4hYIemTwC+BIcBVETG74rA6iZvlbG3lY7NNFBG9L2VmZh1hbWs+MjOzCjkpmJlZwUlhEJO0g6TbJc2RNFvS6bl8a0m3Sbo//90ql+8q6W5JL0n6XIPtDZH0R0k/a/dzscGnH8fnhyXNyo/fSdqztC13jzNAnBQGtxXAGRHxJuDtwGm525AzgSkRMRqYkucBngY+DVzQzfZOB+a0NmTrIH09Pv8KvCsi9gDOI198dvc4A8tJYRCLiAURMSNPLyN9oA8ndR1yTV7sGuCovMyiiLgH+Fv9tiSNAP4B+F4bQrcO0I/j83cRsSSXTyX9jgncPc6AclLoEJJGAXsBvwe2i4gFkN6YwLZNbOJbwBeAVS0K0TpYP47Pk4Cf5+lG3eMMb1Wsg52TQgeQtBkwCfhMRCztx/rvAxZFxPQBD846Xl+PT0kHkZLCF2tFDRbzvfb95KQwyEnagPSGuzYifpqLF0raPtdvDyzqZTP7AUdIeph0av5uST9oUcjWQfp6fErag9SEeWREPJWL3T3OAHJSGMQkCbgSmBMR3yxV3QLUugEdC9zc03Yi4qyIGBERo0hdj/wqIj7SgpCtg/T1+JQ0EvgpcEJE/KW0vLvHGUD+RfMgJumdwF3Avay+FvAlUrvtDcBI4FHgmIh4WtLrgGnAFnn55cBu5VN6SQcCn4uI97Xredjg1I/j83vA+4FH8rIraj2nSjqcdN2r1j3O+LY9kUHGScHMzApuPjIzs4KTgpmZFZwUzMys4KRgZmYFJwUzMys4KdigJmmlpJmS7pP0Y0mb5PLlbY7j15Kmlea7JP26nTGYNcNJwQa7FyJiTES8GXgZOLXVO1TS6L21raTDWr1/szXhpGCd5C7gjeUCSZtJmiJphqR7JR2Zy8+r9e+f58dL+nSe/ryke3K//l/NZaPyuACXATN4ZbcLNd8AvlxfmNe9K8cwQ9Lf5fIDJd0h6QZJf5F0fh5T4A851jfk5YZKmpRjukfSfgPyallHclKwjiBpfVJ/+/fWVb0IHB0RbwUOAi4sdb8wNq+7HqnrhGslHQKMJnXXPAbYW9IBeVu7ABMjYq+IeIRXuxt4KXfoVrYIeG+O4Vjg4lLdnqRxLN4CnADsHBH7kvr/+VRe5tvARRGxD+kXv+7e3Ppt/aoDMGux/yVpZp6+i/RhXybga/mDfRWpy+XtIuJhSU9J2gvYDvhjRDyVk8IhwB/z+puRksSjwCMRMbWXeP6ddLbwxVLZBsAlksYAK4GdS3X31LqRlvQgMDmX30tKYgDvAXZLuQyALSRtnscoMOsTJwUb7F6IiDE91H8YGArsHRF/yz3BbpzrvgecCLwOuCqXCfh6RHy3vJE8HsBzvQUTEb+SdB5ppLGafwEWks4K1iOdvdS8VJpeVZpfxer373rAOyLihd72b9YbNx9Zp3sNaayIv+VmnR1LdTcChwL7AL/MZb8EPp7HAEDScEnNDFJUNp40YFE5hgURsYrURDSkj9ubDHyyNpPPOMz6xWcK1umuBf4r3y46E5hbq4iIlyXdDjwTEStz2WRJbwLuzs01y4GPkJp9mhIRt0paXCq6DJgk6Rjgdpo446jzaeBSSbNI7+k7acNdVjY4uZdUs27kC8wzSF033191PGbt4OYjswYk7QY8AExxQrBO4jMFMzMr+EzBzMwKTgpmZlZwUjAzs4KTgpmZFZwUzMys8P8Bjv8T/YB7zuAAAAAASUVORK5CYII=\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "sns.barplot(data=dubai_df,x='year',y='runs_off_bat')\n", "plt.title('Strike Rate in dubai(Minimum 100 Runs)')\n", "plt.xlabel('Player Name')\n", "plt.ylabel('Strike Rate')\n", "plt.show()" ] }, { "cell_type": "code", "execution_count": 158, "metadata": {}, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAEWCAYAAACJ0YulAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAgAElEQVR4nO3de5wU1Zn/8c+XuxgQBIzgoGBARRBRUTQxBjUYNS4adRXXrLgaiTGuJq5R/LlRk6yrxiRG4yXBaMTEwLoxCustEjHeiY6oBERFBWUABbnI/TLw/P6omrYZe2Z6mO6eC9/369WvqT5Vdeo505en61TVKUUEZmZmAK0aOwAzM2s6nBTMzCzDScHMzDKcFMzMLMNJwczMMpwUzMwsw0mhmZL0a0k/TKeHS6po7JgaStKXJb1VoLr6SApJbQq5bA3rr5a0Z9bzYyQ9tA31PCZpdKGXtcKR1F7Sm5J2aexYisVJoRFIOlzSC5I+kbRM0vOSDk7nnS3pubrqiIjzI+InRYgtJK1Jv+gWSPqFpNZ5rtug5BQRz0bE3tu6fmOJiM9FxHtZRf8NXF/1JP2ffpSddCS1kbRYUmTVc1xEjM9zm3kvW0qSekqaLGlh2u4+1ea3l3S3pJWSPpR0SbX5R6dfumslPSVpj1q2NU/SuvS9+qGkeyR9rjgtS0TEBuBu4PJibqcxOSmUmKTOwMPAr4Cdgd2AHwEb6lFHXl/SDbB/RHwO+ApwOnBOkbfXYqTJfaeImFZt1grguKznxwPLSxZY6WwBHgdOqWH+NUB/YA/gSOAySccCSOoO/Bn4Iclnoxz4nzq290/pe3UIcABwRQPjz8cfgdGS2pdgW6UXEX6U8AEMBVbUMG8AsB7YDKyuWg64B7gDeBRYA3w1LfuvdP5woCKrnouAN4Cy9PkJwGskX0wvAINriS+AflnP7wduy3r+b8BsYBXwHvDttHxHYB3Jl8Lq9NGL5IfHWOBdYGla3841bLt6O+YBlwIzgE9IviA61LBua+BnwMdpXN9N29Imq66vZi1/DfCHdLpPuuwYYCGwCPiPrGUPAV5M/3+LgFuBdrn+Z8BVwG9z/E//E/jfrLI/AVcmH8FM2d+Ab6XTZwPPpW1aDswFjqtl2eeBm9IY3wO+mJbPBxYDo3Otm72tavFeAMxJX+efAF9I/wcr09ewXfXXoFqb26T19KlWvgA4Juv5T4CJ6fQY4IWseVXvqX1q2Eb11/SnwCP1bOf5aTuXA7cBSuf1A54med99DPxPtW3PAb7S2N8nxXh4T6H03gY2Sxov6ThJXatmRMRskjfpi5F0SXTJWu9fgGuBTiRfFjmlxxnOJnnDVkg6kGR399tAN+A3wOR8fuVI2gf4MvBOVvFikiTTmSRB3CTpwIhYQ/JLeGEa++ciYiFJgjqJZK+jF59++PJ1GnAs0BcYnLYtl/PSuA4gSbyn1mMbVY4k+RV7DDBW0lfT8s3A94HuwGHA0SRfmrnsB+Q6LvIQcISkLpK6kPxfJ9URz7C0ru4kX3h3SVIty84geY3/CEwEDib5cvsmcGs9u1aOBQ4CDgUuA8YBZwK9gUHAGfWoC4D0vd4LeD2r+HVgYDo9MHte+p56N2t+bXWXkbz/3qlr2WpOIPk/7U/yXvtaWv4T4AmgK1BGsmefbXa6TovjpFBiEbESOJzkV8qdwJK0D/bzdaw6KSKej4gtEbE+x3xJ+gXJm/rIiFiSlp8H/CYi/h4RmyPph95A8mGvyXRJa0je+H8Dbs+K/5GIeDcST5N8cL5cS13fBq6MiIpI+mOvAU6tx0HdWyJiYUQsA/6PpJsgl9OAX0bE/HTZ6/KsP9uPImJNRPwD+B3pF19EvBIR0yKiMiLmkSTWr9RQRxeSX9fVrU/jPx0YBUxOy2rzfkTcGRGbgfFAT6Cm98nciPhduuz/kHx5/zgiNkTEE8BGkgSRrxsiYmVEzAJmAk9ExHsR8QnwGEnyra+qpPRJVtknJD90quZ/wtay5+fykKRVfLpHdHU9Y7o+IlZExAfAU3z6/tpE0sXVKyLWR0T1H2KrSF7rFsdJoRFExOyIODsiykh+dfUCflnHavPrmN+FZPf7uvSDW2UP4D8krah6kHxh9KqlrgNJPqCnk/wC3bFqRrp3My09QL6CpG+8ey117QE8mLXt2SS/vOtKglU+zJpey6dfLNX1Yuv/0ft51p+t+vq9ACTtJenh9GDmSpIDyTW1eTk1f4ndC5yVPu7NI55M2yNibTpZU/s/yppel65Tvaw+ewrV121IXVVWp387Z5V15tMkurravOrzczkpIjqRdD3uQ+3vxVxqen9dBgh4SdIsSdWPq3Ui6aprcZwUGllEvElyfGBQVVFNi9ZR1XKSXeHfSfpSVvl84NqI6JL16BgRE+qIKyLifpJ+5KsgOXMEeICkn/vzaffWoyQfnppinE/SF569/Q4RsaCO9tTXIpJkV2X3avPXAB2znu+ao47q6y9Mp+8A3gT6R0Rn4P/xaZurmwHsVcO8Z/n0136dZ5gVUT7/i4KLiOUkr1N2t8v+wKx0elb2PEk7khzLmEUd0r3We0jem1W2uZ0R8WFEnBcRvUj2dm+XlL2nNYCtu8FaDCeFEpO0j6T/SPtAkdSbpJui6myVj4AySe3qW3dE/I2k3/dBScPS4juB8yUNU2JHSV+XVNsuebbrgTGSdgXaAe2BJUClpONI+t+rfAR0k7RTVtmvgWurTi2U1EPSifVtWx7uBy6SVJb2XY+tNv81YJSktpJqOubwQ0kdJQ0kOV5SdeZLJ5IDrKvT4yzfqSWOR6mhaykiAvgnYGQ63VheA05O29oPOLeQlUvqQPI+AWifPq9yL/Cfkrqm/8vzSL7MAR4EBkk6JV3nKmBG+sMpH78ERkiq6gLa5nZK+ueqzyjJD64g2cNF0m4kZ0dVP8OsRXBSKL1VJF0yf0/77aeR9Nn+Rzp/Kskvow8lfVzfyiNiCskX2mRJB0VEOckH71aSN/c71HywNld9/yA5C+MHEbGK5MDx/Wld/0LSN1617JvABOC9tLuoF3BzuswTad/vtLT9hXYn8BeSX2/TSU5tzPZDkl+dy0lOAf5jjjqeJvn/PAn8LO2Lh+QMqH8hee3upJbTJCNiOvBJVlKuPn9W2k/fmG4iOcbwEcmxivsKXP86Pu0qejN9XuVqkoPH75P8v2+MiMcB0uNgp5CcULGc5H0yKt+NpuvfS/JaQ8PaeTDJZ3Q1yfv34oiYm877F2B8eoysxVHj/mAxa3kkHQNcEBEnNXYsVlhpF+rrwBERsbix4ykGJwUzM8tw95GZmWU4KZiZWYaTgpmZZWzTUMFNRffu3aNPnz6NHYaZWbPyyiuvfBwRPXLNa9ZJoU+fPpSXlzd2GGZmzYqkGq/4d/eRmZllOCmYmVmGk4KZmWU062MKZmaFsGnTJioqKli/vq7RzJuXDh06UFZWRtu2bfNex0nBzLZ7FRUVdOrUiT59+lDzfYyal4hg6dKlVFRU0Ldv37zX2y67j7ZUbmLzhvVsXr+OLZWbGjscM2tk69evp1u3bi0mIQBIolu3bvXe+9nu9hS2bNrE6g/eo3JNct+O1jt0pFOf/rSqx+6VmbU8LSkhVNmWNm13ewqb1qzKJASAzevWsnHF0kaMyMys6djuksLmdWs/U1a5bi2xZUsjRGNmlpg3bx6DBg2qe8HU2WefzZ/+9CcAhg8fXrALebe7pNCuS9fPlLXv2h212u7+FWZmn7HdfRO2ateeHXv3pVW79rRq246OvXan9Q4d617RzKzIKisrGT16NIMHD+bUU09l7dq1/PjHP+bggw9m0KBBjBkzhmLfA2f7Swqt29Cuy850/sLedO63D+27dadVm+3ueLuZNUFvvfUWY8aMYcaMGXTu3Jnbb7+dCy+8kJdffpmZM2eybt06Hn744aLGsN0lBUiOyLdq245WbdshbZf/AjNrgnr37s2XvvQlAL75zW/y3HPP8dRTTzFs2DD2228/pk6dyqxZxb3Ft38im5k1EdVPIZXEBRdcQHl5Ob179+aaa64p+lXX/plsZtZEfPDBB7z44osATJgwgcMPPxyA7t27s3r16szZRsXkPQUzsyZiwIABjB8/nm9/+9v079+f73znOyxfvpz99tuPPn36cPDBBxc9BhX7SHYxDR06NHyTHTNrqNmzZzNgwIDGDqMocrVN0isRMTTX8u4+MjOzDCcFMzPLKFpSkHS3pMWSZmaVXSNpgaTX0sfxWfOukPSOpLckfa1YcZmZWc2KuadwD3BsjvKbImJI+ngUQNK+wChgYLrO7ZJaFzE2MzPLoWhJISKeAZblufiJwMSI2BARc4F3gEOKFZuZmeXWGMcULpQ0I+1eqhqdbjdgftYyFWnZZ0gaI6lcUvmSJUuKHauZ2Xal1EnhDuALwBBgEfDztDzXnSBynisbEeMiYmhEDO3Ro0dxojQzaySbN2/mgAMO4IQTTgBg7ty5DBs2jP79+3P66aezcePGom6/pEkhIj6KiM0RsQW4k0+7iCqA3lmLlgELSxmbmVlTcPPNN291XcHll1/O97//febMmUPXrl256667irr9kiYFST2znn4DqDozaTIwSlJ7SX2B/sBLpYzNzCxfG5YvZcXsGSybUc6K2TPYsLwwd2+sqKjgkUce4Vvf+hYAEcHUqVM59dRTARg9ejQPPfRQQbZVk6INcyFpAjAc6C6pArgaGC5pCEnX0Dzg2wARMUvS/cAbQCXw3YjYXKzYzMy21YblS1lT8T5EcrfGLZs2Js+B9l27Naju733ve/z0pz9l1arklsFLly6lS5cutEmH9y8rK2PBggUN2kZdipYUIuKMHMU17vdExLXAtcWKx8ysENZ9uCCTEDJiC+s+XNCgpPDwww+zyy67cNBBB/G3v/0tqTbHMETVR1ItNA+IZ2ZWD1s25T7QW1N5vp5//nkmT57Mo48+yvr161m5ciXf+973WLFiBZWVlbRp04aKigp69erVoO3UxcNcmJnVQ6u27epVnq/rrruOiooK5s2bx8SJEznqqKO47777OPLIIzNDZo8fP54TTzyxQdupi5OCmVk97LDrblD9jo1qlZQXwQ033MAvfvEL+vXrx9KlSzn33HOLsp0q7j4yM6uHquMG6z5cwJZNG2nVth077Lpbgw8yZxs+fDjDhw8HYM899+Sll0p3MqaTgplZPbXv2q2gSaApcfeRmZllOCmYmVmGk4KZmWU4KZiZWYaTgpmZZTgpmJk1ETfddBMDBw5k0KBBnHHGGaxfv75lD51tZma5LViwgFtuuYXy8nJmzpzJ5s2bmThxYsseOtvMrCVYNW8+709+nHcnPsj7kx9n1bz5da+Uh8rKStatW0dlZSVr166lZ8+eJR8620nBzKweVs2bz5KXX6Vy7ToAKteuY8nLrzY4Mey2225ceuml7L777vTs2ZOddtqJgw46qORDZzspmJnVw7IZs4jNW9/uJTZvZtmMWQ2qd/ny5UyaNIm5c+eycOFC1qxZw2OPPfaZ5Tx0tplZE1K1h5Bveb7++te/0rdvX6ruPX/yySfzwgsveOhsM7OmrE3HHepVnq/dd9+dadOmsXbtWiKCJ598kn333ddDZ5uZNWU7Dx6IWrfeqkytW7Pz4IENqnfYsGGceuqpHHjggey3335s2bKFMWPGlHzobOW63VtBKpbuBk4AFkfEoGrzLgVuBHpExMeShgOTgLnpIn+OiB/XtY2hQ4dGeXl5YQM3s+3O7NmzGTBgQN7Lr5o3n2UzZlG5dh1tOu7AzoMH0qlP7yJGuO1ytU3SKxExNNfyxTymcA9wK3BvtWB6AyOAD6ot/2xEnFDEeMzMCqJTn95NNgk0VNG6jyLiGWBZjlk3AZcBxdlFMTOzbVbSYwqSRgILIuL1HLMPk/S6pMck1dg5J2mMpHJJ5UuWLClesGZm26GSJQVJHYErgatyzJ4O7BER+wO/Amq8ZC8ixkXE0IgYWnXqlpmZFUYp9xS+APQFXpc0DygDpkvaNSJWRsRqgIh4FGgrqXsJYzMzM0p48VpE/APYpep5mhiGpmcf7Qp8FBEh6RCSZLW0VLGZmVmiaHsKkiYALwJ7S6qQVNvJtacCMyW9DtwCjIpinStrZtYEnXPOOeyyyy4MGvTpGfw/+MEP2GeffRg8eDDf+MY3WLFiRWbeddddR79+/dh77735y1/+UrA4inn20RkR0TMi2kZEWUTcVW1+n4j4OJ2+NSIGRsT+EXFoRLxQrLjMzJqis88+m8cff3yrshEjRjBz5kxmzJjBXnvtxXXXXQfAG2+8wcSJE5k1axaPP/44F1xwAZurjce0rTz2kZlZPb334hu8+sBzrFm6kh27deaAUw5nz8P2bVCdRxxxBPPmzduq7JhjjslMH3rooZnhLiZNmsSoUaNo3749ffv2pV+/frz00kscdthhDYoBPMyFmVm9vPfiG7x4zxOsWboSgDVLV/LiPU/w3otvFHW7d999N8cddxyQ3JCnd+9PL54r5JDaTgpmZvXw6gPPsXlj5VZlmzdW8uoDzxVtm9deey1t2rThzDPPBCDXIddCDant7iMzs3qo2kPIt7yhxo8fz8MPP8yTTz6Z+eIvKytj/vxPb+pTyCG1vadgZlYPO3brXK/yhnj88ce54YYbmDx5Mh07dsyUjxw5kokTJ7Jhwwbmzp3LnDlzOOSQQwqyTScFM7N6OOCUw2ndbutOltbt2nDAKYc3qN4zzjiDww47jLfeeouysjLuuusuLrzwQlatWsWIESMYMmQI559/PgADBw7ktNNOY9999+XYY4/ltttuo3W14by3VdGGzi4FD51tZoVQ36Gzi3H2UbE0paGzzcxapD0P27fJJoGGcveRmZllOCmYmVmGk4KZmWU4KZiZWYaTgpmZZTgpmJk1AbmGzgb41a9+xd57783AgQO57LLLMuXFGjrbp6SamTUBZ599NhdeeCFnnXVWpuypp55i0qRJzJgxg/bt27N48WJg66GzFy5cyFe/+lXefvvtglzA5j0FM7N6mvrIc4w+5kKOH3wGo4+5kKmPNHwwvCOOOIKdd955q7I77riDsWPH0r59ewB22SW5eWVNQ2cXgpOCmVk9TH3kOW65ZhyLF31MRLB40cfccs24giSG6t5++22effZZhg0bxle+8hVefvllwENnm5k1GeNvnsiG9Ru3KtuwfiPjb55Y8G1VVlayfPlypk2bxo033shpp51GRBR16OyiJgVJd0taLGlmjnmXSgpJ3dPnknSLpHckzZB0YDFjMzPbFks+XFqv8oYoKyvj5JNPRhKHHHIIrVq14uOPP27WQ2ffAxxbvVBSb2AE8EFW8XFA//QxBrijyLGZmdVbj1271au8IU466SSmTp0KJF1JGzdupHv37s136OyIeAZYlmPWTcBlQPY+0InAvZGYBnSR1LOY8ZmZ1dfoi0fRvkO7rcrad2jH6ItHNajeXENnn3POObz33nsMGjSIUaNGMX78eCQVdejskp+SKmkksCAiXq/WB7YbMD/reUVatqiE4ZmZ1eqoryf3TRh/80SWfLiUHrt2Y/TFozLl22rChAk5y//whz/kLL/yyiu58sorG7TNXEqaFCR1BK4Ejsk1O0fZZ46mSBpD0r3E7rvvXtD4zMzycdTXD29wEmiqSn320ReAvsDrkuYBZcB0SbuS7Bn0zlq2DFhYvYKIGBcRQyNiaI8ePUoQspnZ9qOkSSEi/hERu0REn4joQ5IIDoyID4HJwFnpWUiHAp9EhLuOzMxKqNinpE4AXgT2llQh6dxaFn8UeA94B7gTuKCYsZmZ2WfVeUxBydHgM4E9I+LHknYHdo2IOq+pjogz6pjfJ2s6gO/WGbGZmRVNPnsKtwOHAVVf8KuA24oWkZmZNZp8ksKwiPgusB4gIpYD7WpfxczM6mP+/PkceeSRDBgwgIEDB3LzzTcDsGzZMkaMGEH//v0ZMWIEy5cvByAiuOiii+jXrx+DBw9m+vTpBYkjn6SwSVJr0tNDJfUAthRk62ZmBkCbNm34+c9/zuzZs5k2bRq33XYbb7zxBtdffz1HH300c+bM4eijj+b6668H4LHHHmPOnDnMmTOHcePG8Z3vfKcgceSTFG4BHgR2kXQt8BxwXUG2bmbWDD3y0BS+9sXT2L/PcL72xdN45KEpDa6zZ8+eHHhgMuRbp06dGDBgAAsWLGDSpEmMHj0agNGjR/PQQw8ByfDZZ511FpI49NBDWbFiBYsWNfyEzToPNEfEfZJeAY4mucDspIiY3eAtm5k1Q488NIUfjb2R9es2ALBowUf8aOyNAHz9pBEF2ca8efN49dVXGTZsGB999BE9eyYj/vTs2TNzo52ahs+uWnZb1bmnIOn3EfFmRNwWEbdGxGxJv2/QVs3MmqlbfnpnJiFUWb9uA7f89M6C1L969WpOOeUUfvnLX9K5c+calyvW8Nn5dB8NrLbR1sBBDd6ymVkz9OHCxfUqr49NmzZxyimncOaZZ3LyyScD8PnPfz7TLbRo0aLM3deKNXx2jUlB0hWSVgGDJa2UtCp9vhiY1OAtm5k1Q7v22qVe5fmKCM4991wGDBjAJZdckikfOXIk48ePB2D8+PGceOKJmfJ7772XiGDatGnstNNODe46glqSQkRcFxGdgBsjonNEdEof3SLiigZv2cysGbrosvPosEP7rco67NCeiy47r0H1Pv/88/z+979n6tSpDBkyhCFDhvDoo48yduxYpkyZQv/+/ZkyZQpjx44F4Pjjj2fPPfekX79+nHfeedx+++0N2n6VfA40XyGpK8nNbzpklT9TkAjMzJqRqoPJt/z0Tj5cuJhde+3CRZed1+CDzIcffnjO4wQATz755GfKJHHbbYW/jjifYS6+BVxMMmrpa8ChJOMZHVXwaMzMmoGvnzSiYGcaNTX5HGi+GDgYeD8ijgQOAJYUNSozM2sU+SSF9RGxHkBS+4h4E9i7uGGZmZVWTV03zdm2tCmfO69VSOoCPARMkbScHDe/MTNrrjp06MDSpUvp1q1bQc71bwoigqVLl9KhQ4e6F86Sz4Hmb6ST10h6CtgJeKz+IZqZNU1lZWVUVFSwZEnL6hnv0KEDZWVl9VqnXvdojoin072Gy4Br67UlM7Mmqm3btvTt27exw2gSart4rbekcZIelvQtSR0l/Rx4G2jYVRpmZtYk1bancC/wNPAAcCwwDZgFDE7vqWxmZi1MbUlh54i4Jp3+i6SPgIMjYkMt65iZWTNW6ympkrpK2lnSzsCHQMes57WSdLekxZJmZpX9RNIMSa9JekJSr7R8uKRP0vLXJF3V0IaZmVn91bansBPwCsk9FKpU3e8tgD3rqPse4FaSbqgqN0bEDwEkXQRcBZyfzns2Ik7IL2wzMyuGGpNCRPRpSMUR8YykPtXKVmY93ZH0Fp9mZtY05HNFc0FJulbSfOBMkj2FKodJel3SY5IG1rA6ksZIKpdU3tLOKTYza2wlTwoRcWVE9AbuAy5Mi6cDe0TE/sCvSK6ermn9cRExNCKG9ujRo/gBm5ltR0qeFLL8ETgFkm6liFidTj8KtJXUvRFjMzPbLuWVFCQdLunf0ukekrbp0j9J/bOejgTeTMt3VTrgiKRD0riWbss2zMxs2+VzP4WrgaEkI6P+DmgL/AH4Uh3rTQCGA90lVQBXA8dL2hvYArzPp2cenQp8R1IlsA4YFS1xyEIzsyYun7GPvkFyD4XpABGxUFKnulaKiDNyFN9Vw7K3kpy+amZmjSif7qON6a/2AJC0Y3FDMjOzxpJPUrhf0m+ALpLOA/4K/La4YZmZWWPI534KP5M0AlhJclzhqoiYUvTIzMys5PI50HxcRDwGTMkqOz8ifl3UyMzMrOTy6T76oaSjqp5Iuhw4sXghmZlZY8nn7KORwMOSfkByX4V90jIzM2th8jmm8LGkkSQHmF8BTvU1BGZmLVONSUHSKpLTUJX+bUcyXPapkiIiOpcmRDMzK5Xahs6u8wI1MzNrWWrbU9gnIt6UdGCu+RExPVe5mZk1X7UdU7gEGAP8PMe8AI7KUW5mZs1Ybd1HYyS1Av4zIp4vYUxmZtZIar1OISK2AD8rUSxmZtbI8rl47QlJp1Td78DMzFqufC5euwTYEaiUtJ70FFWfkmpm1vLkc/GaT001M9tO1Nl9JOnJfMrMzKz5q+06hQ5AR5LbaXYl6TYC6Az0KkFsZmZWYrXtKXybZKyjfdK/VY9JwG35VC7pbkmLJc3MKvuJpBmSXpP0hKReabkk3SLpnXR+zovmzMyseGpMChFxc0T0BS6NiD0jom/62D+9p3I+7iEZWTXbjRExOCKGAA8DV6XlxwH908cY4I76NMTMzBquxqQg6WBJu0bEr9LnZ0malP6a3zmfyiPiGWBZtbKVWU93JL33M8k9Gu6NxDSS23/2rE9jzMysYWrrPvoNsBFA0hHA9cC9wCfAuIZsVNK1kuYDZ/LpnsJuwPysxSrSsurrjpFULql8yZIlDQnDzMyqqS0ptI6Iql/5pwPjIuKBiPgh0K8hG42IKyOiN3AfcGFanOviuM/ctyEixkXE0IgY2qNHj4aEYWZm1dSaFCRVnZ10NDA1a14+F73l44/AKel0BdA7a14ZsLBA2zEzszzUlhQmAE9LmgSsA54FkNSPpAtpm0jqn/V0JPBmOj0ZOCs9C+lQ4JOIWLSt2zEzs/qrbZTUa9OL1HoCT2TdgrMV8O/5VC5pAjCc5FqHCuBq4HhJewNbgPeB89PFHwWOB94B1gL/Vu/WmJlZg9TaDZSeBVS97O18K4+IM3IU31XDsgF8N9+6zcys8PIZJdXMzLYTTgpmZpbhpGBmZhlOCmZmluGkYGZmGU4KZmaW4aRgZmYZTgpmZpbhpGBmZhlOCmZmluGkYGZmGU4KZmaW4aRgZmYZTgpmZpbhpGBmZhlOCmZmluGkYGZmGU4KZmaWUbSkIOluSYslzcwqu1HSm5JmSHpQUpe0vI+kdZJeSx+/LlZcZmZWs2LuKdwDHFutbAowKCIGA28DV2TNezcihqSP84sYl5mZ1aBoSSEingGWVSt7IiIq06fTgLJibd/MzOqvMY8pnAM8lvW8r6RXJT0t6cs1rSRpjKRySfJoptUAAAwOSURBVOVLliwpfpRmZtuRRkkKkq4EKoH70qJFwO4RcQBwCfBHSZ1zrRsR4yJiaEQM7dGjR2kCNjPbTpQ8KUgaDZwAnBkRARARGyJiaTr9CvAusFepYzMz296VNClIOha4HBgZEWuzyntIap1O7wn0B94rZWxmZgZtilWxpAnAcKC7pArgapKzjdoDUyQBTEvPNDoC+LGkSmAzcH5ELMtZsZmZFU3RkkJEnJGj+K4aln0AeKBYsZiZWX58RbOZmWU4KZiZWYaTgpmZZTgpmJlZhpOCmZllOCmYmVmGk4KZmWU4KZiZWYaTgpmZZTgpmJlZhpOCmZllOCmYmVmGk4KZmWU4KZiZWYaTgpmZZTgpmJlZhpOCmZllOCmYmVlG0ZKCpLslLZY0M6vsRklvSpoh6UFJXbLmXSHpHUlvSfpaseIyM7OaFXNP4R7g2GplU4BBETEYeBu4AkDSvsAoYGC6zu2SWhcxNjMzy6FoSSEingGWVSt7IiIq06fTgLJ0+kRgYkRsiIi5wDvAIcWKzczMcmvMYwrnAI+l07sB87PmVaRlZmZWQo2SFCRdCVQC91UV5Vgsalh3jKRySeVLliwpVohmZtulkicFSaOBE4AzI6Lqi78C6J21WBmwMNf6ETEuIoZGxNAePXoUN1gzs+1MSZOCpGOBy4GREbE2a9ZkYJSk9pL6Av2Bl0oZm5mZQZtiVSxpAjAc6C6pAria5Gyj9sAUSQDTIuL8iJgl6X7gDZJupe9GxOZixWZmZrnp0x6c5mfo0KFRXl7e2GGYmTUrkl6JiKG55vmKZjMzy3BSMDOzDCcFMzPLcFIwM7MMJwUzM8twUjAzswwnBTMzy3BSMDOzDCcFMzPLcFIwM7MMJwUzM8twUjAza0Y2bNjIiuUr2by5OGOGFm2UVDMzK6wlHy3ld7+ZwMzXZ3PUMYcz8tTj2Llbl4Juw0nBzKwZWLZ0OReeczmzZ84B4LXymcx7r4IfXPVddtyxY8G24+4jM7NmYO2adZmEUGXyA4+zds26gm7HScHMrBlo27YNrVpt/ZW9U5fOpDcsKxgnBTOzZqDjjh0ZPeb0rcrG/ugiunTdqaDb8TEFM7NmoFPnz/Fv55/B8Sd9lXfemsvgIfvStVsX2rRpXdDtOCmYmTUTXbruRJeuO7H3gH5F20bRuo8k3S1psaSZWWX/LGmWpC2ShmaV95G0TtJr6ePXxYrLzMxqVsxjCvcAx1YrmwmcDDyTY/l3I2JI+ji/iHGZmVkNitZ9FBHPSOpTrWw2UPCj5WZmVhhN6eyjvpJelfS0pC/XtJCkMZLKJZUvWbKklPGZmbV4TSUpLAJ2j4gDgEuAP0rqnGvBiBgXEUMjYmiPHj1KGqSZWUvXJJJCRGyIiKXp9CvAu8BejRuVmdn2p0mckiqpB7AsIjZL2hPoD7xX13qvvPLKx5Leb8CmuwMfN2D9pqSltKWltANaTltaSjug5bSloe3Yo6YZRUsKkiYAw4HukiqAq4FlwK+AHsAjkl6LiK8BRwA/llQJbAbOj4hldW0jIhrUfySpPCKG1r1k09dS2tJS2gEtpy0tpR3QctpSzHYU8+yjM2qY9WCOZR8AHihWLGZmlp8mcUzBzMyahu09KYxr7AAKqKW0paW0A1pOW1pKO6DltKVo7VBEFKtuMzNrZrb3PQUzM8vipGBmZhktKilI6i3pKUmz09FYL07Ld5Y0RdKc9G/XtHwfSS9K2iDp0hz1tU6H3ni4ObdF0jxJ/0hHoC1vxu3oIulPkt5M6zusObZF0t5ZIwK/JmmlpO81t3ak876f1jFT0gRJHUrVjiK05eK0HbNK+Xo0oC1nSpqRPl6QtH9WXcdKekvSO5LG1iuQiGgxD6AncGA63Ql4G9gX+CkwNi0fC9yQTu8CHAxcC1yao75LgD8CDzfntgDzgO7N/TUBxgPfSqfbAV2aa1uy6mwNfAjs0dzaAewGzAV2SJ/fD5zdHF8TYBDJKM4dSU7V/yvQv4m35YtA13T6OODvWe+pd4E908/J68C++cbRovYUImJRRExPp1cBs0neuCeSfKGQ/j0pXWZxRLwMbKpel6Qy4OvAb0sQ+mcUsi2NqVDtUDIW1hHAXelyGyNiRUkakSrSa3I0ybDxDbkyv14K3I42wA6S2pB8oS4scvhbKWBbBgDTImJtRFQCTwPfKEETMrahLS9ExPK0fBpQlk4fArwTEe9FxEZgYlpHXlpUUsimZNjuA4C/A5+PiEWQ/ONJfi3U5ZfAZcCWIoWYtwK0JYAnJL0iaUyx4qxLA9uxJ7AE+F3apfdbSTsWMdxaFeA1qTIKmFDo+PLVkHZExALgZ8AHJINafhIRTxQz3to08DWZCRwhqZukjsDxQO/iRVu7bWjLucBj6fRuwPyseRVpWV5aZFKQ9DmSK6S/FxErt2H9E4DFkQzO16ga2pbUlyLiQJJdzO9KOqJgAeapAO1oAxwI3BHJaLprSHalS65ArwmS2gEjgf8tVGz13H5DPyddSX6B9gV6ATtK+mZho8w7lga1JZJ7vdwATAEeJ+lyqSxokHmqb1skHUmSFC6vKsqxWN7XHrS4pCCpLck/9L6I+HNa/JGknun8nsDiOqr5EjBS0jySXa+jJP2hSCHXqEBtISIWpn8XkwwzckhxIs6tQO2oACoi4u/p8z+RJImSKtRrkjoOmB4RHxU+0toVqB1fBeZGxJKI2AT8maSfu6QK+Dm5KyIOjIgjSMZpm1OsmGtS37ZIGkzSxX1ipCNNk3xWsvdyyqhHt16LSgqSRNLnPDsifpE1azIwOp0eDUyqrZ6IuCIiyiKiD8nu/dSIKOkvoEK1RdKOkjpVTQPHkOwql0QBX5MPgfmS9k6LjgbeKHC4tSpUW7KcQSN0HRWwHR8Ah0rqmNZ5NEk/eMkU8jWRtEv6d3eS2waX9LWpb1vSOP8M/GtEvJ21/MtAf0l9073RUWkd+dmWo+RN9QEcTrKbNAN4LX0cD3QDniTJ/E8CO6fL70qSVVcCK9LpztXqHE7jnH1UkLaQ9MW/nj5mAVc2x3ak84YA5WldD5GeedFM29IRWArs1FzfW+m8HwFvkvzQ+D3Qvhm35VmSHxqvA0c3g9flt8DyrGXLs+o6nuTspXfr+5n3MBdmZpbRorqPzMysYZwUzMwsw0nBzMwynBTMzCzDScHMzDKcFKxFk7RZyUikMyX9bzqEAZJWlziOvylrhFpJQyX9rZQxmOXDScFaunURMSQiBgEbgfOLvUElcn22dpF0XLG3b9YQTgq2PXkW6JddIOlzkp6UNF3JPSdOTMt/UjWeffr8WkkXpdM/kPRyOo79j9KyPuk4+LcD08k9mNqNwH9WL0zXfTaNYbqkL6blwyU9Lel+SW9Lul7JGPovpbF+IV2uh6QH0phelvSlgvy3bLvkpGDbBSVDOx8H/KParPXANyIZMPBI4OdZww2MTtdtRTJUwH2SjgH6k4wfNQQ4KGuAwb2BeyPigMg9FPaLwIZ0ALNsi4ERaQynA7dkzdsfuBjYD/hXYK+IOITkatZ/T5e5GbgpIg4GTqGRhnu3lqFNYwdgVmQ7SHotnX6W9H4MWQT8d/rFvoVkiOHPR8Q8SUslHQB8Hng1IpamSeEY4NV0/c+RJIkPgPcjYlod8fwXyd7C5VllbYFbJQ0BNgN7Zc17OdJhkyW9C1QNTf0PkiQGycB0+ya5DIDOkjpFMia/Wb04KVhLty4ihtQy/0ygB3BQRGxKR8atuqXkb4GzScbLuTstE3BdRPwmuxIl49+vqSuYiJgq6SfAoVnF3wc+ItkraEWy91JlQ9b0lqznW/j089sKOCwi1tW1fbO6uPvItnc7kdw7Y1ParbNH1rwHgWNJbt/4l7TsL8A56Zj3SNqtanTNeriW5AZO2TEsiogtJF1EretZ3xPAhVVP0j0Os23iPQXb3t0H/F96uuhrJCN+AsktPyU9BayIiM1p2ROSBgAvpt01q4FvknT75CUiHpW0JKvoduABSf8MPEUeexzVXATcJmkGyWf6GUpwlpW1TB4l1awG6QHm6cA/R0TJb7hi1hjcfWSWg6R9gXeAJ50QbHviPQUzM8vwnoKZmWU4KZiZWYaTgpmZZTgpmJlZhpOCmZll/H+3gPHkfhelDwAAAABJRU5ErkJggg==\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "sns.scatterplot(data=dubai_df,x='year',y='SR',hue='ball')\n", "plt.title('Strike Rate in dubai(Minimum 100 Runs)')\n", "plt.xlabel('Player Name')\n", "plt.ylabel('Strike Rate')\n", "plt.show()" ] }, { "cell_type": "code", "execution_count": 159, "metadata": {}, "outputs": [], "source": [ "dubai_innings=msd_df_dbi[(msd_df_dbi['venue']=='Dubai International Cricket Stadium')|\n", " (msd_df_dbi['venue']=='Sheikh Zayed Stadium')|\n", " (msd_df_dbi['venue']=='Sharjah Cricket Stadium')]" ] }, { "cell_type": "code", "execution_count": 165, "metadata": {}, "outputs": [], "source": [ "dubai_all_innngs=pd.DataFrame(dubai_innings.groupby('match_id')['runs_off_bat'].sum()).reset_index()" ] }, { "cell_type": "code", "execution_count": 186, "metadata": {}, "outputs": [], "source": [ "dubai_all_innings=dubai_all_innings.reset_index()" ] }, { "cell_type": "code", "execution_count": 194, "metadata": {}, "outputs": [], "source": [ "dubai_all_innings['index']=dubai_all_innings['index']-1\n", "dubai_all_innings.rename(columns={'index':'Innings'},inplace=True)" ] }, { "cell_type": "code", "execution_count": 197, "metadata": {}, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX4AAAEWCAYAAABhffzLAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAbwElEQVR4nO3debhcVZnv8e/PhDBDGAImBAhomJWhA2IjKINcQGRWQewOLRgRUVQQoWltuDS3waaB26LQTBKUUWYQFS4CigrcAAkkBA0EkJCQhDYMAUEDb/+x1ukUlTPUqapd5yTr93mees4e33p31a63Vq09HEUEZmZWjvcMdAJmZtZZLvxmZoVx4TczK4wLv5lZYVz4zcwK48JvZlYYF/5BTtKFkr6dhz8madZA59QqSTtL+n2bYo2RFJKGtnPZHtZfKGnjmvE9Jd3cRJyfSRrf7mWtfSQtL+lJSesMdC5VcOGvkKSPSPqtpFck/UnSbyRtn+cdIen+vmJExNERcXoFuYWk13Mxe0HSOZKGNLhuS19AEfHriNi02fUHSkSsEhEzayb9H+DMrpH8ms6t/WKRNFTSPElRE2fviJjY4HM2vGwnSRop6VZJs/N2j6mbv7ykyyS9KulFSd+om797LqxvSLpH0oa9PNezkv6c99UXJV0uaZVqtiyJiLeAy4BvVfk8A8WFvyKSVgNuB74HrAmsB5wGvNWPGA0V4hZsHRGrAB8FPgN8vuLnW2bkL/DVI+KBulkvA3vXjO8DLOhYYp3zDvBz4OAe5p8KjAU2BHYFTpS0F4CktYEbgW+TPhuTgGv7eL5P5n11G2Bb4OQW82/EVcB4Sct34Lk6KyL8qOABjANe7mHe5sCbwNvAwq7lgMuBC4A7gNeBPfK0f8nzPwbMqonzVeAJYHQe3xeYTCo+vwU+2Et+Aby/Zvw64Ps14/8ATAdeA2YCX8zTVwb+TPrgL8yPUaRGxEnA08B/5Xhr9vDc9dvxLHAC8BjwCqkIrNDDukOAs4GXcl5fztsytCbWHjXLnwr8OA+PyctOAGYDc4Dja5bdAfhdfv3mAOcDw7p7zYDvAJd085r+E/CTmmnXA6ekj9r/TLsXOCoPHwHcn7dpAfAMsHcvy/4GODfnOBP42zz9eWAeML67dWufqy7fY4AZ+X0+HXhffg1eze/hsPr3oG6bh+Y4Y+qmvwDsWTN+OnBNHp4A/LZmXtc+tVkPz1H/nn4X+Gk/t/PovJ0LgO8DyvPeD9xH2u9eAq6te+4ZwEcHup60++EWf3X+ALwtaaKkvSWt0TUjIqaTdsTfReo+GF6z3meBM4BVSQWhW7nf/wjSTjlL0nakn6ZfBNYC/hO4tZHWiqTNgJ2Bp2omzyN9kaxG+hI4V9J2EfE6qUU7O+e+SkTMJn0JHUD69TCKxR+wRn0a2AvYCPhg3rbufCHntS3py/WQfjxHl11JrdE9gZMk7ZGnvw18HVgb+DCwO6kwducDQHfHKW4GdpE0XNJw0ut6Sx/5fCjHWptU1C6VpF6WfYz0Hl8FXANsTypgnwPO72c3yF7A3wA7AicCFwGHA+sDWwGH9SMWAHlfHwVMqZk8BdgyD29ZOy/vU0/XzO8t9mjS/vdUX8vW2Zf0Om1N2tf+V55+OnAnsAYwmvQLvdb0vM4yxYW/IhHxKvARUmvjYmB+7hNdt49Vb4mI30TEOxHxZjfzJekc0o67a0TMz9O/APxnRDwYEW9H6hd+i/SB7skjkl4n7dz3Aj+oyf+nEfF0JPeRPhw79xLri8ApETErUv/oqcAh/TiQ+h8RMTsi/gTcRvpJ351PA+dFxPN52X9tMH6t0yLi9Yh4HPghubhFxMMR8UBELIqIZ0lfnh/tIcZwUiu53ps5/88AhwK35mm9eS4iLo6It4GJwEigp/3kmYj4YV72WlKB/t8R8VZE3An8hfQl0KizIuLViJgGTAXujIiZEfEK8DPSF2x/dX3xvFIz7RVSY6Zr/iu8W+387tws6TUW/7L5537mdGZEvBwRfwTuYfH+9VdSd9SoiHgzIuobW6+R3utligt/hSJiekQcERGjSa2nUcB5faz2fB/zh5N+Kv9r/nB22RA4XtLLXQ9SURjVS6ztSB/Cz5Bakit3zci/Uh7IB6VfJvVVr91LrA2Bm2qeezqpBd3XF12XF2uG32Bx8ag3ine/Rs81GL9W/fqjACRtIun2fADxVdLB2562eQE9F6orgL/PjysayOd/tj0i3siDPW3/3JrhP+d16qf1p8Vfv24rsboszH9Xq5m2Gou/KBfWzauf350DImJVUjfhZvS+L3anp/3rREDAQ5KmSao/zrUqqVttmeLC3yER8SSpv36rrkk9LdpHqAWkn60/lLRTzfTngTMiYnjNY6WIuLqPvCIiriP1634H0hkZwA2kfud1c1fUHaQPSE85Pk/qm659/hUi4oU+tqe/5pC+0LpsUDf/dWClmvH3dhOjfv3ZefgC4ElgbESsBvwji7e53mPAJj3M+zWLW+19nrlVoUZei7aLiAWk96m2i2RrYFoenlY7T9LKpGML0+hD/vV5OWnf7NL0dkbEixHxhYgYRfrV+gNJtb+YNufdXVbLBBf+ikjaTNLxuU8SSeuTuhS6zgKZC4yWNKy/sSPiXlI/7E2SPpQnXwwcLelDSlaW9AlJvf18rnUmMEHSe4FhwPLAfGCRpL1J/eFd5gJrSVq9ZtqFwBldp+VJGiFp//5uWwOuA74qaXTuSz6pbv5k4FBJy0nq6RjAtyWtJGlL0vGLrjNKViUd1FyYj3t8qZc87qCHbqCICOCTwH55eKBMBg7K2/p+4Mh2Bpe0Amk/AVg+j3e5AvgnSWvk1/ILpIINcBOwlaSD8zrfAR7LjaNGnAd8XFJXd03T2ynpU12fUVKjKki/VJG0Humso/ozt5Z6LvzVeY3UffJg7kd/gNSHenye/0tSC+dFSS/1N3hE3EUqWrdK+puImET6cJ1P2oGfoucDpN3Fe5x0dsM3I+I10sHa63Ksz5L6qruWfRK4GpiZu3ZGAf83L3Nn7ot9IG9/u10M/ILUCnuEdFpgrW+TWo8LSKfPXtVNjPtIr8/dwNm5bxzSmUWfJb13F9PLKYYR8QjwSs0Xb/38abnffCCdS+rzn0s6dnBlm+P/mcXdOk/m8S7/TDpg+xzp9f63iPg5QD4udTDpJIYFpP3k0EafNK9/Bem9hta2c3vSZ3Qhaf89LiKeyfM+C0zMx6yWKRrYBonZ0kvSnsAxEXHAQOdi7ZW7O6cAu0TEvIHOp91c+M3MCuOuHjOzwrjwm5kVxoXfzKwwTd2ettPWXnvtGDNmzECnYWa2VHn44YdfiogR9dOXisI/ZswYJk2aNNBpmJktVSR1e2W7u3rMzArjwm9mVhgXfjOzwrjwm5kVxoXfzKwwLvxmZoVx4TczK4wLv5lZYVz4zcwKs1RcuWu2rPjk9Te0tP5thxzcpkysZG7xm5kVxoXfzKwwLvxmZoVx4TczK4wLv5lZYVz4zcwK48JvZlYYF34zs8K48JuZFcaF38ysMC78ZmaFceE3MyuMC7+ZWWFc+M3MCuPCb2ZWGBd+M7PCuPCbmRXGhd/MrDAu/GZmhXHhNzMrjAu/mVlhXPjNzArjwm9mVhgXfjOzwrjwm5kVxoXfzKwwlRd+SUMkPSrp9jy+kaQHJc2QdK2kYVXnYGZmi3WixX8cML1m/Czg3IgYCywAjuxADmZmllVa+CWNBj4BXJLHBewGXJ8XmQgcUGUOZmb2blW3+M8DTgTeyeNrAS9HxKI8PgtYr+IczMysRmWFX9K+wLyIeLh2cjeLRg/rT5A0SdKk+fPnV5KjmVmJqmzx7wTsJ+lZ4BpSF895wHBJQ/Myo4HZ3a0cERdFxLiIGDdixIgK0zQzK0tlhT8iTo6I0RExBjgU+GVEHA7cAxySFxsP3FJVDmZmtqSBOI//W8A3JD1F6vO/dAByMDMr1tC+F2ldRNwL3JuHZwI7dOJ5zcxsSb5y18ysMC78ZmaFceE3MyuMC7+ZWWFc+M3MCuPCb2ZWGBd+M7PCuPCbmRXGhd/MrDAu/GZmhXHhNzMrjAu/mVlhXPjNzArjwm9mVhgXfjOzwrjwm5kVxoXfzKwwLvxmZoVx4TczK4wLv5lZYVz4zcwK48JvZlYYF34zs8K48JuZFcaF38ysMC78ZmaFceE3MyuMC7+ZWWFc+M3MCuPCb2ZWmKEDncBAmfODU1paf+QxZ7QpEzOzznKL38ysMC78ZmaFceE3MyuMC7+ZWWEqK/ySVpD0kKQpkqZJOi1P30jSg5JmSLpW0rCqcjAzsyVV2eJ/C9gtIrYGtgH2krQjcBZwbkSMBRYAR1aYg5mZ1ams8EeyMI8ulx8B7AZcn6dPBA6oKgczM1tSpX38koZImgzMA+4CngZejohFeZFZwHpV5mBmZu9WaeGPiLcjYhtgNLADsHl3i3W3rqQJkiZJmjR//vwq0zQzK0pHzuqJiJeBe4EdgeGSuq4YHg3M7mGdiyJiXESMGzFiRCfSNDMrQpVn9YyQNDwPrwjsAUwH7gEOyYuNB26pKgczM1tSlffqGQlMlDSE9AVzXUTcLukJ4BpJ/wI8ClxaYQ5mZlanssIfEY8B23YzfSapv98MgL1vOayl9X+2/9VtysSsDL5y18ysMC78ZmaFceE3MytMsf+IxcyWLr+8srXreXY73KeFd3GL38ysMC78ZmaFceE3MyuMC7+ZWWEaKvySVpb0njy8iaT9JC1XbWpmZlaFRlv8vwJWkLQecDfwD8DlVSVlZmbVabTwKyLeAA4CvhcRBwJbVJeWmZlVpeHCL+nDwOHAT/M0XwNgZrYUarR4HwecDNwUEdMkbUy6vXJHzb/gxy2tP+JLn2tTJmZmS6+GCn9E/IrUz981PhP4alVJmZlZdRoq/JI2AU4AxtSuExG7VZOWmZlVpdGunp8AFwKXAG9Xl46ZmVWt0cK/KCIuqDQTMzPriEbP6rlN0jGSRkpas+tRaWZmZlaJRlv84/Pfb9ZMC2Dj9qZjZmZVa/Ssno2qTsTMzDqj0bN6/r676RFxRXvTMTOzqjXa1bN9zfAKwO7AI4ALv5nZUqbRrp6v1I5LWh34USUZmZlZpZq9H/8bwNh2JmJmZp3RaB//baSzeCB9WWxBuqjLzMyWMo328Z9dM7wIeC4iZlWQj5mZVazRPv77asclDZF0eERcWU1aZmZWlV77+CWtJulkSedL2lPJscBM4NOdSdHMzNqprxb/j4AFwO+Ao0hX7g4D9o+IyRXnZmZmFeir8G8cER8AkHQJ8BKwQUS8VnlmZmZWib5O5/xr10BEvA0846JvZrZ066vFv7WkV/OwgBXzuICIiNUqzc7MzNqu18IfEUM6lYiZmXVGs1fumpnZUqrRC7jMzPrlohvntbT+hIPWaVMmVs8tfjOzwlRW+CWtL+keSdMlTZN0XJ6+pqS7JM3If9eoKgczM1tSlS3+RcDxEbE5sCPwZUlbACcBd0fEWODuPG5mZh1SWeGPiDkR8Ugefg2YDqwH7A9MzItNBA6oKgczM1tSR/r4JY0BtgUeBNaNiDmQvhyAbo/gSJogaZKkSfPnz+9EmmZmRai88EtaBbgB+FpEvNrX8l0i4qKIGBcR40aMGFFdgmZmham08EtajlT0r4yIG/PkuZJG5vkjgdbO+TIzs36p8qweAZcC0yPinJpZtwLj8/B44JaqcjAzsyVVeQHXTsDfAY9L6rqF8z8CZwLXSToS+CPwqQpzMDNb6sz73t0trb/OV3bvdX5lhT8i7ifdzK07vWdlZmaV8ZW7ZmaFceE3MyuMC7+ZWWFc+M3MCuPCb2ZWGBd+M7PCuPCbmRXGhd/MrDAu/GZmhXHhNzMrjAu/mVlhqrxJm5lV7MAb7ml63ZsO3rWNmdjSxC1+M7PCuPCbmRXGhd/MrDAu/GZmhfHBXTOzFr14zrSW1n/vN7ZsUyaNcYvfzKwwLvxmZoVx4TczK4z7+AepOy7dp6X19znyjjZlYmbLGrf4zcwK48JvZlYYF34zs8K48JuZFcYHdwtx2cQ9m1738+PvbGMmZjbQ3OI3MyuMC7+ZWWFc+M3MCuPCb2ZWGBd+M7PCuPCbmRXGhd/MrDA+j9+WOfvcdFbT695x4LfamInZ4OQWv5lZYSor/JIukzRP0tSaaWtKukvSjPx3jaqe38zMuldli/9yYK+6aScBd0fEWODuPG5mZh1UWeGPiF8Bf6qbvD8wMQ9PBA6o6vnNzKx7nT64u25EzAGIiDmS1ulpQUkTgAkAG2ywQYfSMyvXZ274Q0vrX3vwJm3KxKo2aA/uRsRFETEuIsaNGDFioNMxM1tmdLrwz5U0EiD/ndfh5zczK16nC/+twPg8PB64pcPPb2ZWvCpP57wa+B2wqaRZko4EzgQ+LmkG8PE8bmZmHVTZwd2IOKyHWbtX9ZxmZta3QXtw18zMquHCb2ZWGBd+M7PCuPCbmRXGhd/MrDAu/GZmhXHhNzMrjAu/mVlhXPjNzArjwm9mVhgXfjOzwrjwm5kVxoXfzKwwLvxmZoVx4TczK4wLv5lZYSr7RyylefTCT7a0/rZH39amTMzMeucWv5lZYVz4zcwK48JvZlYYF34zs8K48JuZFcaF38ysMC78ZmaFceE3MyuML+Ay68W+N1za0vq3H3xkmzIxax+3+M3MCuPCb2ZWGBd+M7PCuPCbmRXGhd/MrDAu/GZmhXHhNzMrjM/jN7MizTh/btPrjj123TZm0nlu8ZuZFWZACr+kvST9XtJTkk4aiBzMzErV8cIvaQjwfWBvYAvgMElbdDoPM7NSDUSLfwfgqYiYGRF/Aa4B9h+APMzMiqSI6OwTSocAe0XEUXn874APRcSxdctNACbk0U2B3zcQfm3gpTal2s5Ygz3eYM5tsMcbzLm1O95gzq3d8QZzbv2Jt2FEjKifOBBn9aibaUt8+0TERcBF/QosTYqIcc0mVlWswR5vMOc22OMN5tzaHW8w59bueIM5t3bEG4iunlnA+jXjo4HZA5CHmVmRBqLw/39grKSNJA0DDgVuHYA8zMyK1PGunohYJOlY4BfAEOCyiJjWpvD96hrqYKzBHm8w5zbY4w3m3NodbzDn1u54gzm3luN1/OCumZkNLF+5a2ZWGBd+M7PCLBOFX9JlkuZJmtqGWOtLukfSdEnTJB3XYrwVJD0kaUqOd1obchwi6VFJt7ch1rOSHpc0WdKkNsQbLul6SU/m1/DDTcbZNOfU9XhV0tdazO3r+T2YKulqSSu0GO+4HGtaM7l1t99KWlPSXZJm5L9rtBDrUzm3dyT169S/HuL9W35fH5N0k6ThLcY7PceaLOlOSaNaiVcz7wRJIWntFnI7VdILNfvfPq3mJukr+VY10yR9t5V4kq6tye1ZSZMbjQdARCz1D2AXYDtgahtijQS2y8OrAn8AtmghnoBV8vBywIPAji3m+A3gKuD2Nmzvs8DabXwvJgJH5eFhwPA2xBwCvEi6GKXZGOsBzwAr5vHrgCNaiLcVMBVYiXSSxP8DxvYzxhL7LfBd4KQ8fBJwVguxNidd/HgvMK4Nue0JDM3DZzWaWy/xVqsZ/ipwYSvx8vT1SSeOPNfoft1DbqcCJzS5b3QXb9e8jyyfx9dpdVtr5v878J3+5LhMtPgj4lfAn9oUa05EPJKHXwOmk4pGs/EiIhbm0eXyo+kj6pJGA58ALmk2RlUkrUbaSS8FiIi/RMTLbQi9O/B0RDzXYpyhwIqShpIKdivXj2wOPBARb0TEIuA+4MD+BOhhv92f9OVJ/ntAs7EiYnpENHLFe6Px7szbCvAA6RqcVuK9WjO6Mv34XPTymT8XOLFNsZrSQ7wvAWdGxFt5mXntyE+SgE8DV/cnx2Wi8FdF0hhgW1IrvZU4Q/JPsXnAXRHRSrzzSDv2O63kVCOAOyU9rHSbjFZsDMwHfpi7oi6RtHLrKXIo/dyx60XEC8DZwB+BOcArEXFnCyGnArtIWkvSSsA+vPvCxGatGxFzIDVCgHXaELMKnwd+1moQSWdIeh44HPhOi7H2A16IiCmt5pUdm7uiLmu0y60XmwA7S3pQ0n2Stm9HgsDOwNyImNGflVz4eyBpFeAG4Gt1LZN+i4i3I2IbUgtpB0lbNZnTvsC8iHi4lXzq7BQR25HulvplSbu0EGso6SfpBRGxLfA6qbuiaUoX+e0H/KTFOGuQWtMbAaOAlSV9rtl4ETGd1N1xF/BzYAqwqNeVlhGSTiFt65WtxoqIUyJi/Rzr2L6W7yWnlYBTaPHLo8YFwPuAbUgNhX9vMd5QYA1gR+CbwHW5td6qw2iiUeTC3w1Jy5GK/pURcWO74uZuj3uBvZoMsROwn6RnSXc13U3Sj1vMaXb+Ow+4iXT31GbNAmbV/KK5nvRF0Iq9gUciovl/l5TsATwTEfMj4q/AjcDfthIwIi6NiO0iYhfST/F+tbp6MFfSSID8t+EugU6QNB7YFzg8cgdzm1wFHNzC+u8jfalPyZ+P0cAjkt7bTLCImJsbbO8AF9Pa5wLSZ+PG3PX7EOkXe0MHn3uSuywPAq7t77ou/HXyt/ClwPSIOKcN8UZ0nf0gaUVSAXqymVgRcXJEjI6IMaTuj19GRNOtVkkrS1q1a5h08K7pM6Mi4kXgeUmb5km7A080Gy9rqkXTjT8CO0paKb/Hu5OO3zRN0jr57wakD2A78rwVGJ+HxwO3tCFmW0jaC/gWsF9EvNGGeGNrRvejyc8FQEQ8HhHrRMSY/PmYRTpJ48UmcxtZM3ogLXwuspuB3XLsTUgnPrR6t849gCcjYla/12zmqPVge5A+cHOAv5Le8CNbiPURUr/3Y8Dk/NinhXgfBB7N8abSz6PvvcT9GC2e1UPqk5+SH9OAU9qQ1zbApLy9NwNrtBBrJeC/gNXb9JqdRiouU4Efkc+waCHer0lfbFOA3ZtYf4n9FlgLuJv06+FuYM0WYh2Yh98C5gK/aDG3p4Dnaz4X/TkLp7t4N+T34jHgNmC9VuLVzX+Wxs/q6S63HwGP59xuBUa2uK3DgB/n7X0E2K3VbQUuB45uZt/1LRvMzArjrh4zs8K48JuZFcaF38ysMC78ZmaFceE3MyuMC78VS9LCvpfqcd39JLV0VbLZQPHpnFYsSQsjYpWBzsOs09zit+JJ+pike7X4/whc2XUflXyv89MkPaL0fws2y9OPkHR+Hr5c0n9I+q2kmZIOydPfI+kH+f7rt0u6o2bemZKeyDcBO3ugtt3K1PF/tm42SG0LbEm6VfNvSPdFuj/PeykitpN0DHACcFQ3648kXfW9GelKz+tJt3EYA3yAdJfN6cBlktYkXVW7WUSE+vEPTczawS1+s+ShiJgV6aZck0kFu0vXjfoerpte6+aIeCcingDWzdM+AvwkT38RuCdPfxV4E7hE0kFAy/e9MesPF36z5K2a4bd596/ht3qY3tP6qvv7LpH+mckOpHvVHEC6rbNZx7jwm1XnfuDg3Ne/LunGel3/62H1iLgD+BrpxnZmHeM+frPq3EC6/fNU0v9ufhB4hfS/nG9R+mfvAr4+YBlakXw6p1mFJK0SEQslrQU8RPqPZ03dI96sXdziN6vW7fmsnWHA6S76Nhi4xW9mVhgf3DUzK4wLv5lZYVz4zcwK48JvZlYYF34zs8L8NwK0ghjWHpGLAAAAAElFTkSuQmCC\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "sns.barplot(data=dubai_all_innings,x='Innings',y='runs_off_bat')\n", "plt.title('Strike Rate in dubai(Minimum 100 Runs)')\n", "plt.xlabel('Innings')\n", "plt.ylabel('Runs')\n", "plt.show()" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.7.6" } }, "nbformat": 4, "nbformat_minor": 4 }