DOI: 10.5281/zenodo.3463136
title: Hierarchical Demand Forecasting Benchmark for the Distribution Grid

description: This dataset contains power measurements and meteorological forecasts relative to a set of 24 power meters located in Rolle (Switzerland). These datasets are published to provide a standard benchmark for evaluating forecasting algorithms for demand side management applications. In <em>L.Nespoli, V. Medici, K. Lopatichki, F. Sossan, Hierarchical Demand Forecasting Benchmark forthe Distribution Grid, arXiv, 2019</em>, this dataset is used to test several regressors in predicting the 24 hours ahead electrical load. This dataset consists of measurements coming from 62 IEC 61000-4-30 Class A power quality meters manufactured by DEPsys (Switzerland) installed in secondary substations and LV cabinets of the distribution grid of the city of Rolle (Switzerland). The dataset has been enriched with numerical weather predictions from commercial provider Meteoblue (Switzerland), updated every 12 hours. The power measurements are provided as a pickle dataset, which includes: For each phase: mean active and reactive power voltage magnitude maximum total harmonic distortion (THD) voltage frequency \(\omega\) the average power over the three phases. The latter one has been used as target variable in the aforementioned paper. The meteorological forecasts are provided as a Hierarchical Data Format 5 file, which includes: temperature global horizontal and normal irradiance (GHI and GNI, respectively) relative humidity (RH) pressure wind speed and direction. <strong>How to read the files with Python</strong> The following code allows to open the files in python <pre><code class="language-python">import pandas as pd nwp_data = pd.read_hdf("nwp_data.h5","df") power_data = pd.read_pickle("power_data.p") </code></pre> The nwp_data is a pandas DataFrame of arrays. Each column, whose name is self explanatory, represent a set of 24 hours forecasted meteorological variable. These represents the most recent forecasts available from the NWP service at the respective time index of the dataset. The power_data is a dict of pandas DataFrame. The each value of the dict, whose key is self explanatory, contains a DataFrame whose columns are the name of the meter they refers to. The DataFrame 'P_mean' additionally contains 6 fictitious aggregations of the phase-mean power of the meters, 'S1', 'S2', 'S11', 'S12', 'S21', 'S22', and 'all', which represents the sum of all the meters. The hierarchical structure of the aggregations is the following one: <pre><code> all __|__ | | S1 S2 _|_ _|_ | | | | S11 S12 S21 S22</code></pre> S11 contains the first quarter of the time series presented in the dataset, while S12,S21,S22 contain the second, third and fourth quarter of the time series, respectively. Additionally to this, the reference paper also considered the following vacation days: <br> 01.01.2018<br> 02.01.2018<br> 30.03.2018<br> 02.04.2018<br> 10.05.2018<br> 21.05.2018<br> 01.08.2018<br> 17.09.2018<br> 25.12.2018<br> 01.01.2019<br> 02.01.2019<br> <br> The reduced_dataset.pk contains a reduced version of the dataset, with just the mean active power and the GHI and T variables for the NWP forecasts. This project is carried out within the frame of the Swiss Centre for Competence in Energy Research on the Future Swiss Electrical Infrastructure (SCCER-FURIES) with the financial support of the Swiss Innovation Agency (Innosuisse - SCCER program) and of the Swiss Federal Office of Energy with the project SI/501523.
description: {"references": ["L.Nespoli, V. Medici, K. Lopatichki, F. Sossan, Hierarchical Demand Forecasting Benchmark forthe Distribution Grid, arXiv, 2019"]}