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 Surveys Renamed

@kaggle.claytonmiller_longitudinal_personal_thermal_comfort_preferences.enth_surveys_renamed

28.68 KB
17 rows
40 columns

user_id User Id	yob Yob	sex Sex	height Height	weight Weight	shoulder_circumference Shoulder Circumference	years_here Years Here	used_weather Used Weather	satisfaction_weather Satisfaction Weather	sweating Sweating	enjoy_ourdoor Enjoy Ourdoor	outdoor_hr_weekday Outdoor Hr Weekday	outdoor_hr_weekend Outdoor Hr Weekend	subtleties_awareness Subtleties Awareness	overwhelemed_awareness Overwhelemed Awareness	rich_life Rich Life	rattled Rattled	deeply_moved Deeply Moved	annoyed Annoyed	violent_movies Violent Movies	unpleasant Unpleasant	changes_shake Changes Shake	delicates Delicates	stimuli_awareness Stimuli Awareness	nervous Nervous	life_ideal Life Ideal	life_conditions Life Conditions	life_satisfaction Life Satisfaction	important_things Important Things	life_changes Life Changes	extraverted Extraverted	critical Critical	dependable Dependable	anxious Anxious	new_exp New Exp	reserved Reserved	sympathetic Sympathetic	disorganized Disorganized	calm Calm	conventional Conventional
enth01	2000	Female	164	48	156	21	Yes	Slightly Dissatisfied	5	No	5	6	6	2	5	6	4	6	3	6	7	6	7	3	7	7	7	7	7	6	7	4	7	5	5	6	6	3	2
enth02	1999	Male	180	94	116	22	Yes	Slightly Dissatisfied	5	Yes	6	4	6	6	5	3	7	5	1	3	6	7	6	3	5	7	7	3	5	7	5	3	1	7	1	7	3	5	2
enth03	1998	Female	160	53	94	4	Yes	Slightly Satisfied	3	Yes	2	5	4	6	4	7	5	6	3	6	5	5	7	5	6	5	6	6	6	4	4	5	4	3	5	3	1	5	4
enth04	1997	Male	178	69	52	24	Yes	Neither Satisfied nor Dissatisfied	5	Yes	4	6	5	6	5	5	5	6	3	6	5	5	6	4	5	5	4	4	3	5	6	6	5	4	5	6	3	4	4
enth05	1999	Male	178	107	115	22	Yes	Extremely Dissatisfied	5	No	2	3	6	7	4	6	7	7	4	5	5	7	7	6	5	6	6	4	3	4	6	6	5	6	5	4	3	6	4
enth07	1996	Male	191	95	118	24	Yes	Slightly Satisfied	3	Yes	2	2	5	6	4	4	6	5	2	4	4	6	7	4	3	4	4	4	4	3	2	5	4	5	5	5	5	5	4
enth09	1994	Male	182	79	100	26	Yes	Moderately Satisfied	3	Yes	2	3	6	2	7	5	5	4	2	3	5	6	3	5	5	5	6	6	6	6	2	7	2	7	5	5	4	5	7
enth10	1999	Male	175	64	100	22	Yes	Neither Satisfied nor Dissatisfied	5	Yes	8	10	4	1	3	3	5	3	1	2	2	5	2	2	4	4	5	5	5	7	5	7	1	7	1	6	2	2	1
enth11	1998	Female	158	57	94	23	Yes	Slightly Dissatisfied	3	Yes	2	3	5	5	5	4	6	5	3	6	3	5	3	5	5	5	5	6	5	5	2	5	3	5	4	6	3	6	3
enth13	2000	Male	184	97	120	21	Yes	Slightly Satisfied	4	Yes	2	3	5	5	4	6	5	5	1	4	5	5	5	6	3	5	3	5	3	3	5	5	4	5	6	5	4	4	3


CREATE TABLE enth_surveys_renamed (
  "user_id" VARCHAR,
  "yob" BIGINT,
  "sex" VARCHAR,
  "height" BIGINT,
  "weight" DOUBLE,
  "shoulder_circumference" BIGINT,
  "years_here" BIGINT,
  "used_weather" VARCHAR,
  "satisfaction_weather" VARCHAR,
  "sweating" BIGINT,
  "enjoy_ourdoor" VARCHAR,
  "outdoor_hr_weekday" BIGINT,
  "outdoor_hr_weekend" BIGINT,
  "subtleties_awareness" BIGINT,
  "overwhelemed_awareness" BIGINT,
  "rich_life" BIGINT,
  "rattled" BIGINT,
  "deeply_moved" BIGINT,
  "annoyed" BIGINT,
  "violent_movies" BIGINT,
  "unpleasant" BIGINT,
  "changes_shake" BIGINT,
  "delicates" BIGINT,
  "stimuli_awareness" BIGINT,
  "nervous" BIGINT,
  "life_ideal" BIGINT,
  "life_conditions" BIGINT,
  "life_satisfaction" BIGINT,
  "important_things" BIGINT,
  "life_changes" BIGINT,
  "extraverted" BIGINT,
  "critical" BIGINT,
  "dependable" BIGINT,
  "anxious" BIGINT,
  "new_exp" BIGINT,
  "reserved" BIGINT,
  "sympathetic" BIGINT,
  "disorganized" BIGINT,
  "calm" BIGINT,
  "conventional" BIGINT
);