Tennis ATP Tour Australian Open Final 2019

A tribute to Novac Djokovic and Rafael Nadal

@kaggle.robseidl_tennis_atp_tour_australian_open_final_2019

Table List

4 tables(70.87 KB)

Events

Points

Rallies

Serves

Rallies

@kaggle.robseidl_tennis_atp_tour_australian_open_final_2019.rallies

12.95 KB
206 rows
11 columns

unnamed_0 Unnamed: 0	rallyid Rallyid	server Server	returner Returner	winner Winner	reason Reason	serve Serve	strokes Strokes	totaltime Totaltime	x X	y Y
	1	Djokovic	Nadal	Djokovic	winner	first	3	0.92	1.92	21.96
1	2	Djokovic	Nadal	__undefined__	second_serve	first	1		7.42	12.1
2	3	Djokovic	Nadal	Djokovic	out	second	4	4.159999999999997	3.33	-0.39
3	4	Djokovic	Nadal	__undefined__	second_serve	first	1		4.64	17.69
4	5	Djokovic	Nadal	Djokovic	ace	second	2	0.3999999999999915	1.62	17.18
5	6	Djokovic	Nadal	Djokovic	net	first	10	10.400000000000006	6.41	12.78
6	7	Nadal	Djokovic	__undefined__	second_serve	first	1		4.48	12.04
7	8	Nadal	Djokovic	Djokovic	out	second	7	7.199999999999989	0.5	18.67
8	9	Nadal	Djokovic	Djokovic	winner	first	12	0.920000000000016	3.65	9.5
9	10	Nadal	Djokovic	__undefined__	let	first	1		2.9	14.68


CREATE TABLE rallies (
  "unnamed_0" BIGINT,
  "rallyid" BIGINT,
  "server" VARCHAR,
  "returner" VARCHAR,
  "winner" VARCHAR,
  "reason" VARCHAR,
  "serve" VARCHAR,
  "strokes" BIGINT,
  "totaltime" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);