Envision Racing

Can your data-science skills help Envision Racing, take home even more trophies?

@kaggle.pavan9065_envision_racing

Table List

5 tables(500.34 KB)

Submission

Test

Test Weather

Train

Train Weather

Test

@kaggle.pavan9065_envision_racing.test

38.33 KB
420 rows
25 columns

number NUMBER	n__driver_number DRIVER NUMBER	n__lap_number LAP NUMBER	n__lap_improvement LAP IMPROVEMENT	n__crossing_finish_line_in_pit CROSSING FINISH LINE IN PIT	n__s1 S1	n__s1_improvement S1 IMPROVEMENT	n__s2 S2	n__s2_improvement S2 IMPROVEMENT	n__s3 S3	n__s3_improvement S3 IMPROVEMENT	n__kph KPH	n__elapsed ELAPSED	n__hour HOUR	s1_large S1 LARGE	s2_large S2 LARGE	s3_large S3 LARGE	driver_name DRIVER NAME	pit_time PIT TIME	group GROUP	team TEAM	power POWER	location LOCATION	event EVENT
10	1	1		nan	01:10.2		35.433		30.693		59.5	02:16.4	02:16.4	01:10.2	00:35.4	00:30.7	SB	00:47.0	1	JR		Location 7	Qualifying Group 1
10	1	2		nan	27.667		33.68		37.767		81.8	03:55.5	03:55.5	00:27.7	00:33.7	00:37.8	SB	nan	1	JR	250	Location 7	Qualifying Group 1
10	1	3	2	nan	24.688	2	29.309	2	27.111	2	100	05:16.6	05:16.6	00:24.7	00:29.3	00:27.1	SB	nan	1	JR	250	Location 7	Qualifying Group 1
13	1	1		nan	01:09.1		35.705		30.451		59.9	02:15.2	02:15.2	01:09.1	00:35.7	00:30.5	ACO	00:44.7	1	DSo		Location 7	Qualifying Group 1
13	1	2		nan	28.401		33.693		35.958		82.7	03:53.3	03:53.3	00:28.4	00:33.7	00:36.0	ACO	nan	1	DSo	250	Location 7	Qualifying Group 1
13	1	3	2	nan	24.79	2	29.397	2	27.008	2	99.8	05:14.5	05:14.5	00:24.8	00:29.4	00:27.0	ACO	nan	1	DSo	250	Location 7	Qualifying Group 1
17	1	1		nan	01:09.9		35.445		30.638		59.6	02:16.0	02:16.0	01:09.9	00:35.4	00:30.6	NVR	00:46.1	1	ME		Location 7	Qualifying Group 1
17	1	2		nan	28.728		35.81		37.476		79.5	03:58.0	03:58.0	00:28.7	00:35.8	00:37.5	NVR	nan	1	ME	250	Location 7	Qualifying Group 1
17	1	3	4	nan	24.491	4	29.215	4	26.805	2	100.7	05:18.5	05:18.5	00:24.5	00:29.2	00:26.8	NVR	nan	1	ME	250	Location 7	Qualifying Group 1
27	1	1		nan	01:05.6		36.506		30.395		61.2	02:12.5	02:12.5	01:05.6	00:36.5	00:30.4	J	00:42.3	1	BMWE		Location 7	Qualifying Group 1


CREATE TABLE test (
  "number" BIGINT,
  "n__driver_number" BIGINT,
  "n__lap_number" BIGINT,
  "lap_time" VARCHAR,
  "n__lap_improvement" BIGINT,
  "n__crossing_finish_line_in_pit" VARCHAR,
  "n__s1" VARCHAR,
  "n__s1_improvement" BIGINT,
  "n__s2" VARCHAR,
  "n__s2_improvement" BIGINT,
  "n__s3" VARCHAR,
  "n__s3_improvement" BIGINT,
  "n__kph" DOUBLE,
  "n__elapsed" VARCHAR,
  "n__hour" VARCHAR,
  "s1_large" VARCHAR,
  "s2_large" VARCHAR,
  "s3_large" VARCHAR,
  "driver_name" VARCHAR,
  "pit_time" VARCHAR,
  "group" DOUBLE,
  "team" VARCHAR,
  "power" DOUBLE,
  "location" VARCHAR,
  "event" VARCHAR
);