Name: IPL2020 Players Dataset
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

IPL2020 Players Dataset

Context

I am huge fan of cricket so I created either collected data to explore..

Content

Datasets have all the information and columns to do analysis.

Acknowledgements

We wouldn't be here without the help of others. If you owe any attributions or thanks, include them here along with any citations of past research.

Inspiration

Wanna create perfect11 of each team considering conditions and dataset values.

Tables

Allrounders

@kaggle.daredevil2404_ipl2020_players_dataset.allrounders

20.56 kB
48 rows
24 columns

CREATE TABLE allrounders (
  "team" VARCHAR,
  "name_of_player" VARCHAR,
  "country" VARCHAR,
  "style" VARCHAR,
  "role" VARCHAR,
  "matches" BIGINT,
  "inn_bat" BIGINT,
  "inn_bowld" BIGINT,
  "runs_scored" BIGINT,
  "highest_score" BIGINT,
  "bat_avg" DOUBLE,
  "bat_sr" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s,
  "balls_bowld" BIGINT,
  "runs_given" BIGINT,
  "wickets" BIGINT,
  "bbm" VARCHAR,
  "eco" DOUBLE,
  "bowl_avg" DOUBLE,
  "ball_sr" DOUBLE,
  "n_5w" BIGINT  -- 5w
);

Batsmen

@kaggle.daredevil2404_ipl2020_players_dataset.batsmen

14.43 kB
75 rows
15 columns

CREATE TABLE batsmen (
  "team" VARCHAR,
  "name_of_player" VARCHAR,
  "country" VARCHAR,
  "style" VARCHAR,
  "role" VARCHAR,
  "matches" BIGINT,
  "innings_bat" BIGINT,
  "runs_scored" BIGINT,
  "bat_avg" DOUBLE,
  "bat_sr" DOUBLE,
  "highest_score" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s
);

Bowlers

@kaggle.daredevil2404_ipl2020_players_dataset.bowlers

14.48 kB
64 rows
15 columns

CREATE TABLE bowlers (
  "team" VARCHAR,
  "name_of_player" VARCHAR,
  "country" VARCHAR,
  "style" VARCHAR,
  "bowling_variation" VARCHAR,
  "matches" BIGINT,
  "inning_bowled" BIGINT,
  "balls_bowld" BIGINT,
  "runs_conceded" BIGINT,
  "wickets" BIGINT,
  "bbm" VARCHAR,
  "eco" DOUBLE,
  "bowl_avg" DOUBLE,
  "ball_sr" DOUBLE,
  "n_5w" BIGINT  -- 5w
);