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

Cresh Tabular Merged

@kaggle.claytonmiller_longitudinal_personal_thermal_comfort_preferences.cresh_tabular_merged

229.27 KB
4378 rows
25 columns

unnamed_0 Unnamed: 0	index Index	time Time	clothing Clothing	comfort_cozie Comfort Cozie	heartrate_cozie HeartRate Cozie	light_cozie Light Cozie	noise_cozie Noise Cozie	responsespeed_cozie ResponseSpeed Cozie	thermal_cozie Thermal Cozie	user_id User Id	floor Floor	latitude Latitude	longitude Longitude	space_id Space Id	co2_sensing Co2 Sensing	humidity_sensing Humidity Sensing	light_sensing Light Sensing	noise_sensing Noise Sensing	temperature_sensing Temperature Sensing	voc_sensing Voc Sensing
		2019-09-28 09:07:28.561000+00:00			79			0.037		cresh39
1	1	2019-09-29 09:07:30.131000+00:00			79			0.038		cresh39
2	2	2019-09-30 00:55:46.387000+00:00	10	9	102	10	10	246.293	9	cresh39
3	3	2019-09-30 01:04:23.821000+00:00	10	9	91	10	10	2.66	11	cresh39
4	4	2019-09-30 03:07:36.976000+00:00	10		93		10	5.731		cresh39
5	5	2019-09-30 03:07:42.184000+00:00	10	10	99	10	10	1.958	10	cresh39
6	6	2019-09-30 03:30:56.306000+00:00	10	10	70	10	10	1.7970000000000002	10	cresh39
7	7	2019-09-30 04:00:57.716000+00:00	10	9	66	10	10	2.983	9	cresh39
8	8	2019-09-30 04:08:23.750000+00:00	9	10	68	10	10	3.573	10	cresh35	2	1.2973841082535882	103.77105071181292	45	732	50.8191	158	47	26.1212	66
9	9	2019-09-30 04:37:53.719000+00:00	9	10	76	10	10	4.83	10	cresh35


CREATE TABLE cresh_tabular_merged (
  "unnamed_0" BIGINT,
  "index" BIGINT,
  "time" VARCHAR,
  "clothing" DOUBLE,
  "comfort_cozie" DOUBLE,
  "heartrate_cozie" DOUBLE,
  "lat_cozie" DOUBLE,
  "light_cozie" DOUBLE,
  "lon_cozie" DOUBLE,
  "noise_cozie" DOUBLE,
  "responsespeed_cozie" DOUBLE,
  "thermal_cozie" DOUBLE,
  "user_id" VARCHAR,
  "floor" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "space_id" DOUBLE,
  "room" DOUBLE,
  "co2_sensing" DOUBLE,
  "humidity_sensing" DOUBLE,
  "light_sensing" DOUBLE,
  "noise_sensing" DOUBLE,
  "temperature_sensing" DOUBLE,
  "voc_sensing" DOUBLE,
  "temperature_mbient" DOUBLE
);