IPL Datasets Visualization
BY- ANUPAM SINGH TOMAR
Data preparation
Started by joining the two dataset together .
Matches.csv and deliveries.csv
Visualization
First prepared a season wise quick summary from the dataset
Calculated field
Batsman strike rate
-SUM([Batsman Runs])/COUNT([Ball])*100
Batting average
-Sum([Batsman Runs])/COUNT([Player Dismissed])
Bowler strike rate
-COUNT([Ball])/([wickets])
Count ID
-COUNTD([Id])
Sum of batsman runs
-SUM([Batsman Runs])
Percentage of batting and bowling chosen during toss
-IF [Toss Decision] = "bat" THEN 1 ELSE 0 END
Sum of wickets
-COUNT([Player Dismissed])
Visualization
For team analysis , I used:
- Winning analysis based on toss decision
- count of wins for each team
- percentage of batting and bowling chosen during toss
Visualization
For match analysis:
- found out the location on which matched were played
- found out player with most ‘Player of the match’
- calculated the strike rate of player at each venue
Visualization
For player analysis:
- for best batsman , I took the sum of runs.
- for best bowler , I took the count of player dismissed.
- found the performance of player over the years
- calculated strike rate of both batsman and bowler
- plotted a scatter plot graph to find the most valuable player
Visualization
For player analysis:
