# Load necessary libraries
library(dplyr)
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
library(ggplot2)
library(tidyverse)
## ── Attaching packages ──────────────────────────────────────────────── tidyverse 1.3.0 ──
## ✓ tibble  3.0.1     ✓ purrr   0.3.4
## ✓ tidyr   1.1.0     ✓ stringr 1.4.0
## ✓ readr   1.3.1     ✓ forcats 0.5.0
## ── Conflicts ─────────────────────────────────────────────────── tidyverse_conflicts() ──
## x dplyr::filter() masks stats::filter()
## x dplyr::lag()    masks stats::lag()
# Load the datasets
matches <- read.csv("matches.csv")
deliveries <- read.csv("deliveries.csv")
view(matches)
view(deliveries)

#Q1: number of matches that ended in a tie and played super over
tie_and_super_over <- matches %>%
  filter(result == "tie", dl_applied == 0) %>%
  nrow()

print(paste("Matches ended in tie and played super-over:", tie_and_super_over))
## [1] "Matches ended in tie and played super-over: 7"
#Q2: which team had won by max runs
max_run <- matches %>%
  filter(win_by_runs == max(win_by_runs, na.rm = TRUE)) %>%
  select(winner, venue, date, player_of_match, city, season)

print("Match with maximum run win:")
## [1] "Match with maximum run win:"
print(max_run)
##           winner            venue       date player_of_match  city season
## 1 Mumbai Indians Feroz Shah Kotla 06-05-2017     LMP Simmons Delhi   2017
#Q3: How many toss-winning teams have chosen to field and won?
toss_field_win <- matches %>%
  filter(toss_decision == "field", toss_winner == winner) %>%
  nrow()
total_matches <- nrow(matches)
percentage <- (toss_field_win / total_matches) * 100

print(paste("Toss-winning teams that chose to field and won:", toss_field_win))
## [1] "Toss-winning teams that chose to field and won: 201"
print(paste("Percentage:", round(percentage, 2), "%"))
## [1] "Percentage: 31.6 %"
#showing results visually
ggplot(matches, aes(x = toss_decision, fill = factor(toss_winner == winner))) +
  geom_bar(position = "dodge") +
  labs(title = "Toss Decision vs Match Outcome",
       x = "Toss Decision", y = "Count",
       fill = "Toss Winner Won?") +
  theme_minimal()

#Q4: number of toss winning team that played max dot balls
dot_balls <- deliveries %>% 
  filter(batsman_runs == 0)
dot_balls_by_match <- dot_balls %>% group_by(match_id, batting_team) %>% 
  summarise(dot_balls = n())
## `summarise()` regrouping output by 'match_id' (override with `.groups` argument)
max_dot_balls <- dot_balls_by_match %>% arrange(desc(dot_balls)) %>% 
  slice(1)
max_dot_balls_details <- matches %>% filter(id == max_dot_balls$match_id) %>% 
  select(id, toss_winner, team1, team2)
max_dot_balls_details
#Q5: Which team had won by maximum wicket, with player of the match as a batsman?
max_wicket_win <- matches %>% 
  filter(player_of_match == "batsman") %>% 
  arrange(desc(win_by_wickets)) %>% 
  slice(1)

max_wicket_win_info <- max_wicket_win %>% 
  select(winner, win_by_wickets, player_of_match, venue, date, city, season)

print(max_wicket_win_info)
## [1] winner          win_by_wickets  player_of_match venue          
## [5] date            city            season         
## <0 rows> (or 0-length row.names)
#Q6: Which player has received maximum player of the match awards? Also, show the 
# graphical view taking the franchise into consideration.
player_of_match_count <- matches %>% 
  group_by(player_of_match) %>% 
  summarise(awards = n()) %>% 
  arrange(desc(awards)) %>% 
  slice(1)
## `summarise()` ungrouping output (override with `.groups` argument)
# Plot for top 10 players
top_players <- matches %>% 
  group_by(player_of_match, team1, team2) %>% 
  summarise(awards = n()) %>% 
  arrange(desc(awards)) %>% 
  head(10)
## `summarise()` regrouping output by 'player_of_match', 'team1' (override with `.groups` argument)
# visualize team1
ggplot(top_players, aes(x = reorder(player_of_match, -awards), y = awards, fill = team1)) +
  geom_bar(stat = "identity") +
  coord_flip() +
  labs(title = "Top 10 Players with Most Player of the Match Awards",
       x = "Player",
       y = "Number of Awards")

# visualize team2
ggplot(top_players, aes(x = reorder(player_of_match, -awards), y = awards, fill = team2)) +
  geom_bar(stat = "identity") +
  coord_flip() +
  labs(title = "Top 10 Players with Most Player of the Match Awards",
       x = "Player",
       y = "Number of Awards")

#Q7:Which team has used a maximum number of bowlers in an innings?List their bowling statistics.
max_bowlers <- deliveries %>% 
  group_by(match_id, bowling_team) %>% 
  summarise(bowlers_used = n_distinct(bowler)) %>% 
  arrange(desc(bowlers_used)) %>% 
  slice(1)
## `summarise()` regrouping output by 'match_id' (override with `.groups` argument)
# Join with matches to get match details
max_bowlers_match <- matches %>% 
  filter(id == max_bowlers$match_id) %>% 
  select(id, team2, venue, date, city, season)
# Display bowling statistics for this match
bowling_stats <- deliveries %>% 
  filter(match_id == max_bowlers$match_id, bowling_team == max_bowlers$bowling_team) %>% 
  group_by(bowler) %>% 
  summarise(runs_conceded = sum(total_runs),
            wickets_taken = sum(player_dismissed != ""),
            balls_bowled = n()) %>% 
  mutate(economy = runs_conceded / (balls_bowled / 6))
