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

Events

@kaggle.robseidl_tennis_atp_tour_australian_open_final_2019.events

38.42 KB
865 rows
15 columns

unnamed_0 Unnamed: 0	rallyid Rallyid	frameid Frameid	strokeid Strokeid	hitter Hitter	receiver Receiver	isserve Isserve	serve Serve	type Type	stroke Stroke	hitter_x Hitter X	hitter_y Hitter Y	receiver_x Receiver X	receiver_y Receiver Y	time Time
	1	70877	1	Djokovic	Nadal	true	first	serve	forehand	6.5	-0.24	1.03	27.44
1	1	70900	2	Nadal	Djokovic		first	slice	backhand	0.05	25.59	6.17	1.11	0.92
2	1	70950	3	Djokovic	Nadal		first	topspin	forehand	1.42	2.33	4.75	26.45	2.9200000000000004
3	2	71488	1	Djokovic	Nadal	true	first	serve	forehand	4.48	-0.01	7.9	26.83	24.44
4	3	71796	1	Djokovic	Nadal	true	second	serve	forehand	4.48	-0.37	7.88	26.47	36.760000000000005
5	3	71820	2	Nadal	Djokovic		second	slice	forehand	7.4	24.79	4.47	0.19	37.72
6	3	71860	3	Djokovic	Nadal		second	topspin	backhand	1.66	0.43	6.12	25.84	39.32
7	3	71900	4	Nadal	Djokovic		second	topspin	forehand	8.14	27.07	3.12	-0.94	40.92
8	4	72470	1	Djokovic	Nadal	true	first	serve	forehand	6.44	-0.27	0.96	26.71	63.720000000000006
9	5	72790	1	Djokovic	Nadal	true	second	serve	forehand	6.17	-0.22	0.54	27.32	76.52000000000001


CREATE TABLE events (
  "unnamed_0" BIGINT,
  "rallyid" BIGINT,
  "frameid" BIGINT,
  "strokeid" BIGINT,
  "hitter" VARCHAR,
  "receiver" VARCHAR,
  "isserve" BOOLEAN,
  "serve" VARCHAR,
  "type" VARCHAR,
  "stroke" VARCHAR,
  "hitter_x" DOUBLE,
  "hitter_y" DOUBLE,
  "receiver_x" DOUBLE,
  "receiver_y" DOUBLE,
  "time" DOUBLE
);