Bangladesh Cricket Team Yearly Performance
Yearly match results summary based on different types of grounds (Test,ODI,T-20)
@kaggle.azizulhakim98_bangladesh_cricket_team_yearly_performance
Yearly match results summary based on different types of grounds (Test,ODI,T-20)
@kaggle.azizulhakim98_bangladesh_cricket_team_yearly_performance
Cricket is a very popular game in Bangladesh. As a fan of Bangladeshi cricket, i wanna have insights team performance based on different types of venues.
There are three datasets for test, ODI(One Day International) and T-20. The date started from the year Bangladesh started to play cricket,1986. All the data included here are of official matches. Each dataset contains yearly wins, loses and three types of venues, home ground, away ground and neutral ground total matches and wins,
.
To predict Bangladesh winning based on the ground they are playing.
CREATE TABLE bangladesh_cricket_team_yearly_result_summary_odi (
"year" BIGINT,
"total_matches" BIGINT,
"won" BIGINT,
"lost" BIGINT,
"tied" BIGINT,
"w_l" VARCHAR,
"home_matches" BIGINT,
"home_wins" BIGINT,
"away_matches" BIGINT,
"away_wins" BIGINT,
"neutral_matches" BIGINT,
"neutral_wins" BIGINT
);
CREATE TABLE bangladesh_cricket_team_yearly_result_summary_t_20 (
"year" BIGINT,
"total_matches" BIGINT,
"won" BIGINT,
"lost" BIGINT,
"tied" BIGINT,
"w_l" VARCHAR,
"home_matches" BIGINT,
"home_wins" BIGINT,
"away_matches" BIGINT,
"away_wins" BIGINT,
"neutral_matches" BIGINT,
"neutral_wins" BIGINT
);
CREATE TABLE bangladesh_cricket_team_yearly_result_summary_test (
"year" BIGINT,
"total_matches" BIGINT,
"won" BIGINT,
"lost" BIGINT,
"draw" BIGINT,
"w_l" DOUBLE,
"home_matches" BIGINT,
"home_wins" BIGINT,
"away_matches" BIGINT,
"away_wins" BIGINT,
"neutral_matches" BIGINT,
"neutral_win" BIGINT
);
Anyone who has the link will be able to view this.