ICC Men's WC T20 Batting Stats (2022)
Men's T20 World Cup Batting Stats(2022)
@kaggle.adnananam_icc_mens_wc_t20_batting_stats_2022
Men's T20 World Cup Batting Stats(2022)
@kaggle.adnananam_icc_mens_wc_t20_batting_stats_2022
Overall Batting Stats of ICC Men's T20 World Cup 2022.
Instead of NaN, the missing values contains a dash "-".
Be careful while handling them.
Data Source : International Cricket Council (ICC)
CREATE TABLE best_batting_average (
"pos" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"avg" DOUBLE,
"innings" BIGINT,
"bat_avg" DOUBLE,
"runs" BIGINT
);CREATE TABLE best_batting_strike_rate (
"pos" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"sr" DOUBLE,
"innings" BIGINT,
"bat_avg" DOUBLE,
"runs" BIGINT
);CREATE TABLE best_batting_strike_rate_innings (
"pos" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"sr" DOUBLE,
"innings" VARCHAR,
"bat_avg" VARCHAR,
"runs" BIGINT
);CREATE TABLE highest_score_innings (
"pos" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"highest_score" VARCHAR,
"innings" VARCHAR,
"bat_avg" VARCHAR,
"runs" BIGINT
);CREATE TABLE most_fifties (
"pos" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"fifties" BIGINT,
"innings" BIGINT,
"bat_avg" DOUBLE,
"runs" BIGINT
);CREATE TABLE most_fours (
"pos" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"fours" BIGINT,
"innings" BIGINT,
"bat_avg" DOUBLE,
"runs" BIGINT
);CREATE TABLE most_hundreds (
"pos" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"hundreds" BIGINT,
"innings" BIGINT,
"bat_avg" DOUBLE,
"runs" BIGINT
);CREATE TABLE most_runs_wc_t20_2022 (
"position" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"runs" BIGINT,
"innings" BIGINT,
"bat_avg" DOUBLE,
"runs_1" BIGINT
);CREATE TABLE most_sixes (
"pos" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"sixes" BIGINT,
"innings" BIGINT,
"bat_avg" DOUBLE,
"runs" BIGINT
);Anyone who has the link will be able to view this.