ENTSO-E Hydropower modelling data (PECD) in CSV format

PECD Hydro modelling This repository contains a more user-friendly version of the <code>Hydro modelling data</code> released by ENTSO-E with their latest Seasonal Outlook. The original URLs: The zipped file: https://eepublicdownloads.blob.core.windows.net/public-cdn-container/clean-documents/sdc-documents/seasonal/SOR2020/data/Hydro.zip The documentation file (v 1.0): https://eepublicdownloads.blob.core.windows.net/public-cdn-container/clean-documents/sdc-documents/MAF/2019/Hydropower_Modelling_New_database_and_methodology.pdf The original ENTSO-E hydropower dataset integrates the PECD (Pan-European Climate Database) released for the MAF 2019 As I did for the wind &amp; solar data, the datasets released in this repository are <strong>only</strong> a more user- and machine-readable version of the original Excel files. As avid user of ENTSO-E data, with this repository I want to share my data wrangling efforts to make this dataset more accessible. <strong>Data description</strong> The zipped file contains 86 Excel files, two different files for each ENTSO-E zone. In this repository you can find 6 CSV files: <code>PECD-hydro-capacities.csv</code>: installed capacities <code>PECD-hydro-weekly-inflows.csv</code>: weekly inflows for reservoir and open-loop pumping <code>PECD-hydro-daily-ror-generation.csv</code>: daily run-of-river generation <code>PECD-hydro-weekly-reservoir-min-max-generation.csv</code>: minimum and maximum weekly reservoir generation <code>PECD-hydro-weekly-reservoir-levels.csv</code>: weekly reservoir levels <code>PECD-hydro-weekly-reservoir-min-max-uniform-levels.csv</code>: weekly minimum and maximum reservoir levels to use outside the climate years <strong>Capacities</strong> The file <code>PECD-hydro-capacities.csv</code> contains: run of river capacity (MW) and storage capacity (GWh), reservoir plants capacity (MW) and storage capacity (GWh), closed-loop pumping/turbining (MW) and storage capacity and open-loop pumping/turbining (MW) and storage capacity. The data is extracted from the Excel files with the name starting with <code>PEMM</code> from the following sections: sheet <code>Run-of-River and pondage</code>, rows from 5 to 7, columns from 2 to 5 sheet <code>Reservoir</code>, rows from 5 to 7, columns from 1 to 3 sheet <code>Pump storage - Open Loop</code>, rows from 5 to 7, columns from 1 to 3 sheet <code>Pump storage - Closed Loop</code>, rows from 5 to 7, columns from 1 to 3 <strong>Inflows</strong> The file <code>PECD-hydro-weekly-inflows.csv</code> contains the weekly inflow (GWh) for the climatic years 1982-2017 for reservoir plants and open-loop pumping. The data is extracted from the Excel files with the name starting with <code>PEMM</code> from the following sections: sheet <code>Reservoir</code>, rows from 13 to 66, columns from 16 to 51 sheet <code>Pump storage - Open Loop</code>, rows from 13 to 66, columns from 16 to 51 <strong>Daily run-of-river</strong> The file <code>PECD-hydro-daily-ror-generation.csv</code> contains the daily run-of-river generation (GWh). The data is extracted from the Excel files with the name starting with <code>PEMM</code> from the following sections: sheet <code>Run-of-River and pondage</code>, rows from 13 to 378, columns from 15 to 51 <strong>Miminum and maximum reservoir generation</strong> The file <code>PECD-hydro-weekly-reservoir-min-max-generation.csv</code> contains the minimum and maximum generation (MW, weekly) for reservoir-based plants for the climatic years 1982-2017. The data is extracted from the Excel files with the name starting with <code>PEMM</code> from the following sections: sheet <code>Reservoir</code>, rows from 13 to 66, columns from 196 to 231 sheet <code>Reservoir</code>, rows from 13 to 66, columns from 232 to 267 <strong>Reservoir levels</strong> The file <code>PECD-hydro-weekly-reservoir-levels.csv</code> contains the minimum, maximum and the exact reservoir levels at beginning of each week (scaled coefficient from 0 to 1) for each climate year. The data is extracted from the Excel files with the name starting with <code>PEMM</code> from the following sections: sheet <code>Reservoir</code>, rows from 13 to 66, column 340 to 375 sheet <code>Reservoir</code>, rows from 13 to 66, column 376 to 411 sheet <code>Reservoir</code>, rows from 13 to 66, column 412 to 447 <strong>Reservoir levels</strong> The file <code>PECD-hydro-weekly-reservoir-min-max-uniform-levels.csv</code> contains the minimum, maximum and the exact reservoir levels at beginning of each week (scaled coefficient from 0 to 1). The number are supposed to be used when climate years cannot be used (e.g. outside the range 1982-2017). The data is extracted from the Excel files with the name starting with <code>PEMM</code> from the following sections: sheet <code>Reservoir</code>, rows from 14 to 66, column 12 sheet <code>Reservoir</code>, rows from 14 to 66, column 13 <strong>CHANGELOG</strong> [2020/08/14] Added missing inflows for some countries (including Norway)<br> [2020/07/20] The old reservoir levels have been renamed 'uniform' consisting with the PECD source data. Added min, max and exact levels<br> [2020/07/17] Added maximum generation for the reservoir