Electricity Load Forecasting

Short-term electricity load forecasting (Panama case study)

@kaggle.saurabhshahane_electricity_load_forecasting

Table List

2 tables(5.32 MB)

Continuous Dataset

@kaggle.saurabhshahane_electricity_load_forecasting.continuous_dataset

4.88 MB
48048 rows
17 columns

datetime Datetime	nat_demand Nat Demand	t2m_toc T2M Toc	qv2m_toc QV2M Toc	tql_toc TQL Toc	w2m_toc W2M Toc	t2m_san T2M San	qv2m_san QV2M San	tql_san TQL San	w2m_san W2M San	t2m_dav T2M Dav	qv2m_dav QV2M Dav	tql_dav TQL Dav	w2m_dav W2M Dav
Sat Jan 03 2015 01:00:00 GMT+0000 (Coordinated Universal Time)	970.345	25.865258789062523	0.018576382	0.016174316	21.85054581787518	23.482446289062523	0.017271755	0.0018553734	10.328948729384228	22.662133789062523	0.016562222	0.09609985	5.364147952093894
Sat Jan 03 2015 02:00:00 GMT+0000 (Coordinated Universal Time)	912.1755	25.899255371093773	0.018653292	0.016418457	22.16694427698824	23.399255371093773	0.017264742	0.0013270378	10.68151713707418	22.578942871093773	0.016509432	0.087646484	5.57247134626166
Sat Jan 03 2015 03:00:00 GMT+0000 (Coordinated Universal Time)	900.2688	25.937280273437523	0.01876786	0.0154800415	22.454910876263515	23.343530273437523	0.017211463	0.0014281273	10.874923789974078	22.531030273437523	0.016479041	0.07873535	5.871183745099925
Sat Jan 03 2015 04:00:00 GMT+0000 (Coordinated Universal Time)	889.9538	25.957543945312523	0.018890057	0.016273499	22.11048086898637	23.238793945312523	0.017127667	0.0025987625	10.518620160775365	22.512231445312523	0.016486797	0.06838989	5.883621114044925
Sat Jan 03 2015 05:00:00 GMT+0000 (Coordinated Universal Time)	893.6865	25.973840332031276	0.018981151	0.017280579	21.18608851769688	23.075402832031276	0.017058544	0.0017290115	9.73358891774275	22.481652832031276	0.016455822	0.06436157	5.6117235593949095
Sat Jan 03 2015 06:00:00 GMT+0000 (Coordinated Universal Time)	879.2323	26.034143066406276	0.019079996	0.014541626	20.06203781593797	22.995080566406276	0.01702769	0.0014853477	9.087273159632828	22.456018066406276	0.016409708	0.061538696	5.280351132074735
Sat Jan 03 2015 07:00:00 GMT+0000 (Coordinated Universal Time)	932.4876	26.691491699218773	0.019331587	0.0066452026	21.62349567450987	24.285241699218773	0.017424239	0.0021762848	11.395393424647096	22.949304199218773	0.016569747	0.060897827	5.126910803396752
Sat Jan 03 2015 08:00:00 GMT+0000 (Coordinated Universal Time)	1048.972	27.6740661621094	0.019369703	0.0068626404	23.775316995619374	26.1896911621094	0.018072706	0.0045394897	12.872865998530138	24.0881286621094	0.016676527	0.05619812	5.060610609341514
Sat Jan 03 2015 09:00:00 GMT+0000 (Coordinated Universal Time)	1167.9074	28.760400390625023	0.019171301	0.010231018	24.636151504191965	27.916650390625023	0.018454138	0.0042915344	14.548026668797892	25.479150390625023	0.016645972	0.051071167	4.915658462517222
Sat Jan 03 2015 10:00:00 GMT+0000 (Coordinated Universal Time)	1257.5069	29.766656494140648	0.018759238	0.009017944	25.86267135806722	29.172906494140648	0.018675314	0.0049209595	15.081687878521311	26.704156494140648	0.016607748	0.058685303	4.685579709203943


CREATE TABLE continuous_dataset (
  "datetime" TIMESTAMP,
  "nat_demand" DOUBLE,
  "t2m_toc" DOUBLE,
  "qv2m_toc" DOUBLE,
  "tql_toc" DOUBLE,
  "w2m_toc" DOUBLE,
  "t2m_san" DOUBLE,
  "qv2m_san" DOUBLE,
  "tql_san" DOUBLE,
  "w2m_san" DOUBLE,
  "t2m_dav" DOUBLE,
  "qv2m_dav" DOUBLE,
  "tql_dav" DOUBLE,
  "w2m_dav" DOUBLE,
  "holiday_id" BIGINT,
  "holiday" BIGINT,
  "school" BIGINT
);