## Warning in match_id == max_bowlers$match_id: longer object length is not a
## multiple of shorter object length
## Warning in bowling_team == max_bowlers$bowling_team: longer object length is not
## a multiple of shorter object length
## `summarise()` ungrouping output (override with `.groups` argument)
print(max_bowlers_match)
##      id                       team2
## 1     1 Royal Challengers Bangalore
## 2     2      Rising Pune Supergiant
## 3     3       Kolkata Knight Riders
## 4     4             Kings XI Punjab
## 5     5            Delhi Daredevils
## 6     6         Sunrisers Hyderabad
## 7     7              Mumbai Indians
## 8     8             Kings XI Punjab
## 9     9      Rising Pune Supergiant
## 10   10              Mumbai Indians
## 11   11       Kolkata Knight Riders
## 12   12              Mumbai Indians
## 13   13               Gujarat Lions
## 14   14         Sunrisers Hyderabad
## 15   15             Kings XI Punjab
## 16   16              Mumbai Indians
## 17   17 Royal Challengers Bangalore
## 18   18       Kolkata Knight Riders
## 19   19             Kings XI Punjab
## 20   20               Gujarat Lions
## 21   21            Delhi Daredevils
## 22   22              Mumbai Indians
## 23   23               Gujarat Lions
## 24   24            Delhi Daredevils
## 25   25      Rising Pune Supergiant
## 26   26               Gujarat Lions
## 27   27 Royal Challengers Bangalore
## 28   28              Mumbai Indians
## 29   29       Kolkata Knight Riders
## 30   30               Gujarat Lions
## 31   31       Kolkata Knight Riders
## 32   32             Kings XI Punjab
## 33   33 Royal Challengers Bangalore
## 34   34              Mumbai Indians
## 35   35             Kings XI Punjab
## 36   36       Kolkata Knight Riders
## 37   37              Mumbai Indians
## 38   38      Rising Pune Supergiant
## 39   39            Delhi Daredevils
## 40   40      Rising Pune Supergiant
## 41   41            Delhi Daredevils
## 42   42 Royal Challengers Bangalore
## 43   43         Sunrisers Hyderabad
## 44   44            Delhi Daredevils
## 45   45       Kolkata Knight Riders
## 46   46               Gujarat Lions
## 47   47         Sunrisers Hyderabad
## 48   48       Kolkata Knight Riders
## 49   49            Delhi Daredevils
## 50   50              Mumbai Indians
## 51   51      Rising Pune Supergiant
## 52   52         Sunrisers Hyderabad
## 53   53       Kolkata Knight Riders
## 54   54      Rising Pune Supergiant
## 55   55            Delhi Daredevils
## 56   56              Mumbai Indians
## 57   57       Kolkata Knight Riders
## 58   58              Mumbai Indians
## 59   59      Rising Pune Supergiant
## 60   60 Royal Challengers Bangalore
## 61   61             Kings XI Punjab
## 62   62            Delhi Daredevils
## 63   63 Royal Challengers Bangalore
## 64   64       Kolkata Knight Riders
## 65   65            Rajasthan Royals
## 66   66            Delhi Daredevils
## 67   67              Mumbai Indians
## 68   68            Rajasthan Royals
## 69   69              Mumbai Indians
## 70   70            Rajasthan Royals
## 71   71         Chennai Super Kings
## 72   72             Deccan Chargers
## 73   73             Kings XI Punjab
## 74   74 Royal Challengers Bangalore
## 75   75              Mumbai Indians
## 76   76 Royal Challengers Bangalore
## 77   77             Kings XI Punjab
## 78   78       Kolkata Knight Riders
## 79   79            Delhi Daredevils
## 80   80 Royal Challengers Bangalore
## 81   81       Kolkata Knight Riders
## 82   82            Delhi Daredevils
## 83   83            Rajasthan Royals
## 84   84             Kings XI Punjab
## 85   85             Deccan Chargers
## 86   86              Mumbai Indians
## 87   87         Chennai Super Kings
## 88   88 Royal Challengers Bangalore
## 89   89            Rajasthan Royals
## 90   90              Mumbai Indians
## 91   91             Kings XI Punjab
## 92   92             Deccan Chargers
## 93   93            Rajasthan Royals
## 94   94             Kings XI Punjab
## 95   95            Delhi Daredevils
## 96   96              Mumbai Indians
## 97   97            Rajasthan Royals
## 98   98             Deccan Chargers
## 99   99              Mumbai Indians
## 100 100             Kings XI Punjab
## 101 101 Royal Challengers Bangalore
## 102 102             Deccan Chargers
## 103 103         Chennai Super Kings
## 104 104            Delhi Daredevils
## 105 105            Rajasthan Royals
## 106 106              Mumbai Indians
## 107 107         Chennai Super Kings
## 108 108             Kings XI Punjab
## 109 109            Delhi Daredevils
## 110 110         Chennai Super Kings
## 111 111             Deccan Chargers
## 112 112       Kolkata Knight Riders
## 113 113            Rajasthan Royals
## 114 114         Chennai Super Kings
## 115 115            Delhi Daredevils
## 116 116         Chennai Super Kings
## 117 117            Rajasthan Royals
## 118 118         Chennai Super Kings
## 119 119            Rajasthan Royals
## 120 120            Delhi Daredevils
## 121 121             Deccan Chargers
## 122 122 Royal Challengers Bangalore
## 123 123       Kolkata Knight Riders
## 124 124 Royal Challengers Bangalore
## 125 125         Chennai Super Kings
## 126 126       Kolkata Knight Riders
## 127 127             Kings XI Punjab
## 128 128              Mumbai Indians
## 129 129            Delhi Daredevils
## 130 130            Rajasthan Royals
## 131 131             Deccan Chargers
## 132 132       Kolkata Knight Riders
## 133 133            Rajasthan Royals
## 134 134 Royal Challengers Bangalore
## 135 135              Mumbai Indians
## 136 136            Delhi Daredevils
## 137 137            Rajasthan Royals
## 138 138       Kolkata Knight Riders
## 139 139             Kings XI Punjab
## 140 140            Rajasthan Royals
## 141 141            Delhi Daredevils
## 142 142             Kings XI Punjab
## 143 143 Royal Challengers Bangalore
## 144 144             Deccan Chargers
## 145 145             Kings XI Punjab
## 146 146            Delhi Daredevils
## 147 147              Mumbai Indians
## 148 148            Rajasthan Royals
## 149 149             Kings XI Punjab
## 150 150            Delhi Daredevils
## 151 151             Kings XI Punjab
## 152 152         Chennai Super Kings
## 153 153 Royal Challengers Bangalore
## 154 154            Delhi Daredevils
## 155 155            Rajasthan Royals
## 156 156 Royal Challengers Bangalore
## 157 157              Mumbai Indians
## 158 158             Deccan Chargers
## 159 159 Royal Challengers Bangalore
## 160 160              Mumbai Indians
## 161 161             Kings XI Punjab
## 162 162         Chennai Super Kings
## 163 163             Deccan Chargers
## 164 164             Deccan Chargers
## 165 165            Rajasthan Royals
## 166 166       Kolkata Knight Riders
## 167 167 Royal Challengers Bangalore
## 168 168       Kolkata Knight Riders
## 169 169             Kings XI Punjab
## 170 170            Delhi Daredevils
## 171 171             Deccan Chargers
## 172 172             Deccan Chargers
## 173 173 Royal Challengers Bangalore
## 174 174 Royal Challengers Bangalore
## 175 175             Deccan Chargers
## 176 176            Rajasthan Royals
## 177 177            Delhi Daredevils
## 178 178       Kolkata Knight Riders
## 179 179         Chennai Super Kings
## 180 180            Delhi Daredevils
## 181 181 Royal Challengers Bangalore
## 182 182       Kolkata Knight Riders
## 183 183            Delhi Daredevils
## 184 184 Royal Challengers Bangalore
## 185 185         Chennai Super Kings
## 186 186             Kings XI Punjab
## 187 187       Kolkata Knight Riders
## 188 188 Royal Challengers Bangalore
## 189 189            Delhi Daredevils
## 190 190         Chennai Super Kings
## 191 191              Mumbai Indians
## 192 192         Chennai Super Kings
## 193 193             Kings XI Punjab
## 194 194              Mumbai Indians
## 195 195            Rajasthan Royals
## 196 196             Kings XI Punjab
## 197 197 Royal Challengers Bangalore
## 198 198         Chennai Super Kings
## 199 199             Deccan Chargers
## 200 200       Kolkata Knight Riders
## 201 201              Mumbai Indians
## 202 202         Chennai Super Kings
## 203 203            Rajasthan Royals
## 204 204             Deccan Chargers
## 205 205 Royal Challengers Bangalore
## 206 206            Rajasthan Royals
## 207 207             Deccan Chargers
## 208 208             Kings XI Punjab
## 209 209 Royal Challengers Bangalore
## 210 210             Deccan Chargers
## 211 211              Mumbai Indians
## 212 212            Rajasthan Royals
## 213 213            Delhi Daredevils
## 214 214             Deccan Chargers
## 215 215             Kings XI Punjab
## 216 216             Deccan Chargers
## 217 217 Royal Challengers Bangalore
## 218 218             Kings XI Punjab
## 219 219            Rajasthan Royals
## 220 220 Royal Challengers Bangalore
## 221 221            Delhi Daredevils
## 222 222         Chennai Super Kings
## 223 223 Royal Challengers Bangalore
## 224 224            Delhi Daredevils
## 225 225             Deccan Chargers
## 226 226 Royal Challengers Bangalore
## 227 227       Kolkata Knight Riders
## 228 228         Chennai Super Kings
## 229 229            Delhi Daredevils
## 230 230       Kolkata Knight Riders
## 231 231 Royal Challengers Bangalore
## 232 232             Deccan Chargers
## 233 233 Royal Challengers Bangalore
## 234 234              Mumbai Indians
## 235 235       Kolkata Knight Riders
## 236 236            Rajasthan Royals
## 237 237 Royal Challengers Bangalore
## 238 238              Mumbai Indians
## 239 239               Pune Warriors
## 240 240             Deccan Chargers
## 241 241            Rajasthan Royals
## 242 242              Mumbai Indians
## 243 243             Kings XI Punjab
## 244 244               Pune Warriors
## 245 245 Royal Challengers Bangalore
## 246 246       Kolkata Knight Riders
## 247 247        Kochi Tuskers Kerala
## 248 248 Royal Challengers Bangalore
## 249 249             Kings XI Punjab
## 250 250            Delhi Daredevils
## 251 251       Kolkata Knight Riders
## 252 252        Kochi Tuskers Kerala
## 253 253            Delhi Daredevils
## 254 254              Mumbai Indians
## 255 255       Kolkata Knight Riders
## 256 256            Rajasthan Royals
## 257 257         Chennai Super Kings
## 258 258 Royal Challengers Bangalore
## 259 259             Kings XI Punjab
## 260 260             Deccan Chargers
## 261 261            Rajasthan Royals
## 262 262               Pune Warriors
## 263 263 Royal Challengers Bangalore
## 264 264         Chennai Super Kings
## 265 265        Kochi Tuskers Kerala
## 266 266            Delhi Daredevils
## 267 267            Rajasthan Royals
## 268 268               Pune Warriors
## 269 269        Kochi Tuskers Kerala
## 270 270       Kolkata Knight Riders
## 271 271            Rajasthan Royals
## 272 272             Deccan Chargers
## 273 273             Kings XI Punjab
## 274 274        Kochi Tuskers Kerala
## 275 275             Deccan Chargers
## 276 276         Chennai Super Kings
## 277 277               Pune Warriors
## 278 278       Kolkata Knight Riders
## 279 279            Delhi Daredevils
## 280 280             Kings XI Punjab
## 281 281       Kolkata Knight Riders
## 282 282            Delhi Daredevils
## 283 283 Royal Challengers Bangalore
## 284 284               Pune Warriors
## 285 285            Rajasthan Royals
## 286 286               Pune Warriors
## 287 287              Mumbai Indians
## 288 288 Royal Challengers Bangalore
## 289 289            Delhi Daredevils
## 290 290             Kings XI Punjab
## 291 291 Royal Challengers Bangalore
## 292 292              Mumbai Indians
## 293 293            Delhi Daredevils
## 294 294        Kochi Tuskers Kerala
## 295 295             Deccan Chargers
## 296 296 Royal Challengers Bangalore
## 297 297        Kochi Tuskers Kerala
## 298 298       Kolkata Knight Riders
## 299 299            Rajasthan Royals
## 300 300             Kings XI Punjab
## 301 301               Pune Warriors
## 302 302 Royal Challengers Bangalore
## 303 303              Mumbai Indians
## 304 304         Chennai Super Kings
## 305 305              Mumbai Indians
## 306 306              Mumbai Indians
## 307 307 Royal Challengers Bangalore
## 308 308              Mumbai Indians
## 309 309            Delhi Daredevils
## 310 310              Mumbai Indians
## 311 311             Kings XI Punjab
## 312 312            Delhi Daredevils
## 313 313             Deccan Chargers
## 314 314       Kolkata Knight Riders
## 315 315             Kings XI Punjab
## 316 316              Mumbai Indians
## 317 317 Royal Challengers Bangalore
## 318 318            Delhi Daredevils
## 319 319            Rajasthan Royals
## 320 320         Chennai Super Kings
## 321 321             Kings XI Punjab
## 322 322       Kolkata Knight Riders
## 323 323            Delhi Daredevils
## 324 324               Pune Warriors
## 325 325       Kolkata Knight Riders
## 326 326 Royal Challengers Bangalore
## 327 327            Delhi Daredevils
## 328 328            Rajasthan Royals
## 329 329 Royal Challengers Bangalore
## 330 330       Kolkata Knight Riders
## 331 331            Delhi Daredevils
## 332 332               Pune Warriors
## 333 333 Royal Challengers Bangalore
## 334 334         Chennai Super Kings
## 335 335            Delhi Daredevils
## 336 336             Kings XI Punjab
## 337 337       Kolkata Knight Riders
## 338 338            Rajasthan Royals
## 339 339            Delhi Daredevils
## 340 340              Mumbai Indians
## 341 341               Pune Warriors
## 342 342              Mumbai Indians
## 343 343         Chennai Super Kings
## 344 344 Royal Challengers Bangalore
## 345 345            Rajasthan Royals
## 346 346              Mumbai Indians
## 347 347       Kolkata Knight Riders
## 348 348               Pune Warriors
## 349 349            Delhi Daredevils
## 350 350             Kings XI Punjab
## 351 351               Pune Warriors
## 352 352             Deccan Chargers
## 353 353               Pune Warriors
## 354 354             Kings XI Punjab
## 355 355              Mumbai Indians
## 356 356 Royal Challengers Bangalore
## 357 357       Kolkata Knight Riders
## 358 358            Rajasthan Royals
## 359 359             Deccan Chargers
## 360 360 Royal Challengers Bangalore
## 361 361         Chennai Super Kings
## 362 362               Pune Warriors
## 363 363       Kolkata Knight Riders
## 364 364         Chennai Super Kings
## 365 365               Pune Warriors
## 366 366             Kings XI Punjab
## 367 367              Mumbai Indians
## 368 368         Chennai Super Kings
## 369 369            Delhi Daredevils
## 370 370              Mumbai Indians
## 371 371             Kings XI Punjab
## 372 372            Delhi Daredevils
## 373 373             Deccan Chargers
## 374 374            Delhi Daredevils
## 375 375               Pune Warriors
## 376 376 Royal Challengers Bangalore
## 377 377              Mumbai Indians
## 378 378            Delhi Daredevils
## 379 379              Mumbai Indians
## 380 380            Delhi Daredevils
## 381 381       Kolkata Knight Riders
## 382 382       Kolkata Knight Riders
## 383 383              Mumbai Indians
## 384 384               Pune Warriors
## 385 385            Delhi Daredevils
## 386 386         Chennai Super Kings
## 387 387             Kings XI Punjab
## 388 388         Sunrisers Hyderabad
## 389 389       Kolkata Knight Riders
## 390 390            Delhi Daredevils
## 391 391         Chennai Super Kings
## 392 392 Royal Challengers Bangalore
## 393 393               Pune Warriors
## 394 394         Sunrisers Hyderabad
## 395 395               Pune Warriors
## 396 396         Chennai Super Kings
## 397 397         Sunrisers Hyderabad
## 398 398            Rajasthan Royals
## 399 399         Chennai Super Kings
## 400 400       Kolkata Knight Riders
## 401 401 Royal Challengers Bangalore
## 402 402               Pune Warriors
## 403 403              Mumbai Indians
## 404 404            Delhi Daredevils
## 405 405         Sunrisers Hyderabad
## 406 406         Chennai Super Kings
## 407 407 Royal Challengers Bangalore
## 408 408            Delhi Daredevils
## 409 409             Kings XI Punjab
## 410 410         Chennai Super Kings
## 411 411               Pune Warriors
## 412 412            Delhi Daredevils
## 413 413              Mumbai Indians
## 414 414         Chennai Super Kings
## 415 415       Kolkata Knight Riders
## 416 416            Rajasthan Royals
## 417 417 Royal Challengers Bangalore
## 418 418       Kolkata Knight Riders
## 419 419               Pune Warriors
## 420 420            Rajasthan Royals
## 421 421             Kings XI Punjab
## 422 422               Pune Warriors
## 423 423         Sunrisers Hyderabad
## 424 424            Delhi Daredevils
## 425 425             Kings XI Punjab
## 426 426               Pune Warriors
## 427 427       Kolkata Knight Riders
## 428 428         Sunrisers Hyderabad
## 429 429             Kings XI Punjab
## 430 430         Chennai Super Kings
## 431 431            Rajasthan Royals
## 432 432 Royal Challengers Bangalore
## 433 433            Rajasthan Royals
## 434 434       Kolkata Knight Riders
## 435 435         Sunrisers Hyderabad
## 436 436            Rajasthan Royals
## 437 437               Pune Warriors
## 438 438            Delhi Daredevils
## 439 439              Mumbai Indians
## 440 440             Kings XI Punjab
## 441 441       Kolkata Knight Riders
## 442 442            Rajasthan Royals
## 443 443             Kings XI Punjab
## 444 444              Mumbai Indians
## 445 445       Kolkata Knight Riders
## 446 446            Delhi Daredevils
## 447 447            Rajasthan Royals
## 448 448             Kings XI Punjab
## 449 449            Rajasthan Royals
## 450 450              Mumbai Indians
## 451 451            Delhi Daredevils
## 452 452         Chennai Super Kings
## 453 453         Sunrisers Hyderabad
## 454 454              Mumbai Indians
## 455 455            Rajasthan Royals
## 456 456              Mumbai Indians
## 457 457         Chennai Super Kings
## 458 458              Mumbai Indians
## 459 459 Royal Challengers Bangalore
## 460 460             Kings XI Punjab
## 461 461            Rajasthan Royals
## 462 462 Royal Challengers Bangalore
## 463 463            Delhi Daredevils
## 464 464             Kings XI Punjab
## 465 465            Delhi Daredevils
## 466 466         Sunrisers Hyderabad
## 467 467            Rajasthan Royals
## 468 468 Royal Challengers Bangalore
## 469 469            Delhi Daredevils
## 470 470         Chennai Super Kings
## 471 471            Rajasthan Royals
## 472 472       Kolkata Knight Riders
## 473 473            Delhi Daredevils
## 474 474         Chennai Super Kings
## 475 475             Kings XI Punjab
## 476 476       Kolkata Knight Riders
## 477 477              Mumbai Indians
## 478 478       Kolkata Knight Riders
## 479 479              Mumbai Indians
## 480 480            Rajasthan Royals
## 481 481 Royal Challengers Bangalore
## 482 482       Kolkata Knight Riders
## 483 483         Chennai Super Kings
## 484 484 Royal Challengers Bangalore
## 485 485       Kolkata Knight Riders
## 486 486         Chennai Super Kings
## 487 487            Rajasthan Royals
## 488 488 Royal Challengers Bangalore
## 489 489         Sunrisers Hyderabad
## 490 490         Chennai Super Kings
## 491 491       Kolkata Knight Riders
## 492 492            Rajasthan Royals
## 493 493              Mumbai Indians
## 494 494         Chennai Super Kings
## 495 495            Delhi Daredevils
## 496 496             Kings XI Punjab
## 497 497       Kolkata Knight Riders
## 498 498            Delhi Daredevils
## 499 499 Royal Challengers Bangalore
## 500 500       Kolkata Knight Riders
## 501 501            Rajasthan Royals
## 502 502             Kings XI Punjab
## 503 503         Sunrisers Hyderabad
## 504 504       Kolkata Knight Riders
## 505 505              Mumbai Indians
## 506 506 Royal Challengers Bangalore
## 507 507         Sunrisers Hyderabad
## 508 508            Delhi Daredevils
## 509 509            Rajasthan Royals
## 510 510         Chennai Super Kings
## 511 511       Kolkata Knight Riders
## 512 512             Kings XI Punjab
## 513 513              Mumbai Indians
## 514 514             Kings XI Punjab
## 515 515         Chennai Super Kings
## 516 516         Chennai Super Kings
## 517 517       Kolkata Knight Riders
## 518 518       Kolkata Knight Riders
## 519 519            Delhi Daredevils
## 520 520             Kings XI Punjab
## 521 521         Sunrisers Hyderabad
## 522 522 Royal Challengers Bangalore
## 523 523            Rajasthan Royals
## 524 524              Mumbai Indians
## 525 525         Sunrisers Hyderabad
## 526 526            Rajasthan Royals
## 527 527       Kolkata Knight Riders
## 528 528            Delhi Daredevils
## 529 529            Rajasthan Royals
## 530 530         Chennai Super Kings
## 531 531         Sunrisers Hyderabad
## 532 532       Kolkata Knight Riders
## 533 533            Rajasthan Royals
## 534 534 Royal Challengers Bangalore
## 535 535       Kolkata Knight Riders
## 536 536             Kings XI Punjab
## 537 537       Kolkata Knight Riders
## 538 538 Royal Challengers Bangalore
## 539 539              Mumbai Indians
## 540 540 Royal Challengers Bangalore
## 541 541         Sunrisers Hyderabad
## 542 542             Kings XI Punjab
## 543 543 Royal Challengers Bangalore
## 544 544             Kings XI Punjab
## 545 545            Delhi Daredevils
## 546 546            Rajasthan Royals
## 547 547       Kolkata Knight Riders
## 548 548            Delhi Daredevils
## 549 549            Rajasthan Royals
## 550 550 Royal Challengers Bangalore
## 551 551         Chennai Super Kings
## 552 552             Kings XI Punjab
## 553 553            Delhi Daredevils
## 554 554 Royal Challengers Bangalore
## 555 555         Sunrisers Hyderabad
## 556 556              Mumbai Indians
## 557 557             Kings XI Punjab
## 558 558            Rajasthan Royals
## 559 559              Mumbai Indians
## 560 560       Kolkata Knight Riders
## 561 561            Delhi Daredevils
## 562 562              Mumbai Indians
## 563 563            Rajasthan Royals
## 564 564             Kings XI Punjab
## 565 565            Delhi Daredevils
## 566 566 Royal Challengers Bangalore
## 567 567       Kolkata Knight Riders
## 568 568 Royal Challengers Bangalore
## 569 569         Chennai Super Kings
## 570 570       Kolkata Knight Riders
## 571 571 Royal Challengers Bangalore
## 572 572              Mumbai Indians
## 573 573         Chennai Super Kings
## 574 574            Rajasthan Royals
## 575 575         Chennai Super Kings
## 576 576         Chennai Super Kings
## 577 577     Rising Pune Supergiants
## 578 578       Kolkata Knight Riders
## 579 579               Gujarat Lions
## 580 580         Sunrisers Hyderabad
## 581 581              Mumbai Indians
## 582 582               Gujarat Lions
## 583 583            Delhi Daredevils
## 584 584       Kolkata Knight Riders
## 585 585               Gujarat Lions
## 586 586             Kings XI Punjab
## 587 587            Delhi Daredevils
## 588 588         Sunrisers Hyderabad
## 589 589       Kolkata Knight Riders
## 590 590              Mumbai Indians
## 591 591         Sunrisers Hyderabad
## 592 592     Rising Pune Supergiants
## 593 593              Mumbai Indians
## 594 594         Sunrisers Hyderabad
## 595 595               Gujarat Lions
## 596 596       Kolkata Knight Riders
## 597 597             Kings XI Punjab
## 598 598     Rising Pune Supergiants
## 599 599            Delhi Daredevils
## 600 600              Mumbai Indians
## 601 601               Gujarat Lions
## 602 602       Kolkata Knight Riders
## 603 603 Royal Challengers Bangalore
## 604 604               Gujarat Lions
## 605 605              Mumbai Indians
## 606 606       Kolkata Knight Riders
## 607 607            Delhi Daredevils
## 608 608             Kings XI Punjab
## 609 609     Rising Pune Supergiants
## 610 610         Sunrisers Hyderabad
## 611 611 Royal Challengers Bangalore
## 612 612            Delhi Daredevils
## 613 613              Mumbai Indians
## 614 614               Gujarat Lions
## 615 615             Kings XI Punjab
## 616 616     Rising Pune Supergiants
## 617 617              Mumbai Indians
## 618 618            Delhi Daredevils
## 619 619             Kings XI Punjab
## 620 620               Gujarat Lions
## 621 621       Kolkata Knight Riders
## 622 622         Sunrisers Hyderabad
## 623 623            Delhi Daredevils
## 624 624 Royal Challengers Bangalore
## 625 625     Rising Pune Supergiants
## 626 626             Kings XI Punjab
## 627 627               Gujarat Lions
## 628 628            Delhi Daredevils
## 629 629     Rising Pune Supergiants
## 630 630               Gujarat Lions
## 631 631         Sunrisers Hyderabad
## 632 632 Royal Challengers Bangalore
## 633 633 Royal Challengers Bangalore
## 634 634       Kolkata Knight Riders
## 635 635         Sunrisers Hyderabad
## 636 636 Royal Challengers Bangalore
##                                                    venue       date
## 1              Rajiv Gandhi International Stadium, Uppal 05-04-2017
## 2                Maharashtra Cricket Association Stadium 06-04-2017
## 3                 Saurashtra Cricket Association Stadium 07-04-2017
## 4                                 Holkar Cricket Stadium 08-04-2017
## 5                                  M Chinnaswamy Stadium 08-04-2017
## 6              Rajiv Gandhi International Stadium, Uppal 09-04-2017
## 7                                       Wankhede Stadium 09-04-2017
## 8                                 Holkar Cricket Stadium 10-04-2017
## 9                Maharashtra Cricket Association Stadium 11-04-2017
## 10                                      Wankhede Stadium 12-04-2017
## 11                                          Eden Gardens 13-04-2017
## 12                                 M Chinnaswamy Stadium 14-04-2017
## 13                Saurashtra Cricket Association Stadium 14-04-2017
## 14                                          Eden Gardens 15-04-2017
## 15                                      Feroz Shah Kotla 15-04-2017
## 16                                      Wankhede Stadium 16-04-2017
## 17                                 M Chinnaswamy Stadium 16-04-2017
## 18                                      Feroz Shah Kotla 17-04-2017
## 19             Rajiv Gandhi International Stadium, Uppal 17-04-2017
## 20                Saurashtra Cricket Association Stadium 18-04-2017
## 21             Rajiv Gandhi International Stadium, Uppal 19-04-2017
## 22                                Holkar Cricket Stadium 20-04-2017
## 23                                          Eden Gardens 21-04-2017
## 24                                      Wankhede Stadium 22-04-2017
## 25               Maharashtra Cricket Association Stadium 22-04-2017
## 26                Saurashtra Cricket Association Stadium 23-04-2017
## 27                                          Eden Gardens 23-04-2017
## 28                                      Wankhede Stadium 24-04-2017
## 29               Maharashtra Cricket Association Stadium 26-04-2017
## 30                                 M Chinnaswamy Stadium 27-04-2017
## 31                                          Eden Gardens 28-04-2017
## 32  Punjab Cricket Association IS Bindra Stadium, Mohali 28-04-2017
## 33               Maharashtra Cricket Association Stadium 29-04-2017
## 34                Saurashtra Cricket Association Stadium 29-04-2017
## 35  Punjab Cricket Association IS Bindra Stadium, Mohali 30-04-2017
## 36             Rajiv Gandhi International Stadium, Uppal 30-04-2017
## 37                                      Wankhede Stadium 01-05-2017
## 38               Maharashtra Cricket Association Stadium 01-05-2017
## 39                                      Feroz Shah Kotla 02-05-2017
## 40                                          Eden Gardens 03-05-2017
## 41                                      Feroz Shah Kotla 04-05-2017
## 42                                 M Chinnaswamy Stadium 05-05-2017
## 43             Rajiv Gandhi International Stadium, Uppal 06-05-2017
## 44                                      Feroz Shah Kotla 06-05-2017
## 45                                 M Chinnaswamy Stadium 07-05-2017
## 46  Punjab Cricket Association IS Bindra Stadium, Mohali 07-05-2017
## 47             Rajiv Gandhi International Stadium, Uppal 08-05-2017
## 48  Punjab Cricket Association IS Bindra Stadium, Mohali 09-05-2017
## 49                                            Green Park 10-05-2017
## 50                                      Wankhede Stadium 11-05-2017
## 51                                      Feroz Shah Kotla 12-05-2017
## 52                                            Green Park 13-05-2017
## 53                                          Eden Gardens 13-05-2017
## 54               Maharashtra Cricket Association Stadium 14-05-2017
## 55                                      Feroz Shah Kotla 14-05-2017
## 56                                      Wankhede Stadium 16-05-2017
## 57                                 M Chinnaswamy Stadium 17-05-2017
## 58                                 M Chinnaswamy Stadium 19-05-2017
## 59             Rajiv Gandhi International Stadium, Uppal 21-05-2017
## 60                                 M Chinnaswamy Stadium 18-04-2008
## 61            Punjab Cricket Association Stadium, Mohali 19-04-2008
## 62                                      Feroz Shah Kotla 19-04-2008
## 63                                      Wankhede Stadium 20-04-2008
## 64                                          Eden Gardens 20-04-2008
## 65                                Sawai Mansingh Stadium 21-04-2008
## 66             Rajiv Gandhi International Stadium, Uppal 22-04-2008
## 67                       MA Chidambaram Stadium, Chepauk 23-04-2008
## 68             Rajiv Gandhi International Stadium, Uppal 24-04-2008
## 69            Punjab Cricket Association Stadium, Mohali 25-04-2008
## 70                                 M Chinnaswamy Stadium 26-04-2008
## 71                       MA Chidambaram Stadium, Chepauk 26-04-2008
## 72                            Dr DY Patil Sports Academy 27-04-2008
## 73            Punjab Cricket Association Stadium, Mohali 27-04-2008
## 74                                 M Chinnaswamy Stadium 28-04-2008
## 75                                          Eden Gardens 29-04-2008
## 76                                      Feroz Shah Kotla 30-04-2008
## 77             Rajiv Gandhi International Stadium, Uppal 01-05-2008
## 78                                Sawai Mansingh Stadium 01-05-2008
## 79                       MA Chidambaram Stadium, Chepauk 02-05-2008
## 80             Rajiv Gandhi International Stadium, Uppal 25-05-2008
## 81            Punjab Cricket Association Stadium, Mohali 03-05-2008
## 82                            Dr DY Patil Sports Academy 04-05-2008
## 83                                Sawai Mansingh Stadium 04-05-2008
## 84                                 M Chinnaswamy Stadium 05-05-2008
## 85                       MA Chidambaram Stadium, Chepauk 06-05-2008
## 86                            Dr DY Patil Sports Academy 07-05-2008
## 87                                      Feroz Shah Kotla 08-05-2008
## 88                                          Eden Gardens 08-05-2008
## 89                                Sawai Mansingh Stadium 09-05-2008
## 90                                 M Chinnaswamy Stadium 28-05-2008
## 91                       MA Chidambaram Stadium, Chepauk 10-05-2008
## 92             Rajiv Gandhi International Stadium, Uppal 11-05-2008
## 93                                Sawai Mansingh Stadium 11-05-2008
## 94            Punjab Cricket Association Stadium, Mohali 12-05-2008
## 95                                          Eden Gardens 13-05-2008
## 96                                      Wankhede Stadium 14-05-2008
## 97            Punjab Cricket Association Stadium, Mohali 28-05-2008
## 98                                      Feroz Shah Kotla 15-05-2008
## 99                                      Wankhede Stadium 16-05-2008
## 100                                     Feroz Shah Kotla 17-05-2008
## 101                               Sawai Mansingh Stadium 17-05-2008
## 102            Rajiv Gandhi International Stadium, Uppal 18-05-2008
## 103                                         Eden Gardens 18-05-2008
## 104                                M Chinnaswamy Stadium 19-05-2008
## 105                                         Eden Gardens 20-05-2008
## 106                                     Wankhede Stadium 21-05-2008
## 107                      MA Chidambaram Stadium, Chepauk 21-05-2008
## 108           Punjab Cricket Association Stadium, Mohali 23-05-2008
## 109                                     Feroz Shah Kotla 24-05-2008
## 110                      MA Chidambaram Stadium, Chepauk 24-05-2008
## 111                                M Chinnaswamy Stadium 03-05-2008
## 112                                         Eden Gardens 25-05-2008
## 113                               Sawai Mansingh Stadium 26-05-2008
## 114            Rajiv Gandhi International Stadium, Uppal 27-05-2008
## 115                                     Wankhede Stadium 30-05-2008
## 116                                     Wankhede Stadium 31-05-2008
## 117                           Dr DY Patil Sports Academy 01-06-2008
## 118                                             Newlands 18-04-2009
## 119                                             Newlands 18-04-2009
## 120                                             Newlands 19-04-2009
## 121                                             Newlands 19-04-2009
## 122                                     St George's Park 20-04-2009
## 123                                            Kingsmead 21-04-2009
## 124                                             Newlands 22-04-2009
## 125                                            Kingsmead 23-04-2009
## 126                                             Newlands 23-04-2009
## 127                                            Kingsmead 24-04-2009
## 128                                            Kingsmead 25-04-2009
## 129                                     St George's Park 26-04-2009
## 130                                             Newlands 26-04-2009
## 131                                            Kingsmead 27-04-2009
## 132                                     St George's Park 27-04-2009
## 133                                      SuperSport Park 28-04-2009
## 134                                            Kingsmead 29-04-2009
## 135                                            Kingsmead 29-04-2009
## 136                                      SuperSport Park 30-04-2009
## 137                                      SuperSport Park 30-04-2009
## 138                                         Buffalo Park 01-05-2009
## 139                                            Kingsmead 01-05-2009
## 140                                     St George's Park 02-05-2009
## 141                                New Wanderers Stadium 02-05-2009
## 142                                     St George's Park 03-05-2009
## 143                                New Wanderers Stadium 03-05-2009
## 144                                         Buffalo Park 04-05-2009
## 145                                            Kingsmead 05-05-2009
## 146                                            Kingsmead 05-05-2009
## 147                                      SuperSport Park 06-05-2009
## 148                                      SuperSport Park 07-05-2009
## 149                                      SuperSport Park 07-05-2009
## 150                                         Buffalo Park 08-05-2009
## 151                                De Beers Diamond Oval 09-05-2009
## 152                                De Beers Diamond Oval 09-05-2009
## 153                                     St George's Park 10-05-2009
## 154                                New Wanderers Stadium 10-05-2009
## 155                                De Beers Diamond Oval 11-05-2009
## 156                                      SuperSport Park 12-05-2009
## 157                                      SuperSport Park 12-05-2009
## 158                                            Kingsmead 13-05-2009
## 159                                            Kingsmead 14-05-2009
## 160                                            Kingsmead 14-05-2009
## 161                                      OUTsurance Oval 15-05-2009
## 162                                     St George's Park 16-05-2009
## 163                                New Wanderers Stadium 16-05-2009
## 164                                New Wanderers Stadium 17-05-2009
## 165                                      OUTsurance Oval 17-05-2009
## 166                                      SuperSport Park 18-05-2009
## 167                                New Wanderers Stadium 19-05-2009
## 168                                            Kingsmead 20-05-2009
## 169                                            Kingsmead 20-05-2009
## 170                                      SuperSport Park 21-05-2009
## 171                                      SuperSport Park 21-05-2009
## 172                                      SuperSport Park 22-05-2009
## 173                                New Wanderers Stadium 23-05-2009
## 174                                New Wanderers Stadium 24-05-2009
## 175                           Dr DY Patil Sports Academy 12-03-2010
## 176                                    Brabourne Stadium 13-03-2010
## 177           Punjab Cricket Association Stadium, Mohali 13-03-2010
## 178                                         Eden Gardens 14-03-2010
## 179                      MA Chidambaram Stadium, Chepauk 14-03-2010
## 180                         Sardar Patel Stadium, Motera 15-03-2010
## 181                                M Chinnaswamy Stadium 16-03-2010
## 182                                         Eden Gardens 16-03-2010
## 183                                     Feroz Shah Kotla 17-03-2010
## 184                                M Chinnaswamy Stadium 18-03-2010
## 185                                     Feroz Shah Kotla 19-03-2010
## 186                                     Barabati Stadium 19-03-2010
## 187                         Sardar Patel Stadium, Motera 20-03-2010
## 188                                    Brabourne Stadium 20-03-2010
## 189                                     Barabati Stadium 21-03-2010
## 190                      MA Chidambaram Stadium, Chepauk 21-03-2010
## 191                                    Brabourne Stadium 22-03-2010
## 192                                M Chinnaswamy Stadium 23-03-2010
## 193           Punjab Cricket Association Stadium, Mohali 24-03-2010
## 194                                    Brabourne Stadium 25-03-2010
## 195                         Sardar Patel Stadium, Motera 26-03-2010
## 196           Punjab Cricket Association Stadium, Mohali 27-03-2010
## 197                                M Chinnaswamy Stadium 25-03-2010
## 198                         Sardar Patel Stadium, Motera 28-03-2010
## 199                           Dr DY Patil Sports Academy 28-03-2010
## 200                                     Feroz Shah Kotla 29-03-2010
## 201                                    Brabourne Stadium 30-03-2010
## 202                      MA Chidambaram Stadium, Chepauk 31-03-2010
## 203                                     Feroz Shah Kotla 31-03-2010
## 204                                         Eden Gardens 01-04-2010
## 205           Punjab Cricket Association Stadium, Mohali 02-04-2010
## 206                      MA Chidambaram Stadium, Chepauk 03-04-2010
## 207                                    Brabourne Stadium 03-04-2010
## 208                                         Eden Gardens 04-04-2010
## 209                                     Feroz Shah Kotla 04-04-2010
## 210         Vidarbha Cricket Association Stadium, Jamtha 05-04-2010
## 211                      MA Chidambaram Stadium, Chepauk 06-04-2010
## 212                               Sawai Mansingh Stadium 07-04-2010
## 213                                         Eden Gardens 07-04-2010
## 214                                M Chinnaswamy Stadium 08-04-2010
## 215           Punjab Cricket Association Stadium, Mohali 09-04-2010
## 216         Vidarbha Cricket Association Stadium, Jamtha 10-04-2010
## 217                                M Chinnaswamy Stadium 10-04-2010
## 218                                     Feroz Shah Kotla 11-04-2010
## 219                               Sawai Mansingh Stadium 11-04-2010
## 220         Vidarbha Cricket Association Stadium, Jamtha 12-04-2010
## 221                                    Brabourne Stadium 13-04-2010
## 222                      MA Chidambaram Stadium, Chepauk 13-04-2010
## 223                               Sawai Mansingh Stadium 14-04-2010
## 224                      MA Chidambaram Stadium, Chepauk 15-04-2010
## 225         Himachal Pradesh Cricket Association Stadium 16-04-2010
## 226                                M Chinnaswamy Stadium 17-04-2010
## 227                                         Eden Gardens 17-04-2010
## 228         Himachal Pradesh Cricket Association Stadium 18-04-2010
## 229                                     Feroz Shah Kotla 18-04-2010
## 230                                         Eden Gardens 19-04-2010
## 231                           Dr DY Patil Sports Academy 21-04-2010
## 232                           Dr DY Patil Sports Academy 22-04-2010
## 233                           Dr DY Patil Sports Academy 24-04-2010
## 234                           Dr DY Patil Sports Academy 25-04-2010
## 235                      MA Chidambaram Stadium, Chepauk 08-04-2011
## 236            Rajiv Gandhi International Stadium, Uppal 09-04-2011
## 237                                        Nehru Stadium 09-04-2011
## 238                                     Feroz Shah Kotla 10-04-2011
## 239                           Dr DY Patil Sports Academy 10-04-2011
## 240                                         Eden Gardens 11-04-2011
## 241                               Sawai Mansingh Stadium 12-04-2011
## 242                                M Chinnaswamy Stadium 12-04-2011
## 243           Punjab Cricket Association Stadium, Mohali 13-04-2011
## 244                           Dr DY Patil Sports Academy 13-04-2011
## 245            Rajiv Gandhi International Stadium, Uppal 14-04-2011
## 246                               Sawai Mansingh Stadium 15-04-2011
## 247                                     Wankhede Stadium 15-04-2011
## 248                      MA Chidambaram Stadium, Chepauk 16-04-2011
## 249            Rajiv Gandhi International Stadium, Uppal 16-04-2011
## 250                           Dr DY Patil Sports Academy 17-04-2011
## 251                                         Eden Gardens 17-04-2011
## 252                                        Nehru Stadium 18-04-2011
## 253                                     Feroz Shah Kotla 19-04-2011
## 254                                     Wankhede Stadium 20-04-2011
## 255                                         Eden Gardens 20-04-2011
## 256           Punjab Cricket Association Stadium, Mohali 21-04-2011
## 257                                     Wankhede Stadium 22-04-2011
## 258                                         Eden Gardens 22-04-2011
## 259                                     Feroz Shah Kotla 23-04-2011
## 260            Rajiv Gandhi International Stadium, Uppal 24-04-2011
## 261                               Sawai Mansingh Stadium 24-04-2011
## 262                      MA Chidambaram Stadium, Chepauk 25-04-2011
## 263                                     Feroz Shah Kotla 26-04-2011
## 264                           Dr DY Patil Sports Academy 27-04-2011
## 265                                        Nehru Stadium 27-04-2011
## 266                                     Feroz Shah Kotla 28-04-2011
## 267                               Sawai Mansingh Stadium 29-04-2011
## 268                                M Chinnaswamy Stadium 29-04-2011
## 269                                        Nehru Stadium 30-04-2011
## 270                                         Eden Gardens 30-04-2011
## 271                               Sawai Mansingh Stadium 01-05-2011
## 272                      MA Chidambaram Stadium, Chepauk 01-05-2011
## 273                                     Wankhede Stadium 02-05-2011
## 274                                     Feroz Shah Kotla 02-05-2011
## 275            Rajiv Gandhi International Stadium, Uppal 03-05-2011
## 276                      MA Chidambaram Stadium, Chepauk 04-05-2011
## 277                           Dr DY Patil Sports Academy 04-05-2011
## 278                                        Nehru Stadium 05-05-2011
## 279            Rajiv Gandhi International Stadium, Uppal 05-05-2011
## 280                                M Chinnaswamy Stadium 06-05-2011
## 281                                         Eden Gardens 07-05-2011
## 282                                     Wankhede Stadium 07-05-2011
## 283                                M Chinnaswamy Stadium 08-05-2011
## 284           Punjab Cricket Association Stadium, Mohali 08-05-2011
## 285                               Sawai Mansingh Stadium 09-05-2011
## 286            Rajiv Gandhi International Stadium, Uppal 10-05-2011
## 287           Punjab Cricket Association Stadium, Mohali 10-05-2011
## 288                               Sawai Mansingh Stadium 11-05-2011
## 289                      MA Chidambaram Stadium, Chepauk 12-05-2011
## 290                               Holkar Cricket Stadium 13-05-2011
## 291                                M Chinnaswamy Stadium 14-05-2011
## 292                                     Wankhede Stadium 14-05-2011
## 293         Himachal Pradesh Cricket Association Stadium 15-05-2011
## 294                               Holkar Cricket Stadium 15-05-2011
## 295                           Dr DY Patil Sports Academy 16-05-2011
## 296         Himachal Pradesh Cricket Association Stadium 17-05-2011
## 297                      MA Chidambaram Stadium, Chepauk 18-05-2011
## 298                           Dr DY Patil Sports Academy 19-05-2011
## 299                                     Wankhede Stadium 20-05-2011
## 300         Himachal Pradesh Cricket Association Stadium 21-05-2011
## 301                                     Feroz Shah Kotla 21-05-2011
## 302                                M Chinnaswamy Stadium 22-05-2011
## 303                                         Eden Gardens 22-05-2011
## 304                                     Wankhede Stadium 24-05-2011
## 305                                     Wankhede Stadium 25-05-2011
## 306                      MA Chidambaram Stadium, Chepauk 27-05-2011
## 307                      MA Chidambaram Stadium, Chepauk 28-05-2011
## 308                      MA Chidambaram Stadium, Chepauk 04-04-2012
## 309                                         Eden Gardens 05-04-2012
## 310                                     Wankhede Stadium 06-04-2012
## 311                               Sawai Mansingh Stadium 06-04-2012
## 312                                M Chinnaswamy Stadium 07-04-2012
## 313  Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium 07-04-2012
## 314                               Sawai Mansingh Stadium 08-04-2012
## 315                           Subrata Roy Sahara Stadium 08-04-2012
## 316  Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium 09-04-2012
## 317                                M Chinnaswamy Stadium 10-04-2012
## 318                                     Feroz Shah Kotla 10-04-2012
## 319                                     Wankhede Stadium 11-04-2012
## 320                      MA Chidambaram Stadium, Chepauk 12-04-2012
## 321           Punjab Cricket Association Stadium, Mohali 12-04-2012
## 322                                         Eden Gardens 13-04-2012
## 323                                     Feroz Shah Kotla 19-04-2012
## 324                           Subrata Roy Sahara Stadium 14-04-2012
## 325                                         Eden Gardens 15-04-2012
## 326                                M Chinnaswamy Stadium 15-04-2012
## 327                                     Wankhede Stadium 16-04-2012
## 328                               Sawai Mansingh Stadium 17-04-2012
## 329                                M Chinnaswamy Stadium 17-04-2012
## 330           Punjab Cricket Association Stadium, Mohali 18-04-2012
## 331            Rajiv Gandhi International Stadium, Uppal 10-05-2012
## 332                      MA Chidambaram Stadium, Chepauk 19-04-2012
## 333           Punjab Cricket Association Stadium, Mohali 20-04-2012
## 334                      MA Chidambaram Stadium, Chepauk 21-04-2012
## 335                                     Feroz Shah Kotla 21-04-2012
## 336                                     Wankhede Stadium 22-04-2012
## 337                                     Barabati Stadium 22-04-2012
## 338                               Sawai Mansingh Stadium 23-04-2012
## 339                           Subrata Roy Sahara Stadium 24-04-2012
## 340           Punjab Cricket Association Stadium, Mohali 25-04-2012
## 341                           Subrata Roy Sahara Stadium 26-04-2012
## 342                                     Feroz Shah Kotla 27-04-2012
## 343                      MA Chidambaram Stadium, Chepauk 28-04-2012
## 344                                         Eden Gardens 28-04-2012
## 345                                     Feroz Shah Kotla 29-04-2012
## 346                                     Wankhede Stadium 29-04-2012
## 347                      MA Chidambaram Stadium, Chepauk 30-04-2012
## 348                                     Barabati Stadium 01-05-2012
## 349                               Sawai Mansingh Stadium 01-05-2012
## 350                                M Chinnaswamy Stadium 02-05-2012
## 351                           Subrata Roy Sahara Stadium 03-05-2012
## 352                      MA Chidambaram Stadium, Chepauk 04-05-2012
## 353                                         Eden Gardens 05-05-2012
## 354           Punjab Cricket Association Stadium, Mohali 05-05-2012
## 355                                     Wankhede Stadium 06-05-2012
## 356                                M Chinnaswamy Stadium 06-05-2012
## 357                                     Feroz Shah Kotla 07-05-2012
## 358                           Subrata Roy Sahara Stadium 08-05-2012
## 359            Rajiv Gandhi International Stadium, Uppal 08-05-2012
## 360                                     Wankhede Stadium 09-05-2012
## 361                               Sawai Mansingh Stadium 10-05-2012
## 362                           Subrata Roy Sahara Stadium 11-05-2012
## 363                                         Eden Gardens 12-05-2012
## 364                      MA Chidambaram Stadium, Chepauk 12-05-2012
## 365                               Sawai Mansingh Stadium 13-05-2012
## 366           Punjab Cricket Association Stadium, Mohali 13-05-2012
## 367                                M Chinnaswamy Stadium 14-05-2012
## 368                                         Eden Gardens 14-05-2012
## 369                                     Feroz Shah Kotla 15-05-2012
## 370                                     Wankhede Stadium 16-05-2012
## 371         Himachal Pradesh Cricket Association Stadium 17-05-2012
## 372                                     Feroz Shah Kotla 17-05-2012
## 373            Rajiv Gandhi International Stadium, Uppal 18-05-2012
## 374         Himachal Pradesh Cricket Association Stadium 19-05-2012
## 375                           Subrata Roy Sahara Stadium 19-05-2012
## 376            Rajiv Gandhi International Stadium, Uppal 20-05-2012
## 377                               Sawai Mansingh Stadium 20-05-2012
## 378                           Subrata Roy Sahara Stadium 22-05-2012
## 379                                M Chinnaswamy Stadium 23-05-2012
## 380                      MA Chidambaram Stadium, Chepauk 25-05-2012
## 381                      MA Chidambaram Stadium, Chepauk 27-05-2012
## 382                                         Eden Gardens 03-04-2013
## 383                                M Chinnaswamy Stadium 04-04-2013
## 384            Rajiv Gandhi International Stadium, Uppal 05-04-2013
## 385                                     Feroz Shah Kotla 06-04-2013
## 386                      MA Chidambaram Stadium, Chepauk 06-04-2013
## 387                           Subrata Roy Sahara Stadium 07-04-2013
## 388            Rajiv Gandhi International Stadium, Uppal 07-04-2013
## 389                               Sawai Mansingh Stadium 08-04-2013
## 390                                     Wankhede Stadium 09-04-2013
## 391           Punjab Cricket Association Stadium, Mohali 10-04-2013
## 392                                M Chinnaswamy Stadium 11-04-2013
## 393                           Subrata Roy Sahara Stadium 11-04-2013
## 394                                     Feroz Shah Kotla 12-04-2013
## 395                                     Wankhede Stadium 13-04-2013
## 396                      MA Chidambaram Stadium, Chepauk 13-04-2013
## 397                                         Eden Gardens 14-04-2013
## 398                               Sawai Mansingh Stadium 14-04-2013
## 399                      MA Chidambaram Stadium, Chepauk 15-04-2013
## 400           Punjab Cricket Association Stadium, Mohali 16-04-2013
## 401                                M Chinnaswamy Stadium 16-04-2013
## 402                           Subrata Roy Sahara Stadium 17-04-2013
## 403                               Sawai Mansingh Stadium 17-04-2013
## 404                                     Feroz Shah Kotla 18-04-2013
## 405            Rajiv Gandhi International Stadium, Uppal 19-04-2013
## 406                                         Eden Gardens 20-04-2013
## 407                                M Chinnaswamy Stadium 20-04-2013
## 408                                     Feroz Shah Kotla 21-04-2013
## 409           Punjab Cricket Association Stadium, Mohali 21-04-2013
## 410                      MA Chidambaram Stadium, Chepauk 22-04-2013
## 411                                M Chinnaswamy Stadium 23-04-2013
## 412         Himachal Pradesh Cricket Association Stadium 16-05-2013
## 413                                         Eden Gardens 24-04-2013
## 414                      MA Chidambaram Stadium, Chepauk 25-04-2013
## 415                                         Eden Gardens 26-04-2013
## 416                               Sawai Mansingh Stadium 27-04-2013
## 417                                     Wankhede Stadium 27-04-2013
## 418                      MA Chidambaram Stadium, Chepauk 28-04-2013
## 419     Shaheed Veer Narayan Singh International Stadium 28-04-2013
## 420                               Sawai Mansingh Stadium 29-04-2013
## 421                                     Wankhede Stadium 29-04-2013
## 422                           Subrata Roy Sahara Stadium 30-04-2013
## 423            Rajiv Gandhi International Stadium, Uppal 01-05-2013
## 424     Shaheed Veer Narayan Singh International Stadium 01-05-2013
## 425                      MA Chidambaram Stadium, Chepauk 02-05-2013
## 426                           Subrata Roy Sahara Stadium 02-05-2013
## 427                                         Eden Gardens 03-05-2013
## 428            Rajiv Gandhi International Stadium, Uppal 04-05-2013
## 429                                M Chinnaswamy Stadium 14-05-2013
## 430                                     Wankhede Stadium 05-05-2013
## 431                               Sawai Mansingh Stadium 05-05-2013
## 432                                M Chinnaswamy Stadium 09-04-2013
## 433                               Sawai Mansingh Stadium 07-05-2013
## 434                                     Wankhede Stadium 07-05-2013
## 435            Rajiv Gandhi International Stadium, Uppal 08-05-2013
## 436           Punjab Cricket Association Stadium, Mohali 09-05-2013
## 437                           Subrata Roy Sahara Stadium 09-05-2013
## 438                                     Feroz Shah Kotla 10-05-2013
## 439                           Subrata Roy Sahara Stadium 11-05-2013
## 440           Punjab Cricket Association Stadium, Mohali 11-05-2013
## 441                   JSCA International Stadium Complex 12-05-2013
## 442                               Sawai Mansingh Stadium 12-05-2013
## 443                                     Feroz Shah Kotla 23-04-2013
## 444                                     Wankhede Stadium 13-05-2013
## 445                   JSCA International Stadium Complex 15-05-2013
## 446                      MA Chidambaram Stadium, Chepauk 14-05-2013
## 447                                     Wankhede Stadium 15-05-2013
## 448           Punjab Cricket Association Stadium, Mohali 06-05-2013
## 449            Rajiv Gandhi International Stadium, Uppal 17-05-2013
## 450         Himachal Pradesh Cricket Association Stadium 18-05-2013
## 451                           Subrata Roy Sahara Stadium 19-05-2013
## 452                                M Chinnaswamy Stadium 18-05-2013
## 453            Rajiv Gandhi International Stadium, Uppal 19-05-2013
## 454                                     Feroz Shah Kotla 21-05-2013
## 455                                     Feroz Shah Kotla 22-05-2013
## 456                                         Eden Gardens 24-05-2013
## 457                                         Eden Gardens 26-05-2013
## 458                                 Sheikh Zayed Stadium 16-04-2014
## 459                              Sharjah Cricket Stadium 17-04-2014
## 460                                 Sheikh Zayed Stadium 18-04-2014
## 461                                 Sheikh Zayed Stadium 18-04-2014
## 462                  Dubai International Cricket Stadium 19-04-2014
## 463                  Dubai International Cricket Stadium 19-04-2014
## 464                              Sharjah Cricket Stadium 20-04-2014
## 465                                 Sheikh Zayed Stadium 21-04-2014
## 466                              Sharjah Cricket Stadium 22-04-2014
## 467                  Dubai International Cricket Stadium 23-04-2014
## 468                              Sharjah Cricket Stadium 24-04-2014
## 469                  Dubai International Cricket Stadium 25-04-2014
## 470                  Dubai International Cricket Stadium 25-04-2014
## 471                                 Sheikh Zayed Stadium 26-04-2014
## 472                                 Sheikh Zayed Stadium 26-04-2014
## 473                              Sharjah Cricket Stadium 27-04-2014
## 474                              Sharjah Cricket Stadium 27-04-2014
## 475                  Dubai International Cricket Stadium 28-04-2014
## 476                                 Sheikh Zayed Stadium 29-04-2014
## 477                  Dubai International Cricket Stadium 30-04-2014
## 478                   JSCA International Stadium Complex 02-05-2014
## 479                                     Wankhede Stadium 03-05-2014
## 480                                     Feroz Shah Kotla 03-05-2014
## 481                                M Chinnaswamy Stadium 04-05-2014
## 482                         Sardar Patel Stadium, Motera 05-05-2014
## 483                                     Feroz Shah Kotla 05-05-2014
## 484                                     Wankhede Stadium 06-05-2014
## 485                                     Feroz Shah Kotla 07-05-2014
## 486                                     Barabati Stadium 07-05-2014
## 487                         Sardar Patel Stadium, Motera 08-05-2014
## 488                                M Chinnaswamy Stadium 09-05-2014
## 489                                     Feroz Shah Kotla 10-05-2014
## 490                                     Wankhede Stadium 10-05-2014
## 491                                     Barabati Stadium 11-05-2014
## 492                                M Chinnaswamy Stadium 11-05-2014
## 493            Rajiv Gandhi International Stadium, Uppal 12-05-2014
## 494                   JSCA International Stadium Complex 13-05-2014
## 495                                M Chinnaswamy Stadium 13-05-2014
## 496            Rajiv Gandhi International Stadium, Uppal 14-05-2014
## 497                                     Barabati Stadium 14-05-2014
## 498                         Sardar Patel Stadium, Motera 15-05-2014
## 499                   JSCA International Stadium Complex 18-05-2014
## 500            Rajiv Gandhi International Stadium, Uppal 18-05-2014
## 501                         Sardar Patel Stadium, Motera 19-05-2014
## 502                                     Feroz Shah Kotla 19-05-2014
## 503            Rajiv Gandhi International Stadium, Uppal 20-05-2014
## 504                                         Eden Gardens 20-05-2014
## 505           Punjab Cricket Association Stadium, Mohali 21-05-2014
## 506                                         Eden Gardens 22-05-2014
## 507                   JSCA International Stadium Complex 22-05-2014
## 508                                     Wankhede Stadium 23-05-2014
## 509           Punjab Cricket Association Stadium, Mohali 23-05-2014
## 510                                M Chinnaswamy Stadium 24-05-2014
## 511                                         Eden Gardens 24-05-2014
## 512           Punjab Cricket Association Stadium, Mohali 25-05-2014
## 513                                     Wankhede Stadium 25-05-2014
## 514                                         Eden Gardens 27-05-2014
## 515                                    Brabourne Stadium 28-05-2014
## 516                                     Wankhede Stadium 30-05-2014
## 517                                M Chinnaswamy Stadium 01-06-2014
## 518                                         Eden Gardens 08-04-2015
## 519                      MA Chidambaram Stadium, Chepauk 09-04-2015
## 520              Maharashtra Cricket Association Stadium 10-04-2015
## 521                      MA Chidambaram Stadium, Chepauk 11-04-2015
## 522                                         Eden Gardens 11-04-2015
## 523                                     Feroz Shah Kotla 12-04-2015
## 524                                     Wankhede Stadium 12-04-2015
## 525                                M Chinnaswamy Stadium 13-04-2015
## 526                         Sardar Patel Stadium, Motera 14-04-2015
## 527                                         Eden Gardens 30-04-2015
## 528              Maharashtra Cricket Association Stadium 15-04-2015
## 529  Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium 16-04-2015
## 530                                     Wankhede Stadium 17-04-2015
## 531  Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium 18-04-2015
## 532              Maharashtra Cricket Association Stadium 18-04-2015
## 533                         Sardar Patel Stadium, Motera 19-04-2015
## 534                                M Chinnaswamy Stadium 19-04-2015
## 535                                     Feroz Shah Kotla 20-04-2015
## 536                         Sardar Patel Stadium, Motera 21-04-2015
## 537  Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium 22-04-2015
## 538                                M Chinnaswamy Stadium 22-04-2015
## 539                                     Feroz Shah Kotla 23-04-2015
## 540                         Sardar Patel Stadium, Motera 24-04-2015
## 541                                     Wankhede Stadium 25-04-2015
## 542                      MA Chidambaram Stadium, Chepauk 25-04-2015
## 543                                     Feroz Shah Kotla 26-04-2015
## 544           Punjab Cricket Association Stadium, Mohali 27-04-2015
## 545                                         Eden Gardens 07-05-2015
## 546                                M Chinnaswamy Stadium 29-04-2015
## 547                      MA Chidambaram Stadium, Chepauk 28-04-2015
## 548                                     Feroz Shah Kotla 01-05-2015
## 549                                     Wankhede Stadium 01-05-2015
## 550                                M Chinnaswamy Stadium 02-05-2015
## 551            Rajiv Gandhi International Stadium, Uppal 02-05-2015
## 552           Punjab Cricket Association Stadium, Mohali 03-05-2015
## 553                                    Brabourne Stadium 03-05-2015
## 554                      MA Chidambaram Stadium, Chepauk 04-05-2015
## 555                                         Eden Gardens 04-05-2015
## 556                                     Wankhede Stadium 05-05-2015
## 557                                M Chinnaswamy Stadium 06-05-2015
## 558                                    Brabourne Stadium 07-05-2015
## 559                      MA Chidambaram Stadium, Chepauk 08-05-2015
## 560                                         Eden Gardens 09-05-2015
## 561     Shaheed Veer Narayan Singh International Stadium 09-05-2015
## 562                                     Wankhede Stadium 10-05-2015
## 563                      MA Chidambaram Stadium, Chepauk 10-05-2015
## 564            Rajiv Gandhi International Stadium, Uppal 11-05-2015
## 565     Shaheed Veer Narayan Singh International Stadium 12-05-2015
## 566           Punjab Cricket Association Stadium, Mohali 13-05-2015
## 567                                     Wankhede Stadium 14-05-2015
## 568            Rajiv Gandhi International Stadium, Uppal 15-05-2015
## 569           Punjab Cricket Association Stadium, Mohali 16-05-2015
## 570                                    Brabourne Stadium 16-05-2015
## 571                                M Chinnaswamy Stadium 17-05-2015
## 572            Rajiv Gandhi International Stadium, Uppal 17-05-2015
## 573                                     Wankhede Stadium 19-05-2015
## 574              Maharashtra Cricket Association Stadium 20-05-2015
## 575                   JSCA International Stadium Complex 22-05-2015
## 576                                         Eden Gardens 24-05-2015
## 577                                     Wankhede Stadium 09-04-2016
## 578                                         Eden Gardens 10-04-2016
## 579 Punjab Cricket Association IS Bindra Stadium, Mohali 11-04-2016
## 580                                M Chinnaswamy Stadium 12-04-2016
## 581                                         Eden Gardens 13-04-2016
## 582               Saurashtra Cricket Association Stadium 14-04-2016
## 583                                     Feroz Shah Kotla 15-04-2016
## 584            Rajiv Gandhi International Stadium, Uppal 16-04-2016
## 585                                     Wankhede Stadium 16-04-2016
## 586 Punjab Cricket Association IS Bindra Stadium, Mohali 17-04-2016
## 587                                M Chinnaswamy Stadium 17-04-2016
## 588            Rajiv Gandhi International Stadium, Uppal 18-04-2016
## 589 Punjab Cricket Association IS Bindra Stadium, Mohali 19-04-2016
## 590                                     Wankhede Stadium 20-04-2016
## 591               Saurashtra Cricket Association Stadium 21-04-2016
## 592              Maharashtra Cricket Association Stadium 22-04-2016
## 593                                     Feroz Shah Kotla 23-04-2016
## 594            Rajiv Gandhi International Stadium, Uppal 23-04-2016
## 595               Saurashtra Cricket Association Stadium 24-04-2016
## 596              Maharashtra Cricket Association Stadium 24-04-2016
## 597 Punjab Cricket Association IS Bindra Stadium, Mohali 25-04-2016
## 598            Rajiv Gandhi International Stadium, Uppal 26-04-2016
## 599                                     Feroz Shah Kotla 27-04-2016
## 600                                     Wankhede Stadium 28-04-2016
## 601              Maharashtra Cricket Association Stadium 29-04-2016
## 602                                     Feroz Shah Kotla 30-04-2016
## 603            Rajiv Gandhi International Stadium, Uppal 30-04-2016
## 604               Saurashtra Cricket Association Stadium 01-05-2016
## 605              Maharashtra Cricket Association Stadium 01-05-2016
## 606                                M Chinnaswamy Stadium 02-05-2016
## 607               Saurashtra Cricket Association Stadium 03-05-2016
## 608                                         Eden Gardens 04-05-2016
## 609                                     Feroz Shah Kotla 05-05-2016
## 610            Rajiv Gandhi International Stadium, Uppal 06-05-2016
## 611                                M Chinnaswamy Stadium 07-05-2016
## 612 Punjab Cricket Association IS Bindra Stadium, Mohali 07-05-2016
## 613  Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium 08-05-2016
## 614                                         Eden Gardens 08-05-2016
## 615 Punjab Cricket Association IS Bindra Stadium, Mohali 09-05-2016
## 616  Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium 10-05-2016
## 617                                M Chinnaswamy Stadium 11-05-2016
## 618            Rajiv Gandhi International Stadium, Uppal 12-05-2016
## 619  Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium 13-05-2016
## 620                                M Chinnaswamy Stadium 14-05-2016
## 621                                         Eden Gardens 14-05-2016
## 622 Punjab Cricket Association IS Bindra Stadium, Mohali 15-05-2016
## 623  Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium 15-05-2016
## 624                                         Eden Gardens 16-05-2016
## 625  Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium 17-05-2016
## 626                                M Chinnaswamy Stadium 18-05-2016
## 627                                           Green Park 19-05-2016
## 628     Shaheed Veer Narayan Singh International Stadium 20-05-2016
## 629  Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium 21-05-2016
## 630                                           Green Park 21-05-2016
## 631                                         Eden Gardens 22-05-2016
## 632     Shaheed Veer Narayan Singh International Stadium 22-05-2016
## 633                                M Chinnaswamy Stadium 24-05-2016
## 634                                     Feroz Shah Kotla 25-05-2016
## 635                                     Feroz Shah Kotla 27-05-2016
## 636                                M Chinnaswamy Stadium 29-05-2016
##               city season
## 1        Hyderabad   2017
## 2             Pune   2017
## 3           Rajkot   2017
## 4           Indore   2017
## 5        Bangalore   2017
## 6        Hyderabad   2017
## 7           Mumbai   2017
## 8           Indore   2017
## 9             Pune   2017
## 10          Mumbai   2017
## 11         Kolkata   2017
## 12       Bangalore   2017
## 13          Rajkot   2017
## 14         Kolkata   2017
## 15           Delhi   2017
## 16          Mumbai   2017
## 17       Bangalore   2017
## 18           Delhi   2017
## 19       Hyderabad   2017
## 20          Rajkot   2017
## 21       Hyderabad   2017
## 22          Indore   2017
## 23         Kolkata   2017
## 24          Mumbai   2017
## 25            Pune   2017
## 26          Rajkot   2017
## 27         Kolkata   2017
## 28          Mumbai   2017
## 29            Pune   2017
## 30       Bangalore   2017
## 31         Kolkata   2017
## 32      Chandigarh   2017
## 33            Pune   2017
## 34          Rajkot   2017
## 35      Chandigarh   2017
## 36       Hyderabad   2017
## 37          Mumbai   2017
## 38            Pune   2017
## 39           Delhi   2017
## 40         Kolkata   2017
## 41           Delhi   2017
## 42       Bangalore   2017
## 43       Hyderabad   2017
## 44           Delhi   2017
## 45       Bangalore   2017
## 46      Chandigarh   2017
## 47       Hyderabad   2017
## 48      Chandigarh   2017
## 49          Kanpur   2017
## 50          Mumbai   2017
## 51           Delhi   2017
## 52          Kanpur   2017
## 53         Kolkata   2017
## 54            Pune   2017
## 55           Delhi   2017
## 56          Mumbai   2017
## 57       Bangalore   2017
## 58       Bangalore   2017
## 59       Hyderabad   2017
## 60       Bangalore   2008
## 61      Chandigarh   2008
## 62           Delhi   2008
## 63          Mumbai   2008
## 64         Kolkata   2008
## 65          Jaipur   2008
## 66       Hyderabad   2008
## 67         Chennai   2008
## 68       Hyderabad   2008
## 69      Chandigarh   2008
## 70       Bangalore   2008
## 71         Chennai   2008
## 72          Mumbai   2008
## 73      Chandigarh   2008
## 74       Bangalore   2008
## 75         Kolkata   2008
## 76           Delhi   2008
## 77       Hyderabad   2008
## 78          Jaipur   2008
## 79         Chennai   2008
## 80       Hyderabad   2008
## 81      Chandigarh   2008
## 82          Mumbai   2008
## 83          Jaipur   2008
## 84       Bangalore   2008
## 85         Chennai   2008
## 86          Mumbai   2008
## 87           Delhi   2008
## 88         Kolkata   2008
## 89          Jaipur   2008
## 90       Bangalore   2008
## 91         Chennai   2008
## 92       Hyderabad   2008
## 93          Jaipur   2008
## 94      Chandigarh   2008
## 95         Kolkata   2008
## 96          Mumbai   2008
## 97      Chandigarh   2008
## 98           Delhi   2008
## 99          Mumbai   2008
## 100          Delhi   2008
## 101         Jaipur   2008
## 102      Hyderabad   2008
## 103        Kolkata   2008
## 104      Bangalore   2008
## 105        Kolkata   2008
## 106         Mumbai   2008
## 107        Chennai   2008
## 108     Chandigarh   2008
## 109          Delhi   2008
## 110        Chennai   2008
## 111      Bangalore   2008
## 112        Kolkata   2008
## 113         Jaipur   2008
## 114      Hyderabad   2008
## 115         Mumbai   2008
## 116         Mumbai   2008
## 117         Mumbai   2008
## 118      Cape Town   2009
## 119      Cape Town   2009
## 120      Cape Town   2009
## 121      Cape Town   2009
## 122 Port Elizabeth   2009
## 123         Durban   2009
## 124      Cape Town   2009
## 125         Durban   2009
## 126      Cape Town   2009
## 127         Durban   2009
## 128         Durban   2009
## 129 Port Elizabeth   2009
## 130      Cape Town   2009
## 131         Durban   2009
## 132 Port Elizabeth   2009
## 133      Centurion   2009
## 134         Durban   2009
## 135         Durban   2009
## 136      Centurion   2009
## 137      Centurion   2009
## 138    East London   2009
## 139         Durban   2009
## 140 Port Elizabeth   2009
## 141   Johannesburg   2009
## 142 Port Elizabeth   2009
## 143   Johannesburg   2009
## 144    East London   2009
## 145         Durban   2009
## 146         Durban   2009
## 147      Centurion   2009
## 148      Centurion   2009
## 149      Centurion   2009
## 150    East London   2009
## 151      Kimberley   2009
## 152      Kimberley   2009
## 153 Port Elizabeth   2009
## 154   Johannesburg   2009
## 155      Kimberley   2009
## 156      Centurion   2009
## 157      Centurion   2009
## 158         Durban   2009
## 159         Durban   2009
## 160         Durban   2009
## 161   Bloemfontein   2009
## 162 Port Elizabeth   2009
## 163   Johannesburg   2009
## 164   Johannesburg   2009
## 165   Bloemfontein   2009
## 166      Centurion   2009
## 167   Johannesburg   2009
## 168         Durban   2009
## 169         Durban   2009
## 170      Centurion   2009
## 171      Centurion   2009
## 172      Centurion   2009
## 173   Johannesburg   2009
## 174   Johannesburg   2009
## 175         Mumbai   2010
## 176         Mumbai   2010
## 177     Chandigarh   2010
## 178        Kolkata   2010
## 179        Chennai   2010
## 180      Ahmedabad   2010
## 181      Bangalore   2010
## 182        Kolkata   2010
## 183          Delhi   2010
## 184      Bangalore   2010
## 185          Delhi   2010
## 186        Cuttack   2010
## 187      Ahmedabad   2010
## 188         Mumbai   2010
## 189        Cuttack   2010
## 190        Chennai   2010
## 191         Mumbai   2010
## 192      Bangalore   2010
## 193     Chandigarh   2010
## 194         Mumbai   2010
## 195      Ahmedabad   2010
## 196     Chandigarh   2010
## 197      Bangalore   2010
## 198      Ahmedabad   2010
## 199         Mumbai   2010
## 200          Delhi   2010
## 201         Mumbai   2010
## 202        Chennai   2010
## 203          Delhi   2010
## 204        Kolkata   2010
## 205     Chandigarh   2010
## 206        Chennai   2010
## 207         Mumbai   2010
## 208        Kolkata   2010
## 209          Delhi   2010
## 210         Nagpur   2010
## 211        Chennai   2010
## 212         Jaipur   2010
## 213        Kolkata   2010
## 214      Bangalore   2010
## 215     Chandigarh   2010
## 216         Nagpur   2010
## 217      Bangalore   2010
## 218          Delhi   2010
## 219         Jaipur   2010
## 220         Nagpur   2010
## 221         Mumbai   2010
## 222        Chennai   2010
## 223         Jaipur   2010
## 224        Chennai   2010
## 225     Dharamsala   2010
## 226      Bangalore   2010
## 227        Kolkata   2010
## 228     Dharamsala   2010
## 229          Delhi   2010
## 230        Kolkata   2010
## 231         Mumbai   2010
## 232         Mumbai   2010
## 233         Mumbai   2010
## 234         Mumbai   2010
## 235        Chennai   2011
## 236      Hyderabad   2011
## 237          Kochi   2011
## 238          Delhi   2011
## 239         Mumbai   2011
## 240        Kolkata   2011
## 241         Jaipur   2011
## 242      Bangalore   2011
## 243     Chandigarh   2011
## 244         Mumbai   2011
## 245      Hyderabad   2011
## 246         Jaipur   2011
## 247         Mumbai   2011
## 248        Chennai   2011
## 249      Hyderabad   2011
## 250         Mumbai   2011
## 251        Kolkata   2011
## 252          Kochi   2011
## 253          Delhi   2011
## 254         Mumbai   2011
## 255        Kolkata   2011
## 256     Chandigarh   2011
## 257         Mumbai   2011
## 258        Kolkata   2011
## 259          Delhi   2011
## 260      Hyderabad   2011
## 261         Jaipur   2011
## 262        Chennai   2011
## 263          Delhi   2011
## 264         Mumbai   2011
## 265          Kochi   2011
## 266          Delhi   2011
## 267         Jaipur   2011
## 268      Bangalore   2011
## 269          Kochi   2011
## 270        Kolkata   2011
## 271         Jaipur   2011
## 272        Chennai   2011
## 273         Mumbai   2011
## 274          Delhi   2011
## 275      Hyderabad   2011
## 276        Chennai   2011
## 277         Mumbai   2011
## 278          Kochi   2011
## 279      Hyderabad   2011
## 280      Bangalore   2011
## 281        Kolkata   2011
## 282         Mumbai   2011
## 283      Bangalore   2011
## 284     Chandigarh   2011
## 285         Jaipur   2011
## 286      Hyderabad   2011
## 287     Chandigarh   2011
## 288         Jaipur   2011
## 289        Chennai   2011
## 290         Indore   2011
## 291      Bangalore   2011
## 292         Mumbai   2011
## 293     Dharamsala   2011
## 294         Indore   2011
## 295         Mumbai   2011
## 296     Dharamsala   2011
## 297        Chennai   2011
## 298         Mumbai   2011
## 299         Mumbai   2011
## 300     Dharamsala   2011
## 301          Delhi   2011
## 302      Bangalore   2011
## 303        Kolkata   2011
## 304         Mumbai   2011
## 305         Mumbai   2011
## 306        Chennai   2011
## 307        Chennai   2011
## 308        Chennai   2012
## 309        Kolkata   2012
## 310         Mumbai   2012
## 311         Jaipur   2012
## 312      Bangalore   2012
## 313  Visakhapatnam   2012
## 314         Jaipur   2012
## 315           Pune   2012
## 316  Visakhapatnam   2012
## 317      Bangalore   2012
## 318          Delhi   2012
## 319         Mumbai   2012
## 320        Chennai   2012
## 321     Chandigarh   2012
## 322        Kolkata   2012
## 323          Delhi   2012
## 324           Pune   2012
## 325        Kolkata   2012
## 326      Bangalore   2012
## 327         Mumbai   2012
## 328         Jaipur   2012
## 329      Bangalore   2012
## 330     Chandigarh   2012
## 331      Hyderabad   2012
## 332        Chennai   2012
## 333     Chandigarh   2012
## 334        Chennai   2012
## 335          Delhi   2012
## 336         Mumbai   2012
## 337        Cuttack   2012
## 338         Jaipur   2012
## 339           Pune   2012
## 340     Chandigarh   2012
## 341           Pune   2012
## 342          Delhi   2012
## 343        Chennai   2012
## 344        Kolkata   2012
## 345          Delhi   2012
## 346         Mumbai   2012
## 347        Chennai   2012
## 348        Cuttack   2012
## 349         Jaipur   2012
## 350      Bangalore   2012
## 351           Pune   2012
## 352        Chennai   2012
## 353        Kolkata   2012
## 354     Chandigarh   2012
## 355         Mumbai   2012
## 356      Bangalore   2012
## 357          Delhi   2012
## 358           Pune   2012
## 359      Hyderabad   2012
## 360         Mumbai   2012
## 361         Jaipur   2012
## 362           Pune   2012
## 363        Kolkata   2012
## 364        Chennai   2012
## 365         Jaipur   2012
## 366     Chandigarh   2012
## 367      Bangalore   2012
## 368        Kolkata   2012
## 369          Delhi   2012
## 370         Mumbai   2012
## 371     Dharamsala   2012
## 372          Delhi   2012
## 373      Hyderabad   2012
## 374     Dharamsala   2012
## 375           Pune   2012
## 376      Hyderabad   2012
## 377         Jaipur   2012
## 378           Pune   2012
## 379      Bangalore   2012
## 380        Chennai   2012
## 381        Chennai   2012
## 382        Kolkata   2013
## 383      Bangalore   2013
## 384      Hyderabad   2013
## 385          Delhi   2013
## 386        Chennai   2013
## 387           Pune   2013
## 388      Hyderabad   2013
## 389         Jaipur   2013
## 390         Mumbai   2013
## 391     Chandigarh   2013
## 392      Bangalore   2013
## 393           Pune   2013
## 394          Delhi   2013
## 395         Mumbai   2013
## 396        Chennai   2013
## 397        Kolkata   2013
## 398         Jaipur   2013
## 399        Chennai   2013
## 400     Chandigarh   2013
## 401      Bangalore   2013
## 402           Pune   2013
## 403         Jaipur   2013
## 404          Delhi   2013
## 405      Hyderabad   2013
## 406        Kolkata   2013
## 407      Bangalore   2013
## 408          Delhi   2013
## 409     Chandigarh   2013
## 410        Chennai   2013
## 411      Bangalore   2013
## 412     Dharamsala   2013
## 413        Kolkata   2013
## 414        Chennai   2013
## 415        Kolkata   2013
## 416         Jaipur   2013
## 417         Mumbai   2013
## 418        Chennai   2013
## 419         Raipur   2013
## 420         Jaipur   2013
## 421         Mumbai   2013
## 422           Pune   2013
## 423      Hyderabad   2013
## 424         Raipur   2013
## 425        Chennai   2013
## 426           Pune   2013
## 427        Kolkata   2013
## 428      Hyderabad   2013
## 429      Bangalore   2013
## 430         Mumbai   2013
## 431         Jaipur   2013
## 432      Bangalore   2013
## 433         Jaipur   2013
## 434         Mumbai   2013
## 435      Hyderabad   2013
## 436     Chandigarh   2013
## 437           Pune   2013
## 438          Delhi   2013
## 439           Pune   2013
## 440     Chandigarh   2013
## 441         Ranchi   2013
## 442         Jaipur   2013
## 443          Delhi   2013
## 444         Mumbai   2013
## 445         Ranchi   2013
## 446        Chennai   2013
## 447         Mumbai   2013
## 448     Chandigarh   2013
## 449      Hyderabad   2013
## 450     Dharamsala   2013
## 451           Pune   2013
## 452      Bangalore   2013
## 453      Hyderabad   2013
## 454          Delhi   2013
## 455          Delhi   2013
## 456        Kolkata   2013
## 457        Kolkata   2013
## 458      Abu Dhabi   2014
## 459        Sharjah   2014
## 460      Abu Dhabi   2014
## 461      Abu Dhabi   2014
## 462                  2014
## 463                  2014
## 464        Sharjah   2014
## 465      Abu Dhabi   2014
## 466        Sharjah   2014
## 467                  2014
## 468        Sharjah   2014
## 469                  2014
## 470                  2014
## 471      Abu Dhabi   2014
## 472      Abu Dhabi   2014
## 473        Sharjah   2014
## 474        Sharjah   2014
## 475                  2014
## 476      Abu Dhabi   2014
## 477                  2014
## 478         Ranchi   2014
## 479         Mumbai   2014
## 480          Delhi   2014
## 481      Bangalore   2014
## 482      Ahmedabad   2014
## 483          Delhi   2014
## 484         Mumbai   2014
## 485          Delhi   2014
## 486        Cuttack   2014
## 487      Ahmedabad   2014
## 488      Bangalore   2014
## 489          Delhi   2014
## 490         Mumbai   2014
## 491        Cuttack   2014
## 492      Bangalore   2014
## 493      Hyderabad   2014
## 494         Ranchi   2014
## 495      Bangalore   2014
## 496      Hyderabad   2014
## 497        Cuttack   2014
## 498      Ahmedabad   2014
## 499         Ranchi   2014
## 500      Hyderabad   2014
## 501      Ahmedabad   2014
## 502          Delhi   2014
## 503      Hyderabad   2014
## 504        Kolkata   2014
## 505     Chandigarh   2014
## 506        Kolkata   2014
## 507         Ranchi   2014
## 508         Mumbai   2014
## 509     Chandigarh   2014
## 510      Bangalore   2014
## 511        Kolkata   2014
## 512     Chandigarh   2014
## 513         Mumbai   2014
## 514        Kolkata   2014
## 515         Mumbai   2014
## 516         Mumbai   2014
## 517      Bangalore   2014
## 518        Kolkata   2015
## 519        Chennai   2015
## 520           Pune   2015
## 521        Chennai   2015
## 522        Kolkata   2015
## 523          Delhi   2015
## 524         Mumbai   2015
## 525      Bangalore   2015
## 526      Ahmedabad   2015
## 527        Kolkata   2015
## 528           Pune   2015
## 529  Visakhapatnam   2015
## 530         Mumbai   2015
## 531  Visakhapatnam   2015
## 532           Pune   2015
## 533      Ahmedabad   2015
## 534      Bangalore   2015
## 535          Delhi   2015
## 536      Ahmedabad   2015
## 537  Visakhapatnam   2015
## 538      Bangalore   2015
## 539          Delhi   2015
## 540      Ahmedabad   2015
## 541         Mumbai   2015
## 542        Chennai   2015
## 543          Delhi   2015
## 544     Chandigarh   2015
## 545        Kolkata   2015
## 546      Bangalore   2015
## 547        Chennai   2015
## 548          Delhi   2015
## 549         Mumbai   2015
## 550      Bangalore   2015
## 551      Hyderabad   2015
## 552     Chandigarh   2015
## 553         Mumbai   2015
## 554        Chennai   2015
## 555        Kolkata   2015
## 556         Mumbai   2015
## 557      Bangalore   2015
## 558         Mumbai   2015
## 559        Chennai   2015
## 560        Kolkata   2015
## 561         Raipur   2015
## 562         Mumbai   2015
## 563        Chennai   2015
## 564      Hyderabad   2015
## 565         Raipur   2015
## 566     Chandigarh   2015
## 567         Mumbai   2015
## 568      Hyderabad   2015
## 569     Chandigarh   2015
## 570         Mumbai   2015
## 571      Bangalore   2015
## 572      Hyderabad   2015
## 573         Mumbai   2015
## 574           Pune   2015
## 575         Ranchi   2015
## 576        Kolkata   2015
## 577         Mumbai   2016
## 578        Kolkata   2016
## 579     Chandigarh   2016
## 580      Bangalore   2016
## 581        Kolkata   2016
## 582         Rajkot   2016
## 583          Delhi   2016
## 584      Hyderabad   2016
## 585         Mumbai   2016
## 586     Chandigarh   2016
## 587      Bangalore   2016
## 588      Hyderabad   2016
## 589     Chandigarh   2016
## 590         Mumbai   2016
## 591         Rajkot   2016
## 592           Pune   2016
## 593          Delhi   2016
## 594      Hyderabad   2016
## 595         Rajkot   2016
## 596           Pune   2016
## 597     Chandigarh   2016
## 598      Hyderabad   2016
## 599          Delhi   2016
## 600         Mumbai   2016
## 601           Pune   2016
## 602          Delhi   2016
## 603      Hyderabad   2016
## 604         Rajkot   2016
## 605           Pune   2016
## 606      Bangalore   2016
## 607         Rajkot   2016
## 608        Kolkata   2016
## 609          Delhi   2016
## 610      Hyderabad   2016
## 611      Bangalore   2016
## 612     Chandigarh   2016
## 613  Visakhapatnam   2016
## 614        Kolkata   2016
## 615     Chandigarh   2016
## 616  Visakhapatnam   2016
## 617      Bangalore   2016
## 618      Hyderabad   2016
## 619  Visakhapatnam   2016
## 620      Bangalore   2016
## 621        Kolkata   2016
## 622     Chandigarh   2016
## 623  Visakhapatnam   2016
## 624        Kolkata   2016
## 625  Visakhapatnam   2016
## 626      Bangalore   2016
## 627         Kanpur   2016
## 628         Raipur   2016
## 629  Visakhapatnam   2016
## 630         Kanpur   2016
## 631        Kolkata   2016
## 632         Raipur   2016
## 633      Bangalore   2016
## 634          Delhi   2016
## 635          Delhi   2016
## 636      Bangalore   2016
print(bowling_stats)
## # A tibble: 82 x 5
##    bowler         runs_conceded wickets_taken balls_bowled economy
##    <chr>                  <int>         <int>        <int>   <dbl>
##  1 A Ashish Reddy             1             0            1       6
##  2 A Nehra                    6             0            2      18
##  3 AB Agarkar                 1             0            1       6
##  4 AB Dinda                   2             0            2       6
##  5 AB McDonald                1             0            1       6
##  6 AD Mathews                 2             0            2       6
##  7 AF Milne                   0             0            1       0
##  8 Ankit Soni                 1             0            1       6
##  9 BB Sran                    0             0            1       0
## 10 BMAJ Mendis                0             0            1       0
## # … with 72 more rows
#Q8: Which teams had won the “super-over” battle while batting first?
#For these matches find the season and Player of the Match. 
super_over_wins <- matches %>% filter(dl_applied == 1 & win_by_runs > 0)
super_over_wins_details <- super_over_wins %>% select(winner, season, player_of_match)
super_over_wins_details
#Q9:Considering all seasons, find the highest score in IPL.
#Show the score distribution using a suitable graph
highest_score <- deliveries %>% 
  group_by(match_id, batting_team) %>% 
  summarise(total_score = sum(total_runs)) %>% 
  arrange(desc(total_score)) %>% 
  slice(1)
