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

Exp2–19drivers 1car 1route

@kaggle.cephasax_obdii_ds3.exp2_19drivers_1car_1route

266.8 KB
8261 rows
28 columns

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
151336000000000000	-58.321.307	-3.520.429.461	46	s11	100kPa	82C	74,50%	79,20%	28C	2124RPM	61kPa	24,77g/s	36C	48km/h	-1,60%	00:03:02	34,90%	MIL is OFF0 codes	66,70%	1,00%
151336000000000000	-58.323.103	-3.520.380.397	52	s11	100kPa	83C	74,10%	78,40%	28C	2617RPM	44kPa	30,96g/s	36C	60km/h	-4,70%	00:03:08	36,10%	MIL is OFF0 codes	68,20%	1,00%
151336000000000000	-583.251.443	-3.520.323.709	49	s11	100kPa	83C	73,70%	42,00%	28C	3005RPM	35kPa	18,58g/s	36C	64km/h	-10,20%	00:03:12	32,20%	MIL is OFF0 codes	75,70%	1,00%
151336000000000000	-58.328.462	-3.520.269.621	45	s11	100kPa	82C	73,70%	37,30%	28C	3156RPM	63kPa	18,38g/s	36C	65km/h	0,00%	00:03:16	32,50%	MIL is OFF0 codes	75,30%	1,00%
151336000000000000	-583.324.508	-3.520.219.432	44	s11	100kPa	82C	73,30%	76,10%	28C	1798RPM	47kPa	19,77g/s	36C	67km/h	3,10%	00:03:20	33,30%	MIL is OFF0 codes	66,30%	1,00%
151336000000000000	-583.366.445	-3.520.166.951	43	s11	100kPa	83C	72,90%	37,60%	28C	1818RPM	32kPa	9,99g/s	36C	65km/h	4,70%	00:03:24	28,60%	MIL is OFF0 codes	72,50%	1,00%
151336000000000000	-583.405.966	-3.520.115.577	42	s11	100kPa	83C	72,50%	32,20%	28C	1765RPM	35kPa	8,33g/s	37C	63km/h	1,60%	00:03:28	27,10%	MIL is OFF0 codes	74,10%	1,00%
151336000000000000	-583.445.455	-3.520.065.432	42	s11	100kPa	83C	72,50%	49,40%	28C	1721RPM	43kPa	12,56g/s	36C	63km/h	-0,80%	00:03:32	30,20%	MIL is OFF0 codes	71,40%	1,00%
151336000000000000	-583.484.672	-3.520.015.419	40	s11	100kPa	82C	72,20%	42,70%	28C	1716RPM	34kPa	10,69g/s	37C	63km/h	-0,80%	00:03:36	29,00%	MIL is OFF0 codes	71,80%	1,00%
151336000000000000	-583.523.808	-3.519.964.901	39	s11	100kPa	82C	72,20%	39,20%	28C	1759RPM	33kPa	9,78g/s	37C	67km/h	3,90%	00:03:40	28,60%	MIL is OFF0 codes	72,50%	1,00%


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