IPL Cricket Analysis Dataset

Cleaned ESPN Cricket Dataset for Game Analysis

@kaggle.diishasiing_cricket_analysis_dataset

Table List

4 tables(86.18 KB)

Df Match

@kaggle.diishasiing_cricket_analysis_dataset.df_match

6.26 KB
45 rows
7 columns

team1 Team1	team2 Team2	winner Winner	margin Margin	ground Ground	matchdate MatchDate	match_id Match Id
Namibia	Sri Lanka	Namibia	55 runs	Geelong	Sun Oct 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T20I # 1823
Netherlands	U.A.E.	Netherlands	3 wickets	Geelong	Sun Oct 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T20I # 1825
Scotland	West Indies	Scotland	42 runs	Hobart	Mon Oct 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T20I # 1826
Ireland	Zimbabwe	Zimbabwe	31 runs	Hobart	Mon Oct 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T20I # 1828
Namibia	Netherlands	Netherlands	5 wickets	Geelong	Tue Oct 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T20I # 1830
Sri Lanka	U.A.E.	Sri Lanka	79 runs	Geelong	Tue Oct 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T20I # 1832
Ireland	Scotland	Ireland	6 wickets	Hobart	Wed Oct 19 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T20I # 1833
West Indies	Zimbabwe	West Indies	31 runs	Hobart	Wed Oct 19 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T20I # 1834
Netherlands	Sri Lanka	Sri Lanka	16 runs	Geelong	Thu Oct 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T20I # 1835
Namibia	U.A.E.	U.A.E.	7 runs	Geelong	Thu Oct 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T20I # 1836


CREATE TABLE df_match (
  "team1" VARCHAR,
  "team2" VARCHAR,
  "winner" VARCHAR,
  "margin" VARCHAR,
  "ground" VARCHAR,
  "matchdate" TIMESTAMP,
  "match_id" VARCHAR
);