## `summarise()` regrouping output by 'match_id' (override with `.groups` argument)
# Distribution of scores
score_distribution <- deliveries %>% 
  group_by(match_id, batting_team) %>% 
  summarise(total_score = sum(total_runs))
## `summarise()` regrouping output by 'match_id' (override with `.groups` argument)
ggplot(score_distribution, aes(x = total_score)) +
  geom_histogram(binwidth = 12, fill = "green", color = "black") +
  labs(title = "Distribution of Team Scores in IPL",
       x = "Total Score",
       y = "Number of Matches")

print(highest_score)
## # A tibble: 636 x 3
## # Groups:   match_id [636]
##    match_id batting_team                total_score
##       <int> <chr>                             <int>
##  1        1 Sunrisers Hyderabad                 207
##  2        2 Rising Pune Supergiant              187
##  3        3 Kolkata Knight Riders               184
##  4        4 Kings XI Punjab                     164
##  5        5 Royal Challengers Bangalore         157
##  6        6 Sunrisers Hyderabad                 140
##  7        7 Mumbai Indians                      180
##  8        8 Kings XI Punjab                     150
##  9        9 Delhi Daredevils                    205
## 10       10 Mumbai Indians                      159
## # … with 626 more rows
#Q10: The Most successful IPL team
team_wins <- matches %>% 
  group_by(winner) %>% 
  summarise(wins = n()) %>% 
  arrange(desc(wins))
