Learn Pandas

Learn Pandas with dataset

@kaggle.js1js2js3js4js5_learn_pandas

Table List

2 tables(692.92 KB)

Deliveries

@kaggle.js1js2js3js4js5_learn_pandas.deliveries

663.14 KB
150460 rows
21 columns

match_id Match Id	inning Inning	batting_team Batting Team	bowling_team Bowling Team	over Over	ball Ball	batsman Batsman	non_striker Non Striker	bowler Bowler	wide_runs Wide Runs	legbye_runs Legbye Runs	noball_runs Noball Runs	batsman_runs Batsman Runs	extra_runs Extra Runs	total_runs Total Runs	player_dismissed Player Dismissed	dismissal_kind Dismissal Kind	fielder Fielder
1	1	Sunrisers Hyderabad	Royal Challengers Bangalore	1	1	DA Warner	S Dhawan	TS Mills							nan	nan	nan
1	1	Sunrisers Hyderabad	Royal Challengers Bangalore	1	2	DA Warner	S Dhawan	TS Mills							nan	nan	nan
1	1	Sunrisers Hyderabad	Royal Challengers Bangalore	1	3	DA Warner	S Dhawan	TS Mills				4		4	nan	nan	nan
1	1	Sunrisers Hyderabad	Royal Challengers Bangalore	1	4	DA Warner	S Dhawan	TS Mills							nan	nan	nan
1	1	Sunrisers Hyderabad	Royal Challengers Bangalore	1	5	DA Warner	S Dhawan	TS Mills	2				2	2	nan	nan	nan
1	1	Sunrisers Hyderabad	Royal Challengers Bangalore	1	6	S Dhawan	DA Warner	TS Mills							nan	nan	nan
1	1	Sunrisers Hyderabad	Royal Challengers Bangalore	1	7	S Dhawan	DA Warner	TS Mills		1			1	1	nan	nan	nan
1	1	Sunrisers Hyderabad	Royal Challengers Bangalore	2	1	S Dhawan	DA Warner	A Choudhary				1		1	nan	nan	nan
1	1	Sunrisers Hyderabad	Royal Challengers Bangalore	2	2	DA Warner	S Dhawan	A Choudhary				4		4	nan	nan	nan
1	1	Sunrisers Hyderabad	Royal Challengers Bangalore	2	3	DA Warner	S Dhawan	A Choudhary			1		1	1	nan	nan	nan


CREATE TABLE deliveries (
  "match_id" BIGINT,
  "inning" BIGINT,
  "batting_team" VARCHAR,
  "bowling_team" VARCHAR,
  "over" BIGINT,
  "ball" BIGINT,
  "batsman" VARCHAR,
  "non_striker" VARCHAR,
  "bowler" VARCHAR,
  "is_super_over" BIGINT,
  "wide_runs" BIGINT,
  "bye_runs" BIGINT,
  "legbye_runs" BIGINT,
  "noball_runs" BIGINT,
  "penalty_runs" BIGINT,
  "batsman_runs" BIGINT,
  "extra_runs" BIGINT,
  "total_runs" BIGINT,
  "player_dismissed" VARCHAR,
  "dismissal_kind" VARCHAR,
  "fielder" VARCHAR
);