Learn Pandas

Learn Pandas with dataset

@kaggle.js1js2js3js4js5_learn_pandas

Table List

2 tables(692.92 KB)

Ipl

@kaggle.js1js2js3js4js5_learn_pandas.ipl

29.78 KB
636 rows
18 columns

id Id	season Season	city City	date Date	team1 Team1	team2 Team2	toss_winner Toss Winner	toss_decision Toss Decision	result Result	winner Winner	win_by_runs Win By Runs	win_by_wickets Win By Wickets	player_of_match Player Of Match	venue Venue	umpire1 Umpire1	umpire2 Umpire2
1	2017	Hyderabad	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sunrisers Hyderabad	Royal Challengers Bangalore	Royal Challengers Bangalore	field	normal	Sunrisers Hyderabad	35		Yuvraj Singh	Rajiv Gandhi International Stadium, Uppal	AY Dandekar	NJ Llong
2	2017	Pune	Thu Apr 06 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Mumbai Indians	Rising Pune Supergiant	Rising Pune Supergiant	field	normal	Rising Pune Supergiant		7	SPD Smith	Maharashtra Cricket Association Stadium	A Nand Kishore	S Ravi
3	2017	Rajkot	Fri Apr 07 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Gujarat Lions	Kolkata Knight Riders	Kolkata Knight Riders	field	normal	Kolkata Knight Riders		10	CA Lynn	Saurashtra Cricket Association Stadium	Nitin Menon	CK Nandan
4	2017	Indore	Sat Apr 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Rising Pune Supergiant	Kings XI Punjab	Kings XI Punjab	field	normal	Kings XI Punjab		6	GJ Maxwell	Holkar Cricket Stadium	AK Chaudhary	C Shamshuddin
5	2017	Bangalore	Sat Apr 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Royal Challengers Bangalore	Delhi Daredevils	Royal Challengers Bangalore	bat	normal	Royal Challengers Bangalore	15		KM Jadhav	M Chinnaswamy Stadium	nan	nan
6	2017	Hyderabad	Sun Apr 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Gujarat Lions	Sunrisers Hyderabad	Sunrisers Hyderabad	field	normal	Sunrisers Hyderabad		9	Rashid Khan	Rajiv Gandhi International Stadium, Uppal	A Deshmukh	NJ Llong
7	2017	Mumbai	Sun Apr 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Kolkata Knight Riders	Mumbai Indians	Mumbai Indians	field	normal	Mumbai Indians		4	N Rana	Wankhede Stadium	Nitin Menon	CK Nandan
8	2017	Indore	Mon Apr 10 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Royal Challengers Bangalore	Kings XI Punjab	Royal Challengers Bangalore	bat	normal	Kings XI Punjab		8	AR Patel	Holkar Cricket Stadium	AK Chaudhary	C Shamshuddin
9	2017	Pune	Tue Apr 11 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Delhi Daredevils	Rising Pune Supergiant	Rising Pune Supergiant	field	normal	Delhi Daredevils	97		SV Samson	Maharashtra Cricket Association Stadium	AY Dandekar	S Ravi
10	2017	Mumbai	Wed Apr 12 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sunrisers Hyderabad	Mumbai Indians	Mumbai Indians	field	normal	Mumbai Indians		4	JJ Bumrah	Wankhede Stadium	Nitin Menon	CK Nandan


CREATE TABLE ipl (
  "id" BIGINT,
  "season" BIGINT,
  "city" VARCHAR,
  "date" TIMESTAMP,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "result" VARCHAR,
  "dl_applied" BIGINT,
  "winner" VARCHAR,
  "win_by_runs" BIGINT,
  "win_by_wickets" BIGINT,
  "player_of_match" VARCHAR,
  "venue" VARCHAR,
  "umpire1" VARCHAR,
  "umpire2" VARCHAR,
  "umpire3" VARCHAR
);