Room Occupancy Estimation Data Set

Data set for estimating the precise number of occupants in a room

@kaggle.ananthr1_room_occupancy_estimation_data_set

Table List

1 table(153.28 KB)

Occupancy Estimation

@kaggle.ananthr1_room_occupancy_estimation_data_set.occupancy_estimation

153.28 KB
10129 rows
19 columns

date Date	time Time	s1_temp S1 Temp	s2_temp S2 Temp	s3_temp S3 Temp	s4_temp S4 Temp	s1_light S1 Light	s2_light S2 Light	s3_light S3 Light	s4_light S4 Light	s1_sound S1 Sound	s2_sound S2 Sound	s3_sound S3 Sound	s4_sound S4 Sound	s5_co2 S5 CO2	s5_co2_slope S5 CO2 Slope	s6_pir S6 PIR	s7_pir S7 PIR	room_occupancy_count Room Occupancy Count
2017/12/22	10:49:41	24.94	24.75	24.56	25.38	121	34	53	40	0.08	0.19	0.06	0.06	390	0.769230769231			1
2017/12/22	10:50:12	24.94	24.75	24.56	25.44	121	33	53	40	0.93	0.05	0.06	0.06	390	0.646153846154			1
2017/12/22	10:50:42	25	24.75	24.5	25.44	121	34	53	40	0.43	0.11	0.08	0.06	390	0.519230769231			1
2017/12/22	10:51:13	25	24.75	24.56	25.44	121	34	53	40	0.41	0.1	0.1	0.09	390	0.388461538462			1
2017/12/22	10:51:44	25	24.75	24.56	25.44	121	34	54	40	0.18	0.06	0.06	0.06	390	0.253846153846			1
2017/12/22	10:52:14	25	24.81	24.56	25.44	121	34	54	40	0.13	0.06	0.06	0.07	390	0.165384615385			1
2017/12/22	10:52:45	25	24.75	24.56	25.44	120	34	54	40	1.39	0.32	0.43	0.06	390	0.0769230769231	1		1
2017/12/22	10:53:15	25	24.81	24.56	25.44	121	34	54	41	0.09	0.06	0.09	0.05	390	-0.0115384615385			1
2017/12/22	10:53:46	25	24.81	24.56	25.5	122	35	56	43	0.09	0.05	0.06	0.13	390	-0.1			1
2017/12/22	10:54:17	25	24.81	24.56	25.5	101	34	57	43	3.84	0.64	0.48	0.39	390	-0.188461538462	1	1	1


CREATE TABLE occupancy_estimation (
  "date" VARCHAR,
  "time" VARCHAR,
  "s1_temp" DOUBLE,
  "s2_temp" DOUBLE,
  "s3_temp" DOUBLE,
  "s4_temp" DOUBLE,
  "s1_light" BIGINT,
  "s2_light" BIGINT,
  "s3_light" BIGINT,
  "s4_light" BIGINT,
  "s1_sound" DOUBLE,
  "s2_sound" DOUBLE,
  "s3_sound" DOUBLE,
  "s4_sound" DOUBLE,
  "s5_co2" BIGINT,
  "s5_co2_slope" DOUBLE,
  "s6_pir" BIGINT,
  "s7_pir" BIGINT,
  "room_occupancy_count" BIGINT
);