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

Train

@kaggle.pavan9065_envision_racing.train

415.74 KB
10276 rows
25 columns

number NUMBER	n__driver_number DRIVER NUMBER	n__lap_number LAP NUMBER	lap_time LAP TIME	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	team TEAM	location LOCATION	event EVENT
10	1	1	92		nan	05:43.3		35.427		43.313		28.8	07:02.0	22:02.0	05:43.3	00:35.4	00:43.3	SB	05:14.7	JR	Location 2	Free Practice 2
10	1	2	87	2	nan	25.674	2	33.399	2	41.922	2	120.5	08:43.0	23:43.0	00:25.7	00:33.4	00:41.9	SB	nan	JR	Location 2	Free Practice 2
10	1	3	73		B	28.129		34.091		57.248		101.9	10:42.5	25:42.5	00:28.1	00:34.1	00:57.2	SB	nan	JR	Location 2	Free Practice 2
11	1	1	73		nan	01:05.0		38.416		56.833		75.9	02:40.2	17:40.2	01:05.0	00:38.4	00:56.8	LGRA	00:33.0	AD	Location 2	Free Practice 2
11	1	2	73		nan	28.013		36.743		44.716		111.2	04:29.7	19:29.7	00:28.0	00:36.7	00:44.7	LGRA	nan	AD	Location 2	Free Practice 2
11	1	3	101	2	nan	25.851	2	33.374	2	42.466	2	119.7	06:11.4	21:11.4	00:25.9	00:33.4	00:42.5	LGRA	nan	AD	Location 2	Free Practice 2
11	1	4	105		B	27.918		34.646		48.038		110	08:02.0	23:02.0	00:27.9	00:34.6	00:48.0	LGRA	nan	AD	Location 2	Free Practice 2
13	1	1	84		nan	46.912		42.191		49.395		87.9	02:18.5	17:18.5	00:46.9	00:42.2	00:49.4	ACO	00:12.7	DSo	Location 2	Free Practice 2
13	1	2	85		nan	25.727		33.385		42.392		119.9	04:00.0	19:00.0	00:25.7	00:33.4	00:42.4	ACO	nan	DSo	Location 2	Free Practice 2
13	1	3	101		nan	29.068		52.345		01:03.7		83.8	06:25.1	21:25.1	00:29.1	00:52.3	01:03.7	ACO	nan	DSo	Location 2	Free Practice 2


CREATE TABLE train (
  "number" BIGINT,
  "n__driver_number" BIGINT,
  "n__lap_number" BIGINT,
  "lap_time" BIGINT,
  "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
);