Longitudinal Indoor Personal Comfort Preferences

Thermal/light/noise data captured from building occupants using smartwatches

@kaggle.claytonmiller_longitudinal_personal_thermal_comfort_preferences

Table List

3 tables(385.65 KB)

Cresh Tabular Merged

Enth Surveys Renamed

Enth Tabular Merged

Enth Tabular Merged

@kaggle.claytonmiller_longitudinal_personal_thermal_comfort_preferences.enth_tabular_merged

127.7 KB
1403 rows
38 columns

time Time	space_id Space Id	building_name Building Name	air_vel Air Vel	body_presence Body Presence	change Change	clothing Clothing	comfort Comfort	heartrate Heartrate	indoor_outdoor Indoor/outdoor	met Met	response_speed Response Speed	resting_heartrate Resting Heartrate	thermal Thermal	nb_temp Nb Temp	indoor_floor Indoor Floor	indoor_latitude Indoor Latitude	indoor_longitude Indoor Longitude	skin_temp Skin Temp	n_0_3um_count_outdoor 0.3um Count Outdoor	n_0_5um_count_outdoor 0.5um Count Outdoor	n_1_0um_count_outdoor 1.0um Count Outdoor	n_10_0um_count_outdoor 10.0um Count Outdoor	n_2_5um_count_outdoor 2.5um Count Outdoor	n_5_0um_count_outdoor 5.0um Count Outdoor	humidity_outdoor Humidity Outdoor	pm1_0_outdoor Pm1.0 Outdoor	pm10_0_outdoor Pm10.0 Outdoor	pm2_5_outdoor Pm2.5 Outdoor	pressure_outdoor Pressure Outdoor	temp_outdoor Temp Outdoor	user_id User Id	temp_zone Temp Zone	humidity_zone Humidity Zone
2021-03-17 15:30:00+08:00	2	SDE4	10	true	10	10	10	87	11	9	16.957	76	11	29.688	3	1.296825097683639	103.7704772268482	29.812	1708.38	507.77	61.04		3.83	0.56		8.67	12.83	12.21			enth15
2021-03-17 15:33:00+08:00	2	SDE4	10	true	10	10	10	67	11	9	11.725	76	11	29.562	3	1.296825097683639	103.7704772268482	33	1708.38	507.77	61.04		3.83	0.56		8.67	12.83	12.21			enth15
2021-03-17 15:53:00+08:00	2	SDE4	10	true	10	10	9	87	9	10	10.483	76	11	30.062	3	1.296798531944173	103.77048171957446	34.375	1064.4	318.44	44.67		3.51	1.58		5.31	9.04	7.71			enth15
2021-03-17 16:08:00+08:00	210	SDE2	11	true	10	10	10	70	11	9	10.323	76	10	28.188	3	1.2975432200761334	103.77124811097369	33.438	1362.64	383.48	58.18	0.21	2.39	0.21	58	6.41	9.59	9.09	1003.94	28.89	enth15
2021-03-17 16:23:00+08:00	210	SDE2	11	true	10	10	10	66	11	9	5.869	76	10	28.938	3	1.297542522682694	103.77123650159923	33.375	1644.4	497.04	81.4	0.23	3.92	0.42		8.47	13.34	13.06			enth15	24.919891
2021-03-17 16:39:00+08:00	210	SDE2	11	true	10	10	10	61	11	10	7.836	76	11	29.25	3	1.2975401113193874	103.77118766976548	33.375	1864.79	543.05	84.53	0.63	4.79	2.3	65	8.98	15.14	13.47	1003.67	28.33	enth15		51
2021-03-17 16:55:00+08:00	210	SDE2	11	true	10	10	10	65	11	9	7.328	76	10	29.125	3	1.2975081067089604	103.7712487027988	33.562	1898.62	561.75	73.42	0.16	3.02	0.24		9.85	14.02	13.71			enth15		51
2021-03-17 17:11:00+08:00	210	SDE2	11	true	10	10	10	69	11	9	7.023	71	10	29.062	3	1.2975228718501597	103.77123687915798	34.125	1797.27	512.56	74.36	0.47	2.84	0.85	62	8.82	12.85	12.38	1003.42	28.33	enth15		50
2021-03-17 17:26:00+08:00	210	SDE2	11	true	10	10	10	64	11	9	7.992	71	10	29.125	3	1.2975265950959438	103.77118276468292	33.938	1585.82	474.5	64.3	0.57	5.25	1.27		8.3	12.75	11.88			enth15	25.715645
2021-03-17 17:45:00+08:00	210	SDE2	11	true	10	10	10	67	11	9	96.51	72	10	29.938	3	1.2975384064873927	103.77122698183166	33.625	2310.93	693.8	100.78	0.62	4.38	1.84		12.62	18.53	17.53			enth15	25.758377


CREATE TABLE enth_tabular_merged (
  "time" VARCHAR,
  "space_id" BIGINT,
  "building_name" VARCHAR,
  "air_vel" DOUBLE,
  "body_presence" BOOLEAN,
  "change" DOUBLE,
  "clothing" DOUBLE,
  "comfort" DOUBLE,
  "heartrate" DOUBLE,
  "indoor_outdoor" DOUBLE,
  "met" DOUBLE,
  "response_speed" DOUBLE,
  "resting_heartrate" BIGINT,
  "thermal" DOUBLE,
  "nb_temp" DOUBLE,
  "indoor_floor" DOUBLE,
  "indoor_latitude" DOUBLE,
  "indoor_longitude" DOUBLE,
  "skin_temp" DOUBLE,
  "co2_indoor" DOUBLE,
  "voc_indoor" DOUBLE,
  "pm25_indoor" DOUBLE,
  "noise_indoor" DOUBLE,
  "n_0_3um_count_outdoor" DOUBLE,
  "n_0_5um_count_outdoor" DOUBLE,
  "n_1_0um_count_outdoor" DOUBLE,
  "n_10_0um_count_outdoor" DOUBLE,
  "n_2_5um_count_outdoor" DOUBLE,
  "n_5_0um_count_outdoor" DOUBLE,
  "humidity_outdoor" DOUBLE,
  "pm1_0_outdoor" DOUBLE,
  "pm10_0_outdoor" DOUBLE,
  "pm2_5_outdoor" DOUBLE,
  "pressure_outdoor" DOUBLE,
  "temp_outdoor" DOUBLE,
  "user_id" VARCHAR,
  "temp_zone" DOUBLE,
  "humidity_zone" DOUBLE
);