OBD-II Datasets

Datasets from my Master Degree research.

@kaggle.cephasax_obdii_ds3

Table List

3 tables(1.09 MB)

Exp1–14drivers 14cars Dailyroutes

Exp2–19drivers 1car 1route

Exp3–4drivers 1car 1route

Exp3–4drivers 1car 1route

@kaggle.cephasax_obdii_ds3.exp3_4drivers_1car_1route

97.98 KB
1743 rows
30 columns

ord Ord	time TIME	latitude LATITUDE	longitude LONGITUDE	altitude ALTITUDE	vehicle_id VEHICLE ID	barometric_pressure BAROMETRIC PRESSURE	engine_coolant_temp ENGINE COOLANT TEMP	fuel_level FUEL LEVEL	engine_load ENGINE LOAD	ambient_air_temp AMBIENT AIR TEMP	engine_rpm ENGINE RPM	intake_manifold_pressure INTAKE MANIFOLD PRESSURE	maf MAF	air_intake_temp AIR INTAKE TEMP	speed SPEED	short_term_fuel_trim_bank_1 SHORT TERM FUEL TRIM BANK 1	engine_runtime ENGINE RUNTIME	throttle_pos THROTTLE POS	dtc_number DTC NUMBER	timing_advance TIMING ADVANCE	equiv_ratio EQUIV RATIO
1	151000000000000	-583.206.639	-3.520.573.159	42	control1	100	95	5610	4310	4	816	39	473	34		80	00:45:33	2120	MIL is OFF0 codes	5290	100
2	151000000000000	-583.206.639	-3.520.573.159	42	control1	100	95	5610	4200	4	807	37	473	34		80	00:45:37	2160	MIL is OFF0 codes	5250	100
3	151000000000000	-583.201.429	-3.520.570.624	44	control1	100	94	5610	5060	4	1559	37	1151	32	9	-620	00:45:41	2980	MIL is OFF0 codes	5690	100
4	151000000000000	-5.831.937	-3.520.569.123	41	control1	100	93	5690	4120	4	1692	46	1029	32	10	310	00:45:45	2900	MIL is OFF0 codes	7180	100
5	151000000000000	-583.184.493	-3.520.559.225	46	control1	100	91	5690	5570	4	863	52	725	32	11	470	00:45:49	2590	MIL is OFF0 codes	5800	100
6	151000000000000	-583.183.485	-3.520.548.621	47	control1		90	5730	6980	4	955	66	92	32	8	80	00:45:53	2750	MIL is OFF0 codes	6040	100
7	151000000000000	-583.182.818	-3.520.543.836	49	control1	100	90	5800	2630	4	777	51	939	32	9	230	00:45:57	2980	MIL is OFF0 codes	4630	100
8	151000000000000	-58.318.184	-3.520.531.835	51	control1	100	90	5920	4710	4	1549	41		32	13	-780	00:46:01	2940	MIL is OFF0 codes	6900	100
9	151000000000000	-583.184.651	-3.520.519.257	52	control1	100	89	6000	4940	4	2106	43	161	32	12	160	00:46:05	3180	MIL is OFF0 codes	7060	100
10	151000000000000	-58.319.008	-3.520.507.015	52	control1	100	89	6000	6240	4	1080	53	948	32	15	-160	00:46:09	2820	MIL is OFF0 codes	6200	100


CREATE TABLE exp3_4drivers_1car_1route (
  "ord" BIGINT,
  "time" DOUBLE,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "altitude" DOUBLE,
  "vehicle_id" VARCHAR,
  "barometric_pressure" DOUBLE,
  "engine_coolant_temp" DOUBLE,
  "fuel_level" DOUBLE,
  "engine_load" DOUBLE,
  "ambient_air_temp" DOUBLE,
  "engine_rpm" DOUBLE,
  "intake_manifold_pressure" BIGINT,
  "maf" DOUBLE,
  "term_fuel_trim_bank_1" VARCHAR,
  "fuel_economy" VARCHAR,
  "long_term_fuel_trim_bank_2" VARCHAR,
  "fuel_type" VARCHAR,
  "air_intake_temp" DOUBLE,
  "fuel_pressure" VARCHAR,
  "speed" DOUBLE,
  "short_term_fuel_trim_bank_2" VARCHAR,
  "short_term_fuel_trim_bank_1" DOUBLE,
  "engine_runtime" VARCHAR,
  "throttle_pos" DOUBLE,
  "dtc_number" VARCHAR,
  "trouble_codes" DOUBLE,
  "timing_advance" DOUBLE,
  "equiv_ratio" DOUBLE,
  "aqui" VARCHAR
);