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

Exp1–14drivers 14cars Dailyroutes

@kaggle.cephasax_obdii_ds3.exp1_14drivers_14cars_dailyroutes

747.17 KB
60439 rows
33 columns

timestamp TIMESTAMP	mark MARK	model MODEL	car_year CAR YEAR	engine_power ENGINE POWER	automatic AUTOMATIC	vehicle_id VEHICLE ID	barometric_pressure_kpa BAROMETRIC PRESSURE(KPA)	engine_coolant_temp ENGINE COOLANT TEMP	fuel_level FUEL LEVEL	engine_load ENGINE LOAD	engine_rpm ENGINE RPM	intake_manifold_pressure INTAKE MANIFOLD PRESSURE	maf MAF	long_term_fuel_trim_bank_2 LONG TERM FUEL TRIM BANK 2	fuel_type FUEL TYPE	air_intake_temp AIR INTAKE TEMP	short_term_fuel_trim_bank_2 SHORT TERM FUEL TRIM BANK 2	short_term_fuel_trim_bank_1 SHORT TERM FUEL TRIM BANK 1	engine_runtime ENGINE RUNTIME	throttle_pos THROTTLE POS	dtc_number DTC NUMBER	trouble_codes TROUBLE CODES	timing_advance TIMING ADVANCE	equiv_ratio EQUIV RATIO	min MIN	hours HOURS	days_of_week DAYS OF WEEK	months MONTHS	year YEAR
1502902504267	chevrolet	agile	2011	14	n	car1	100	80	48,60%	33,30%	1009	49	449	nan	Biodiesel_Ethanol	59	nan	nan	00:03:28	25%	MIL is OFF0 codes	nan	56,9%	1,0%	13	16	2	8	2017
1502902512283	chevrolet	agile	2011	14	n	car1	100	80	48,60%	32,50%	1003	52	451	nan	Biodiesel_Ethanol	59	nan	nan	00:03:35	25%	MIL is OFF0 codes	nan	56,5%	1,0%	13	16	2	8	2017
1502902520291	chevrolet	agile	2011	14	n	car1	100	80	48,60%	32,90%	995	51	448	nan	Biodiesel_Ethanol	59	nan	nan	00:03:43	25%	MIL is OFF0 codes	nan	57,3%	1,0%	13	16	2	8	2017
1502902528300	chevrolet	agile	2011	14	n	car1	100	80	48,60%	32,50%	1004	51	451	nan	Biodiesel_Ethanol	60	nan	nan	00:03:51	25%	MIL is OFF0 codes	nan	56,5%	1,0%	13	16	2	8	2017
1502902536320	chevrolet	agile	2011	14	n	car1	100	80	48,60%	32,90%	1005	49	449	nan	Biodiesel_Ethanol	60	nan	nan	00:03:59	25%	MIL is OFF0 codes	nan	56,9%	1,0%	13	16	2	8	2017
1502902544348	chevrolet	agile	2011	14	n	car1	100	81	48,60%	32,90%	1019	50	456	nan	Biodiesel_Ethanol	60	nan	nan	00:04:07	25%	MIL is OFF0 codes	nan	56,5%	1,0%	13	16	2	8	2017
1502902552372	chevrolet	agile	2011	14	n	car1	100	81	48,60%	33,30%	1002	49	457	nan	Biodiesel_Ethanol	61	nan	nan	00:04:15	25%	MIL is OFF0 codes	nan	56,5%	1,0%	13	16	2	8	2017
1502902560377	chevrolet	agile	2011	14	n	car1	100	81	48,60%	33,30%	1001	50	445	nan	Biodiesel_Ethanol	61	nan	nan	00:04:23	25%	MIL is OFF0 codes	nan	57,3%	1,0%	13	16	2	8	2017
1502902568389	chevrolet	agile	2011	14	n	car1	100	81	48,60%	33,30%	1004	52	452	nan	Biodiesel_Ethanol	61	nan	nan	00:04:31	25%	MIL is OFF0 codes	nan	56,9%	1,0%	13	16	2	8	2017
1502902576403	chevrolet	agile	2011	14	n	car1	100	81	48,60%	32,90%	1010	52	46	nan	Biodiesel_Ethanol	62	nan	nan	00:04:39	25%	MIL is OFF0 codes	nan	58,4%	1,0%	13	16	2	8	2017


CREATE TABLE exp1_14drivers_14cars_dailyroutes (
  "timestamp" DOUBLE,
  "mark" VARCHAR,
  "model" VARCHAR,
  "car_year" DOUBLE,
  "engine_power" DOUBLE,
  "automatic" VARCHAR,
  "vehicle_id" VARCHAR,
  "barometric_pressure_kpa" DOUBLE,
  "engine_coolant_temp" DOUBLE,
  "fuel_level" VARCHAR,
  "engine_load" VARCHAR,
  "ambient_air_temp" DOUBLE,
  "engine_rpm" DOUBLE,
  "intake_manifold_pressure" DOUBLE,
  "maf" DOUBLE,
  "long_term_fuel_trim_bank_2" VARCHAR,
  "fuel_type" VARCHAR,
  "air_intake_temp" DOUBLE,
  "fuel_pressure" DOUBLE,
  "speed" DOUBLE,
  "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,
  "min" DOUBLE,
  "hours" DOUBLE,
  "days_of_week" DOUBLE,
  "months" DOUBLE,
  "year" DOUBLE
);