Energy Forecast Pro

his dataset offers a dynamic playground for experimentation and discovery.

@kaggle.willianoliveiragibin_energy_forecast_pro

Table List

1 table(122.63 KB)

Energy Consumption New

@kaggle.willianoliveiragibin_energy_forecast_pro.energy_consumption_new

122.63 KB
1000 rows
12 columns

timestamp Timestamp	temperature Temperature	percentage Percentage	humidity Humidity	squarefootage SquareFootage	occupancy Occupancy	hvacusage HVACUsage	lightingusage LightingUsage	renewableenergy RenewableEnergy	dayofweek DayOfWeek	holiday Holiday	energyconsumption EnergyConsumption
Sat Jan 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	251.394.334.377.269	1120263432851990000000%	4.343.158.120.480.280	15.656.939.992.511.100	5	On	Off	2.774.698.791.658.740	Monday	No	7.536.437.339.539.210
Sat Jan 01 2022 01:00:00 GMT+0000 (Coordinated Universal Time)	27.731.650.520.792.900	123577896599301000000000%	54.225.918.580.233.000	1.411.064.918.331.910	1	On	On	21.831.384.152.500.600	Saturday	No	8.340.185.495.035.130
Sat Jan 01 2022 02:00:00 GMT+0000 (Coordinated Universal Time)	28.704.276.857.248.100	127912237733576000000000%	58.907.657.743.033.100	175.571.500.922.237	2	Off	Off	676.467.168.191.291	Sunday	No	7.827.088.774.061.060
Sat Jan 01 2022 03:00:00 GMT+0000 (Coordinated Universal Time)	20.080.469.485.298.100	89482839126254000000000%	503.716.371.457.499	1.452.316.318.334.370	1	Off	On	8.623.446.893.471.090	Wednesday	No	5.651.985.048.548.000
Sat Jan 01 2022 04:00:00 GMT+0000 (Coordinated Universal Time)	2.309.735.925.505.200	10292683726835000000000%	5.140.142.134.361.270	10.941.303.586.981.100	9	On	Off	30.719.692.157.166.300	Friday	No	7.081.173.246.793.310
Sat Jan 01 2022 05:00:00 GMT+0000 (Coordinated Universal Time)	29.576.037.393.658.900	131797354001069000000000%	3.682.426.323.380.880	18.717.091.797.360.900	6	Off	Off	1.762.668.982.389.790	Sunday	Yes	8.432.188.519.433.710
Sat Jan 01 2022 06:00:00 GMT+0000 (Coordinated Universal Time)	2.513.116.712.267.880	11199013521125900000000%	3.570.962.155.267.950	16.070.012.284.749.600	6	On	Off	2.426.470.232.698.350	Friday	Yes	7.616.579.090.213.890
Sat Jan 01 2022 07:00:00 GMT+0000 (Coordinated Universal Time)	23.182.844.248.720.900	103308066707441000000000%	3.167.991.978.011.050	16.339.553.295.431.100	8	Off	Off	27.517.099.250.037.300	Thursday	Yes	741.319.061.773.031
Sat Jan 01 2022 08:00:00 GMT+0000 (Coordinated Universal Time)	25.391.999.374.256.400	113152674011541000000000%	46.399.364.049.557.400	1.240.309.223.721.730	6	On	Off	23.075.954.692.088.500	Sunday	No	7.820.623.587.095.880
Sat Jan 01 2022 09:00:00 GMT+0000 (Coordinated Universal Time)	22.212.549.424.277.500	98984395715068800000000%	3.241.846.388.370.170	17.054.203.356.236.900	1	On	Off	29.140.070.981.014.400	Tuesday	No	7.799.221.370.196.020


CREATE TABLE energy_consumption_new (
  "timestamp" TIMESTAMP,
  "temperature" VARCHAR,
  "percentage" VARCHAR,
  "humidity" VARCHAR,
  "squarefootage" VARCHAR,
  "occupancy" BIGINT,
  "hvacusage" VARCHAR,
  "lightingusage" VARCHAR,
  "renewableenergy" VARCHAR,
  "dayofweek" VARCHAR,
  "holiday" VARCHAR,
  "energyconsumption" VARCHAR
);