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

<p>PECD Hydro modelling</p> <p>This repository contains a more user-friendly version of the <code>Hydro modelling data</code> released by ENTSO-E with their <a href="https://www.entsoe.eu/outlooks/seasonal/">latest Seasonal Outlook</a>.</p> <p>The original URLs:</p> <ul> <li>The zipped file: <a href="https://eepublicdownloads.blob.core.windows.net/public-cdn-container/clean-documents/sdc-documents/seasonal/SOR2020/data/Hydro.zip">https://eepublicdownloads.blob.core.windows.net/public-cdn-container/clean-documents/sdc-documents/seasonal/SOR2020/data/Hydro.zip</a></li> <li>The documentation file (v 1.0): <a href="https://eepublicdownloads.blob.core.windows.net/public-cdn-container/clean-documents/sdc-documents/MAF/2019/Hydropower_Modelling_New_database_and_methodology.pdf">https://eepublicdownloads.blob.core.windows.net/public-cdn-container/clean-documents/sdc-documents/MAF/2019/Hydropower_Modelling_New_database_and_methodology.pdf</a></li> </ul> <p>The original ENTSO-E hydropower dataset integrates the PECD (Pan-European Climate Database) released for the <a href="https://www.entsoe.eu/outlooks/midterm/#download">MAF 2019</a></p> <p>As I did for the <a href="https://zenodo.org/record/3702418">wind &amp; solar data</a>, 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.</p> <p><strong>Data description</strong></p> <p>The <a href="https://eepublicdownloads.blob.core.windows.net/public-cdn-container/clean-documents/sdc-documents/seasonal/SOR2020/data/Hydro.zip">zipped file</a> contains 86 Excel files, two different files for each ENTSO-E zone.</p> <p>In this repository you can find 6 CSV files:</p> <ul> <li><code>PECD-hydro-capacities.csv</code>: installed capacities</li> <li><code>PECD-hydro-weekly-inflows.csv</code>: weekly inflows for reservoir and open-loop pumping</li> <li><code>PECD-hydro-daily-ror-generation.csv</code>: daily run-of-river generation</li> <li><code>PECD-hydro-weekly-reservoir-min-max-generation.csv</code>: minimum and maximum weekly reservoir generation</li> <li><code>PECD-hydro-weekly-reservoir-levels.csv</code>: weekly reservoir levels</li> <li><code>PECD-hydro-weekly-reservoir-min-max-uniform-levels.csv</code>: weekly minimum and maximum reservoir levels to use outside the climate years</li> </ul> <p><strong>Capacities</strong></p> <p>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:</p> <ul> <li>sheet <code>Run-of-River and pondage</code>, rows from 5 to 7, columns from 2 to 5</li> <li>sheet <code>Reservoir</code>, rows from 5 to 7, columns from 1 to 3</li> <li>sheet <code>Pump storage - Open Loop</code>, rows from 5 to 7, columns from 1 to 3</li> <li>sheet <code>Pump storage - Closed Loop</code>, rows from 5 to 7, columns from 1 to 3</li> </ul> <p><strong>Inflows</strong></p> <p>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:</p> <ul> <li>sheet <code>Reservoir</code>, rows from 13 to 66, columns from 16 to 51</li> <li>sheet <code>Pump storage - Open Loop</code>, rows from 13 to 66, columns from 16 to 51</li> </ul> <p><strong>Daily run-of-river</strong></p> <p>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:</p> <ul> <li>sheet <code>Run-of-River and pondage</code>, rows from 13 to 378, columns from 15 to 51</li> </ul> <p><strong>Miminum and maximum reservoir generation</strong></p> <p>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:</p> <ul> <li>sheet <code>Reservoir</code>, rows from 13 to 66, columns from 196 to 231</li> <li>sheet <code>Reservoir</code>, rows from 13 to 66, columns from 232 to 267</li> </ul> <p><strong>Reservoir levels</strong></p> <p>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:</p> <ul> <li>sheet <code>Reservoir</code>, rows from 13 to 66, column 340 to 375</li> <li>sheet <code>Reservoir</code>, rows from 13 to 66, column 376 to 411</li> <li>sheet <code>Reservoir</code>, rows from 13 to 66, column 412 to 447</li> </ul> <p><strong>Reservoir levels</strong></p> <p>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:</p> <ul> <li>sheet <code>Reservoir</code>, rows from 14 to 66, column 12</li> <li>sheet <code>Reservoir</code>, rows from 14 to 66, column 13</li> </ul> <p><strong>CHANGELOG</strong></p> <p>[2020/08/14] Added missing inflows for some countries (including Norway)<br> [2020/07/20] The old reservoir levels have been renamed &#39;uniform&#39; consisting with the PECD source data. Added min, max and exact levels<br> [2020/07/17] Added maximum generation for the reservoir</p>