This notebook is part of the project Open Power System Data. Open Power System Data develops a platform for free and open data for electricity system modeling. We collect, check, process, document, and provide data that are publicly available but currently inconvenient to use. More info on Open Power System Data:
This file is a Jupyter Notebook. A Jupyter Notebook is a file that combines executable programming code with visualizations and comments in markdown format, allowing for an intuitive documentation of the code. We use Jupyter Notebooks for combined coding and documentation. We use Python 3 as programming language. All Notebooks are stored on GitHub, a platform for software development, and are publicly available. More information on our IT-concept can be found here. See also our step-by-step manual how to use the dataplatform.
In which resolution the data is published depends on the "market time unit" applied in the respective jurisdiction as well as the type of data. For most data types, the following mapping applies:
For data that are originally available in 15 or 30 minutes resolution, hourly averages are included with the 60 minutes dataset. The original resolition data are is provided in a separate file. The timeseries become available at different points in time depending on the sources. The full dataset is only available from 2015 onwards.
The two sources differ Values on PS (~500 TWh annaually in Germany) are usually slightly higher than on the TP (~490 TWh). The reason probably lies with different reporting deadlines: Values on the TP have to be reported "no later than one hour after the end of the operating period". For the PS, the data is published with a delay of up to 3 months, which might allow for more accurate metering. For a comparison of the two sources see Hirth, et al. (2018).
For some countries, the PS report a "represenativity factor" (91% in Germany until 2014, 97% since then), indicating that the reported values would have to be upscaled by this value resulting in ~520 TWh annually in Germany.
Schuhmacher & Hirth (2015) compare the German hourly load total load values to monthly and yearly aggregate consumption statistics for Germany, showing considerable differences, part of which may be explained by the fact that none of th ENTSO-E data cover industrial auto generation which is not transported over the transmission grid.
The main data sources are the various European Transmission System Operators (TSOs), the ENTSO-E Power Statistics and the ENTSO-E Transparency Platform. A complete list of data sources is provided on the datapackage information website. They are also contained in the JSON file that contains all metadata.
The table headers specifies each data column according to 3 categories: region, variable and attribute. region specifies the geographical scope according to the ISO 3166 codes. variable distinguishes consumption,generation and prices. attribute gives further properties of the data that are specific to the respective variable. See the table below for the set of possible combinations.
import pandas as pd; pd.read_csv('input/notation.csv', index_col=list(range(4)))
|ISO 3166 area code and name or control area or bidding zone||load||actual_entsoe_power_statistics||Total load as published on ENTSO-E Data Portal|
|actual_entsoe_transparency||Total load as published on ENTSO-E Data Portal/Power Statistics|
|actual_tso||Total load as published by the TSO|
|actual_net_consumption_tso||Total load exluding transmission losses as published onby the TSO|
|actual_gross_generation_tso||Total power generation from national TSO|
|day_ahead_forecast_entsoe_transparency||Day ahead total load forecast from ENTSO-E Transparency Platform|
|solar / wind / wind_onshore / wind_offshore||generation_actual||Electricity produced by all power plants|
|day_ahead_generation_forecast||Day-ahead generation forecast|
|generation_actual_dso||Electricity produced by power plants connected to distribution grid|
|generation_actual_tso||Electricity produced by power plants connected to transmission grid|
|capacity||Aggregated installed capacity of power plants (actual availability not accounted for)|
|profile||Share of installed capacity producing|
|price||day_ahead||Day-ahead spot price|