## `summarise()` ungrouping output (override with `.groups` argument)
# Plotting the most successful teams
ggplot(team_wins, aes(x = reorder(winner, -wins), y = wins, fill = winner)) +
  geom_bar(stat = "identity") +
  coord_flip() +
  labs(title = "Most Successful IPL Teams by Number of Wins",
       x = "Team",
       y = "Number of Wins")

print(team_wins)
## # A tibble: 15 x 2
##    winner                         wins
##    <chr>                         <int>
##  1 "Mumbai Indians"                 92
##  2 "Chennai Super Kings"            79
##  3 "Kolkata Knight Riders"          77
##  4 "Royal Challengers Bangalore"    73
##  5 "Kings XI Punjab"                70
##  6 "Rajasthan Royals"               63
##  7 "Delhi Daredevils"               62
##  8 "Sunrisers Hyderabad"            42
##  9 "Deccan Chargers"                29
## 10 "Gujarat Lions"                  13
## 11 "Pune Warriors"                  12
## 12 "Rising Pune Supergiant"         10
## 13 "Kochi Tuskers Kerala"            6
## 14 "Rising Pune Supergiants"         5
## 15 ""                                3

This is an R Markdown Notebook. When you execute code within the notebook, the results appear beneath the code.

Try executing this chunk by clicking the Run button within the chunk or by placing your cursor inside it and pressing Ctrl+Shift+Enter.

plot(cars)

Add a new chunk by clicking the Insert Chunk button on the toolbar or by pressing Ctrl+Alt+I.

When you save the notebook, an HTML file containing the code and output will be saved alongside it (click the Preview button or press Ctrl+Shift+K to preview the HTML file).

The preview shows you a rendered HTML copy of the contents of the editor. Consequently, unlike Knit, Preview does not run any R code chunks. Instead, the output of the chunk when it was last run in the editor is displayed.