IPL Data Exploration

Exploratory Analysis

Question 1 : Which player has the worst economy rate in a match, and what is the total number of runs conceded by him in that match

head(q1)

##   Season_Id Match_Id Bowler Legt_Balls Runs_Conceded Eco_Rate
## 1         1   335987     84         18             7     2.33
## 2         1   335988    121         24            33     8.25
## 3         1   335989     90         24            11     2.75
## 4         1   335990     15         24            17     4.25
## 5         1   335991      5         24             8     2.00
## 6         1   335992     38         24            19     4.75

1.1 Economy Rate Trend Over Seasons

• The best economy rate is on the rising trend with every season
• The median was close to 5 in Season 9

Question 2 :What is the Winning percentage of each team after winning the toss

• The winning percentage is ~51%
• Toss being a match Winner is definately not the case.The chancesare 50-50 for both the teams

Question 3 :Player who has won the “man of the match” title, classify him as a batsman if he scored 20+ runs in that match, bowler if he took any wickets, and all-rounder if he did both. Now, for each IPL season, calculate the proportion of man-of-the-match awards being awarded to batsman, bowler or all-rounders, and show the trend across IPL seasons

head(q3)

##   Season_Id Match_Id Player_id Runs_Scored Wickets_Taken Player_Name
## 1         1   335987         2         158             0 BB McCullum
## 2         1   335988        19         116             0  MEK Hussey
## 3         1   335989        90           0             2 MF Maharoof
## 4         1   335990        11          39             0  MV Boucher
## 5         1   335991         4          38             1   DJ Hussey
## 6         1   335992        32          76             0   SR Watson
##    Identifier
## 1     Batsman
## 2     Batsman
## 3      Bowler
## 4     Batsman
## 5 All_Rounder
## 6     Batsman

3.1 Percetage plit of man-of-the-match awards being awarded to batsman, bowler or all-rounders

• On an Average 60% MOM has been awarded to Batsman,30% to Bowlers and ~10% to All Rounders
• Season 9 saw dip in No.of MOM awarded to Bowlers. The same was ~28%

Question 4 : Please do the analysis for “MS Dhoni” while considering the below parameters
- Number of runs scored
- Innings Comparison
- Strike Rate
- Favourite bowler, batting order, venue and team

head(q4)

##   Season_Id Venue_Id Match_Id Outcome_type Match_Winner Innings_No Bowler
## 1         1        2   335988            1            3          1     25
## 2         1        2   335988            1            3          1     29
## 3         1        8   335994            1            3          1     71
## 4         1        8   335994            1            3          1     72
## 5         1        8   335994            1            3          1     73
## 6         1        8   335994            1            3          1     80
##   Runes_Scored Player_Name
## 1            0    JR Hopes
## 2            2   IK Pathan
## 3            9    DJ Bravo
## 4           10    MA Khote
## 5            6     A Nehra
## 6            5 DS Kulkarni

Innings wise Runs split

Total Runs across Seasons

Box plot of Runs Scored across Seasons

Bowlers Dhoni Like

head(p7,15)

##    Bowler  Player_Name runs
## 1      94     DW Steyn  103
## 2     131      PP Ojha   98
## 3     221   KA Pollard   98
## 4      29    IK Pathan   80
## 5      73      A Nehra   76
## 6      15       Z Khan   74
## 7     194   SL Malinga   73
## 8     374     AR Patel   63
## 9      67    PP Chawla   59
## 10     71     DJ Bravo   55
## 11     27 Yuvraj Singh   53
## 12      9    JH Kallis   47
## 13     14      P Kumar   46
## 14     82   AB Agarkar   46
## 15     83     M Kartik   46