{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "\n", " \n", " \n", " \n", "
\n", " Renewable power plants: Main Notebook\n", " \n", "
This Notebook is part of the Renewable power plants Data Package of Open Power System Data.\n", "
" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# 1. About Open Power System Data \n", "This Notebook is part of the project [Open Power System Data](http://open-power-system-data.org). 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. \n", "More info on Open Power System Data:\n", "- [Information on the project on our website](http://open-power-system-data.org)\n", "- [Data and metadata on our data platform](http://data.open-power-system-data.org)\n", "- [Data processing scripts on our GitHub page](https://github.com/Open-Power-System-Data)\n", "\n", "# 2. About Jupyter Notebooks and GitHub\n", "This file is a [Jupyter Notebook](http://jupyter.org/). 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](https://github.com/), a platform for software development, and are publicly available. More information on our IT-concept can be found [here](http://open-power-system-data.org/it). See also our [step-by-step manual](http://open-power-system-data.org/step-by-step) how to use the dataplatform.\n", " \n", "# 3. About this Data Package\n", "We provide data in different chunks, or [Data Packages](http://frictionlessdata.io/data-packages/). The one you are looking at right now, [Renewable power plants](http://data.open-power-system-data.org/renewable_power_plants/), contains\n", "\n", "* lists of renewable energy power plants of Germany, Denmark, France and Poland\n", "* daily time series of cumulated installed capacity per energy source type for Germany.\n", "\n", "Due to differing data availability, the power plant lists are of variable accurancy and partly provide different power plant parameters. Therefore the lists are provided as separate CSV files per country and as separate sheets in the Excel file.\n", "\n", "* Germany: More than 1.7 million power plant entries, all renewable energy plants supported by the German Renewable Energy Law (EEG)\n", "* Denmark: Wind and phovoltaic power plants with a high level of detail\n", "* France: Summed capacity and number of installations per energy source per municipality (Commune)\n", "* Poland: Summed capacity and number of installations per energy source per municipality (Powiat)\n", " \n", "# 4. Data sources\n", "\n", "This Data Package uses the following main data sources.\n", "## 4.1 Germany - DE\n", "- [Netztransparenz.de](https://www.netztransparenz.de/de/Anlagenstammdaten.htm) - Information platform from the German TSOs\n", "\n", ">In Germany historically all data has been published mandatorily by the four TSOs (50Hertz, Amprion, Tennet, TransnetBW). This obligation expired in August 2014, nonetheless the TSO reported until the end of 2014 and issued another update in August 2016 for plants commissioned until end of 2015 (which is used in this script).\n", "\n", "- [BNetzA](http://www.bundesnetzagentur.de/) - The German Federal Network Agency for Electricity, Gas, Telecommunications, Posts and Railway\n", "\n", ">Since August 2014 the BNetzA is responsible to publish the renewable power plants register. The legal framework for the register is specified in the EEG 2014 [(German)](http://www.gesetze-im-internet.de/eeg_2014/) [(English)](http://www.res-legal.eu/search-by-country/germany/single/s/res-e/t/promotion/aid/feed-in-tariff-eeg-feed-in-tariff/lastp/135/). All power plants are listed in a new format: two separate MS-Excel and CSV files for roof-mounted PV power plants [\"PV-Datenmeldungen\"](http://www.bundesnetzagentur.de/cln_1422/DE/Sachgebiete/ElektrizitaetundGas/Unternehmen_Institutionen/ErneuerbareEnergien/Photovoltaik/DatenMeldgn_EEG-VergSaetze/DatenMeldgn_EEG-VergSaetze_node.html) and all other renewable power plants [\" Anlagenregister\"](http://www.bundesnetzagentur.de/cln_1412/DE/Sachgebiete/ElektrizitaetundGas/Unternehmen_Institutionen/ErneuerbareEnergien/Anlagenregister/Anlagenregister_Veroeffentlichung/Anlagenregister_Veroeffentlichungen_node.html).\n", "\n", "## 4.2 Denmark - DK\n", "\n", "- [ens.dk](http://www.ens.dk/) - Energy Agency Denmark \n", " \n", ">The Danish Energy Agency publishes a national master data register for wind turbines which was created in collaboration with the transmission system operators. The publication is monthly as an Excel file. The data set includes all electricity-generating wind turbines with information about technical data, location data and production data.\n", "\n", "\n", "- [Energinet.dk](http://www.energinet.dk/EN/Sider/default.aspx) - Transmission system Operator in Denmark\n", "\n", ">The photovoltaic statistic, published from Energinet, includes information about location, year of implementing, installed capacity and number of systems. There is an additional overview of the number of plants and installed capacity per postcode. The publication an Excel file and dates of publication are not entirely clear.\n", "\n", "## 4.3 France - FR\n", "- [Ministery of the Environment,Energy and the Sea France](http://www.developpement-durable.gouv.fr/)\n", "\n", "> The data is annual published on the france [website for statistics](http://www.statistiques.developpement-durable.gouv.fr/energie-climat/r/energies-renouvelables.html?tx_ttnews[tt_news]=20647) as an Excel file. The Excel chart includes number and installed capacity of the different renewable source for every municipality in France. It is limited to the plants which are covered by article 10 of february 2000 by an agreement to a purchase commitment.\n", "\n", "## 4.4 Poland - PL\n", "- [Urzad Regulacji Energetyki (URE)](http://www.ure.gov.pl/uremapoze/mapa.html) - Energy Regulatory Office of Poland\n", "\n", "> Number of installations and installed capacity per energy source of renewable energy, summed per powiat (districts) is illustrated on the page and can be downloaded as rtf-file\n", "\n", "A complete list of data sources is provided on the [Data Package information website](http://data.open-power-system-data.org/renewable_power_plants/). They are also contained in the JSON file that contains all metadata.\n", " \n", "# 5. Naming Conventions\n", "## 5.1 Column translation list\n", "This list provides all internal translations of column original names to the OPSD standard names in order to achieve common data structure for data of all implemented countries as well as the other data packages. " ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
original_nameopsd_namedescriptioncountrydata_source
0ÜNBtsoName of transmission system operatorDE50Hertz / Amprion / TenneT / TransnetBW
1REGELZONEtsoName of transmission system operatorDE50Hertz / Amprion / TenneT / TransnetBW
2RegelzonenbezeichnungtsoName of transmission system operatorDE50Hertz / Amprion / TenneT / TransnetBW
3Netzbetreiber NamedsoName of distribution system operatorDE50Hertz / Amprion / TenneT / TransnetBW
4NETZBETREIBER_NAMEdsoName of distribution system operatorDE50Hertz / Amprion / TenneT / TransnetBW
5Netzbetreiber Betriebsnummerdso_idCompany number of dsoDE50Hertz / Amprion / TenneT / TransnetBW
6NETZBETREIBER_BETRIEBSNUMMERdso_idCompany number of dsoDE50Hertz / Amprion / TenneT / TransnetBW
7ÜNB-Anlagenschlüsseleeg_idGerman EEG renumeration ID numberDE50Hertz / Amprion / TenneT / TransnetBW
8ANLAGENSCHLUESSELeeg_idGerman EEG renumeration ID numberDE50Hertz / Amprion / TenneT / TransnetBW
9ÜNB-Anlagennummereeg_idGerman EEG renumeration ID numberDE50Hertz / Amprion / TenneT / TransnetBW
10Bundeslandfederal_stateFederal state – administrative region NUTS1-levelDE50Hertz / Amprion / TenneT / TransnetBW
11Bundelsandfederal_stateFederal state – administrative region NUTS1-levelDE50Hertz / Amprion / TenneT / TransnetBW
12BUNDESLANDfederal_stateFederal state – administrative region NUTS1-levelDE50Hertz / Amprion / TenneT / TransnetBW
13PLZpostcodePostcode or ZIP-codeDE50Hertz / Amprion / TenneT / TransnetBW
14Installierte Leistung [kW]electrical_capacity_kWInstalled electrical capacity in kWDE50Hertz / Amprion / TenneT / TransnetBW
15INST_LEISTUNG_KWelectrical_capacity_kWInstalled electrical capacity in kWDE50Hertz / Amprion / TenneT / TransnetBW
16installierte Leistungelectrical_capacity_kWInstalled electrical capacity in kWDE50Hertz / Amprion / TenneT / TransnetBW
17Einspeisespannungsebenevoltage_levelGrid connection/voltage levelDE50Hertz / Amprion / TenneT / TransnetBW
18EINSPEISESPANNUNGSEBENEvoltage_levelGrid connection/voltage levelDE50Hertz / Amprion / TenneT / TransnetBW
19Leistungsmessungpower_measurementIndicates whether power measurement is impleme...DE50Hertz / Amprion / TenneT / TransnetBW
20LEISTUNGSGEMESSENE_ANLAGEpower_measurementIndicates whether power measurement is impleme...DE50Hertz / Amprion / TenneT / TransnetBW
21Leistungsgemessene Anlage?power_measurementIndicates whether power measurement is impleme...DE50Hertz / Amprion / TenneT / TransnetBW
22RegelbarkeitcontrollabilityIndicates whether remote controllability is im...DE50Hertz / Amprion / TenneT / TransnetBW
23REGELBARKEITcontrollabilityIndicates whether remote controllability is im...DE50Hertz / Amprion / TenneT / TransnetBW
24Energieträgerenergy_source_level_2Type of energy source / generationDE50Hertz / Amprion / TenneT / TransnetBW
25Energietr�gerenergy_source_level_2Type of energy source / generationDE50Hertz / Amprion / TenneT / TransnetBW
26BEZEICHNUNGenergy_source_level_2Type of energy source / generationDE50Hertz / Amprion / TenneT / TransnetBW
27Inbetriebnahmecommissioning_dateNaNDE50Hertz / Amprion / TenneT / TransnetBW
28Zeitpunkt der Inbetriebnahmecommissioning_dateNaNDE50Hertz / Amprion / TenneT / TransnetBW
29ZEITPUNKT_INBETRIEBNAHMEcommissioning_dateNaNDE50Hertz / Amprion / TenneT / TransnetBW
..................
65Møllenummer (GSRN)gsrn_idTurbine identifier (GSRN)DKEnergistyrelsen
66Dato for oprindelig nettilslutningcommissioning_dateNaNDKEnergistyrelsen
67Kapacitet (kW)electrical_capacity_kWInstalled electrical capacity in kWDKEnergistyrelsen
68Rotor-diameter (m)rotor_diameterRotor diameter in mDKEnergistyrelsen
69Navhøjde (m)hub_heightHub heigth in mDKEnergistyrelsen
70FabrikatmanufacturerCompany that has built the turbineDKEnergistyrelsen
71ModelmodelWind turbine modelDKEnergistyrelsen
72Kommune-nr.municipality_codeDanish municipality codeDKEnergistyrelsen
73KommunemunicipalityName of city or village or municipalityDKEnergistyrelsen
74Type af placeringtechnologyType of location: on- or offshoreDKEnergistyrelsen
75EjerlavaddressStreet name or name of land parcelDKEnergistyrelsen
76Matrikel-nummeraddress_numberHouse number or number of land parcelDKEnergistyrelsen
77X (øst) koordinat \\nUTM 32 Euref89utm_eastCoordinate in Universal Transverse Mercator (e...DKEnergistyrelsen
78Y (nord) koordinat \\nUTM 32 Euref89utm_northCoordinate in Universal Transverse Mercator (n...DKEnergistyrelsen
79Værk Idriftcommissioning_dateNaNDKEnerginet.dk
80kWelectrical_capacity_kWInstalled electrical capacity in kWDKEnerginet.dk
81PostnrpostcodePostcode or ZIP-codeDKEnerginet.dk
82Netområde NavndsoName of distribution system operatorDKEnerginet.dk
83CommunesmunicipalityNaNFRgouv.fr
84Code officiel géographiquemunicipality_codeFrench municipality code (INSEE)FRgouv.fr
85insee_communicipality_codeFrench municipality code (INSEE)FRgouv.fr
86Nombre d'installationsnumber_of_installationsNumber of installed solar systemsFRgouv.fr
87Puissance installée (MW)electrical_capacityInstalled electrical capacity in MWFRgouv.fr
88technologyenergy_source_level_2NaNEuropeOPSD
89capacityelectrical_capacityNaNEuropeOPSD
90sourcedata_sourceNaNEuropeOPSD
91Country / AreacountryNaNEuropeIRENA
92Sub TechnologytechnologyNaNEuropeIRENA
93YearyearNaNEuropeIRENA
94Valueelectrical_capacityNaNEuropeIRENA
\n", "

95 rows × 5 columns

\n", "
" ], "text/plain": [ " original_name opsd_name \\\n", "0 ÜNB tso \n", "1 REGELZONE tso \n", "2 Regelzonenbezeichnung tso \n", "3 Netzbetreiber Name dso \n", "4 NETZBETREIBER_NAME dso \n", "5 Netzbetreiber Betriebsnummer dso_id \n", "6 NETZBETREIBER_BETRIEBSNUMMER dso_id \n", "7 ÜNB-Anlagenschlüssel eeg_id \n", "8 ANLAGENSCHLUESSEL eeg_id \n", "9 ÜNB-Anlagennummer eeg_id \n", "10 Bundesland federal_state \n", "11 Bundelsand federal_state \n", "12 BUNDESLAND federal_state \n", "13 PLZ postcode \n", "14 Installierte Leistung [kW] electrical_capacity_kW \n", "15 INST_LEISTUNG_KW electrical_capacity_kW \n", "16 installierte Leistung electrical_capacity_kW \n", "17 Einspeisespannungsebene voltage_level \n", "18 EINSPEISESPANNUNGSEBENE voltage_level \n", "19 Leistungsmessung power_measurement \n", "20 LEISTUNGSGEMESSENE_ANLAGE power_measurement \n", "21 Leistungsgemessene Anlage? power_measurement \n", "22 Regelbarkeit controllability \n", "23 REGELBARKEIT controllability \n", "24 Energieträger energy_source_level_2 \n", "25 Energietr�ger energy_source_level_2 \n", "26 BEZEICHNUNG energy_source_level_2 \n", "27 Inbetriebnahme commissioning_date \n", "28 Zeitpunkt der Inbetriebnahme commissioning_date \n", "29 ZEITPUNKT_INBETRIEBNAHME commissioning_date \n", ".. ... ... \n", "65 Møllenummer (GSRN) gsrn_id \n", "66 Dato for oprindelig nettilslutning commissioning_date \n", "67 Kapacitet (kW) electrical_capacity_kW \n", "68 Rotor-diameter (m) rotor_diameter \n", "69 Navhøjde (m) hub_height \n", "70 Fabrikat manufacturer \n", "71 Model model \n", "72 Kommune-nr. municipality_code \n", "73 Kommune municipality \n", "74 Type af placering technology \n", "75 Ejerlav address \n", "76 Matrikel-nummer address_number \n", "77 X (øst) koordinat \\nUTM 32 Euref89 utm_east \n", "78 Y (nord) koordinat \\nUTM 32 Euref89 utm_north \n", "79 Værk Idrift commissioning_date \n", "80 kW electrical_capacity_kW \n", "81 Postnr postcode \n", "82 Netområde Navn dso \n", "83 Communes municipality \n", "84 Code officiel géographique municipality_code \n", "85 insee_com municipality_code \n", "86 Nombre d'installations number_of_installations \n", "87 Puissance installée (MW) electrical_capacity \n", "88 technology energy_source_level_2 \n", "89 capacity electrical_capacity \n", "90 source data_source \n", "91 Country / Area country \n", "92 Sub Technology technology \n", "93 Year year \n", "94 Value electrical_capacity \n", "\n", " description country \\\n", "0 Name of transmission system operator DE \n", "1 Name of transmission system operator DE \n", "2 Name of transmission system operator DE \n", "3 Name of distribution system operator DE \n", "4 Name of distribution system operator DE \n", "5 Company number of dso DE \n", "6 Company number of dso DE \n", "7 German EEG renumeration ID number DE \n", "8 German EEG renumeration ID number DE \n", "9 German EEG renumeration ID number DE \n", "10 Federal state – administrative region NUTS1-level DE \n", "11 Federal state – administrative region NUTS1-level DE \n", "12 Federal state – administrative region NUTS1-level DE \n", "13 Postcode or ZIP-code DE \n", "14 Installed electrical capacity in kW DE \n", "15 Installed electrical capacity in kW DE \n", "16 Installed electrical capacity in kW DE \n", "17 Grid connection/voltage level DE \n", "18 Grid connection/voltage level DE \n", "19 Indicates whether power measurement is impleme... DE \n", "20 Indicates whether power measurement is impleme... DE \n", "21 Indicates whether power measurement is impleme... DE \n", "22 Indicates whether remote controllability is im... DE \n", "23 Indicates whether remote controllability is im... DE \n", "24 Type of energy source / generation DE \n", "25 Type of energy source / generation DE \n", "26 Type of energy source / generation DE \n", "27 NaN DE \n", "28 NaN DE \n", "29 NaN DE \n", ".. ... ... \n", "65 Turbine identifier (GSRN) DK \n", "66 NaN DK \n", "67 Installed electrical capacity in kW DK \n", "68 Rotor diameter in m DK \n", "69 Hub heigth in m DK \n", "70 Company that has built the turbine DK \n", "71 Wind turbine model DK \n", "72 Danish municipality code DK \n", "73 Name of city or village or municipality DK \n", "74 Type of location: on- or offshore DK \n", "75 Street name or name of land parcel DK \n", "76 House number or number of land parcel DK \n", "77 Coordinate in Universal Transverse Mercator (e... DK \n", "78 Coordinate in Universal Transverse Mercator (n... DK \n", "79 NaN DK \n", "80 Installed electrical capacity in kW DK \n", "81 Postcode or ZIP-code DK \n", "82 Name of distribution system operator DK \n", "83 NaN FR \n", "84 French municipality code (INSEE) FR \n", "85 French municipality code (INSEE) FR \n", "86 Number of installed solar systems FR \n", "87 Installed electrical capacity in MW FR \n", "88 NaN Europe \n", "89 NaN Europe \n", "90 NaN Europe \n", "91 NaN Europe \n", "92 NaN Europe \n", "93 NaN Europe \n", "94 NaN Europe \n", "\n", " data_source \n", "0 50Hertz / Amprion / TenneT / TransnetBW \n", "1 50Hertz / Amprion / TenneT / TransnetBW \n", "2 50Hertz / Amprion / TenneT / TransnetBW \n", "3 50Hertz / Amprion / TenneT / TransnetBW \n", "4 50Hertz / Amprion / TenneT / TransnetBW \n", "5 50Hertz / Amprion / TenneT / TransnetBW \n", "6 50Hertz / Amprion / TenneT / TransnetBW \n", "7 50Hertz / Amprion / TenneT / TransnetBW \n", "8 50Hertz / Amprion / TenneT / TransnetBW \n", "9 50Hertz / Amprion / TenneT / TransnetBW \n", "10 50Hertz / Amprion / TenneT / TransnetBW \n", "11 50Hertz / Amprion / TenneT / TransnetBW \n", "12 50Hertz / Amprion / TenneT / TransnetBW \n", "13 50Hertz / Amprion / TenneT / TransnetBW \n", "14 50Hertz / Amprion / TenneT / TransnetBW \n", "15 50Hertz / Amprion / TenneT / TransnetBW \n", "16 50Hertz / Amprion / TenneT / TransnetBW \n", "17 50Hertz / Amprion / TenneT / TransnetBW \n", "18 50Hertz / Amprion / TenneT / TransnetBW \n", "19 50Hertz / Amprion / TenneT / TransnetBW \n", "20 50Hertz / Amprion / TenneT / TransnetBW \n", "21 50Hertz / Amprion / TenneT / TransnetBW \n", "22 50Hertz / Amprion / TenneT / TransnetBW \n", "23 50Hertz / Amprion / TenneT / TransnetBW \n", "24 50Hertz / Amprion / TenneT / TransnetBW \n", "25 50Hertz / Amprion / TenneT / TransnetBW \n", "26 50Hertz / Amprion / TenneT / TransnetBW \n", "27 50Hertz / Amprion / TenneT / TransnetBW \n", "28 50Hertz / Amprion / TenneT / TransnetBW \n", "29 50Hertz / Amprion / TenneT / TransnetBW \n", ".. ... \n", "65 Energistyrelsen \n", "66 Energistyrelsen \n", "67 Energistyrelsen \n", "68 Energistyrelsen \n", "69 Energistyrelsen \n", "70 Energistyrelsen \n", "71 Energistyrelsen \n", "72 Energistyrelsen \n", "73 Energistyrelsen \n", "74 Energistyrelsen \n", "75 Energistyrelsen \n", "76 Energistyrelsen \n", "77 Energistyrelsen \n", "78 Energistyrelsen \n", "79 Energinet.dk \n", "80 Energinet.dk \n", "81 Energinet.dk \n", "82 Energinet.dk \n", "83 gouv.fr \n", "84 gouv.fr \n", "85 gouv.fr \n", "86 gouv.fr \n", "87 gouv.fr \n", "88 OPSD \n", "89 OPSD \n", "90 OPSD \n", "91 IRENA \n", "92 IRENA \n", "93 IRENA \n", "94 IRENA \n", "\n", "[95 rows x 5 columns]" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import pandas as pd\n", "pd.read_csv('input/column_translation_list.csv')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## 5.2 Value translation list\n", "\n", "This list provides all internal translations of original value names to the OPSD standard names in order to achieve common data structure for data of all implemented countries as well as the other data packages. " ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
original_nameopsd_nameenergy_source_level_2countrydata_source
0Wind LandOnshoreWindDEBNetzA
1Wind SeeOffshoreWindDEBNetzA
2KlärgasSewage and landfill gasBioenergyDEBNetzA / TransnetBW / TenneT / 50Hertz / Amprion
3GrubengasOther fossil fuelsOther fossil fuelsDEBnetzA/ Amprion
4Freifläche PVPhotovoltaics groundSolarDEBNetzA
5DeponiegasSewage and landfill gasBioenergyDEBNetzA / TransnetBW / TenneT / 50Hertz / Amprion
6BiomasseBiomass and biogasBioenergyDEBNetzA / TransnetBW / TenneT / 50Hertz / Amprion
7WasserkraftRun-of-riverHydroDEBNetzA / TransnetBW / TenneT / 50Hertz / Amprion
8GeothermieGeothermalGeothermalDEBnetzA / TenneT / 50Hertz / Amprion
9Windenergie OffshoreOffshoreWindDE50Hertz / TenneT
10SolarPhotovoltaicsSolarDETransnetBW / TenneT / 50Hertz / Amprion
11WindenergieOnshoreWindDETenneT / 50Hertz / Amprion
12Windenergie an LandOnshoreWindDETransnetBW
13HShigh voltageNaNDEBNetzA
14HS/MShigh voltage / medium voltageNaNDEBNetzA
15HöSextra high voltageNaNDEBNetzA
16HöS/HShigh voltage / extra high voltageNaNDEBNetzA
17MSmedium voltageNaNDEBNetzA
18MS/NSmedium voltage / low voltageNaNDEBNetzA
19NSlow voltageNaNDEBNetzA
20TransnetBW GmbHTransnetBWNaNDETransnetBW
21TenneT TSO GmbHTenneTNaNDETenneT
22Amprion GmbHAmprionNaNDEAmprion
23HAVOffshoreWindDKEnergistyrelsen
24LANDOnshoreWindDKEnergistyrelsen
25LandOnshoreWindDKEnergistyrelsen
26BiomasseBiomass and biogasBioenergyFRgouv.fr
27EolienWindWindFRgouv.fr
28GéothermieGeothermalGeothermalFRgouv.fr
29HydrauliqueHydroHydroFRgouv.fr
..................
42hydro-electric power-station capacity up to 10 MWHydroHydroPLUrzad Regulacji Energetyki
43hydro-electric power-station capacity up to 5 MWHydroHydroPLUrzad Regulacji Energetyki
44mixed biogas power-stationsBiomass and biogasBioenergyPLUrzad Regulacji Energetyki
45onshore wind power-stationOnshoreWindPLUrzad Regulacji Energetyki
46photovoltaic power-stationsPhotovoltaicsSolarPLUrzad Regulacji Energetyki
47sewage treatment plant biogas power-stationsSewage and landfill gasBioenergyPLUrzad Regulacji Energetyki
48pumped-storage power station or flow hydro-ele...HydroHydroPLUrzad Regulacji Energetyki
49BiogasBiomass and biogasBioenergyEuropeIRENA
50Concentrated Solar PowerConcentrated solar powerSolarEuropeIRENA
51Geothermal EnergyGeothermalGeothermalEuropeIRENA
52Large HydropowerHydroHydroEuropeIRENA
53Liquid BiofuelsBiomass and biogasBioenergyEuropeIRENA
54MarineMarineMarineEuropeIRENA
55Medium HydropowerHydroHydroEuropeIRENA
56Offshore WindOffshoreWindEuropeIRENA
57Onshore WindOnshoreWindEuropeIRENA
58Pumped storage and mixed plantsHydroHydroEuropeIRENA
59Small HydropowerHydroHydroEuropeIRENA
60Solar PhotovoltaicPhotovoltaicsSolarEuropeIRENA
61Solid BiomassBiomass and biogasBioenergyEuropeIRENA
62DenmarkDKNaNEuropeIRENA
63FranceFRNaNEuropeIRENA
64GermanyDENaNEuropeIRENA
65PolandPLNaNEuropeIRENA
66Bioenergy and other renewale fuelsBioenergy and renewable wasteBioenergyEuropeOPSD
67SolarSolarNaNEuropeOPSD
68WindWindNaNEuropeOPSD
69GeothermalGeothermalNaNEuropeOPSD
70Differently categorized hydroHydroNaNEuropeOPSD
71Tide, wave, and oceanMarineNaNEuropeOPSD
\n", "

72 rows × 5 columns

\n", "
" ], "text/plain": [ " original_name \\\n", "0 Wind Land \n", "1 Wind See \n", "2 Klärgas \n", "3 Grubengas \n", "4 Freifläche PV \n", "5 Deponiegas \n", "6 Biomasse \n", "7 Wasserkraft \n", "8 Geothermie \n", "9 Windenergie Offshore \n", "10 Solar \n", "11 Windenergie \n", "12 Windenergie an Land \n", "13 HS \n", "14 HS/MS \n", "15 HöS \n", "16 HöS/HS \n", "17 MS \n", "18 MS/NS \n", "19 NS \n", "20 TransnetBW GmbH \n", "21 TenneT TSO GmbH \n", "22 Amprion GmbH \n", "23 HAV \n", "24 LAND \n", "25 Land \n", "26 Biomasse \n", "27 Eolien \n", "28 Géothermie \n", "29 Hydraulique \n", ".. ... \n", "42 hydro-electric power-station capacity up to 10 MW \n", "43 hydro-electric power-station capacity up to 5 MW \n", "44 mixed biogas power-stations \n", "45 onshore wind power-station \n", "46 photovoltaic power-stations \n", "47 sewage treatment plant biogas power-stations \n", "48 pumped-storage power station or flow hydro-ele... \n", "49 Biogas \n", "50 Concentrated Solar Power \n", "51 Geothermal Energy \n", "52 Large Hydropower \n", "53 Liquid Biofuels \n", "54 Marine \n", "55 Medium Hydropower \n", "56 Offshore Wind \n", "57 Onshore Wind \n", "58 Pumped storage and mixed plants \n", "59 Small Hydropower \n", "60 Solar Photovoltaic \n", "61 Solid Biomass \n", "62 Denmark \n", "63 France \n", "64 Germany \n", "65 Poland \n", "66 Bioenergy and other renewale fuels \n", "67 Solar \n", "68 Wind \n", "69 Geothermal \n", "70 Differently categorized hydro \n", "71 Tide, wave, and ocean \n", "\n", " opsd_name energy_source_level_2 country \\\n", "0 Onshore Wind DE \n", "1 Offshore Wind DE \n", "2 Sewage and landfill gas Bioenergy DE \n", "3 Other fossil fuels Other fossil fuels DE \n", "4 Photovoltaics ground Solar DE \n", "5 Sewage and landfill gas Bioenergy DE \n", "6 Biomass and biogas Bioenergy DE \n", "7 Run-of-river Hydro DE \n", "8 Geothermal Geothermal DE \n", "9 Offshore Wind DE \n", "10 Photovoltaics Solar DE \n", "11 Onshore Wind DE \n", "12 Onshore Wind DE \n", "13 high voltage NaN DE \n", "14 high voltage / medium voltage NaN DE \n", "15 extra high voltage NaN DE \n", "16 high voltage / extra high voltage NaN DE \n", "17 medium voltage NaN DE \n", "18 medium voltage / low voltage NaN DE \n", "19 low voltage NaN DE \n", "20 TransnetBW NaN DE \n", "21 TenneT NaN DE \n", "22 Amprion NaN DE \n", "23 Offshore Wind DK \n", "24 Onshore Wind DK \n", "25 Onshore Wind DK \n", "26 Biomass and biogas Bioenergy FR \n", "27 Wind Wind FR \n", "28 Geothermal Geothermal FR \n", "29 Hydro Hydro FR \n", ".. ... ... ... \n", "42 Hydro Hydro PL \n", "43 Hydro Hydro PL \n", "44 Biomass and biogas Bioenergy PL \n", "45 Onshore Wind PL \n", "46 Photovoltaics Solar PL \n", "47 Sewage and landfill gas Bioenergy PL \n", "48 Hydro Hydro PL \n", "49 Biomass and biogas Bioenergy Europe \n", "50 Concentrated solar power Solar Europe \n", "51 Geothermal Geothermal Europe \n", "52 Hydro Hydro Europe \n", "53 Biomass and biogas Bioenergy Europe \n", "54 Marine Marine Europe \n", "55 Hydro Hydro Europe \n", "56 Offshore Wind Europe \n", "57 Onshore Wind Europe \n", "58 Hydro Hydro Europe \n", "59 Hydro Hydro Europe \n", "60 Photovoltaics Solar Europe \n", "61 Biomass and biogas Bioenergy Europe \n", "62 DK NaN Europe \n", "63 FR NaN Europe \n", "64 DE NaN Europe \n", "65 PL NaN Europe \n", "66 Bioenergy and renewable waste Bioenergy Europe \n", "67 Solar NaN Europe \n", "68 Wind NaN Europe \n", "69 Geothermal NaN Europe \n", "70 Hydro NaN Europe \n", "71 Marine NaN Europe \n", "\n", " data_source \n", "0 BNetzA \n", "1 BNetzA \n", "2 BNetzA / TransnetBW / TenneT / 50Hertz / Amprion \n", "3 BnetzA/ Amprion \n", "4 BNetzA \n", "5 BNetzA / TransnetBW / TenneT / 50Hertz / Amprion \n", "6 BNetzA / TransnetBW / TenneT / 50Hertz / Amprion \n", "7 BNetzA / TransnetBW / TenneT / 50Hertz / Amprion \n", "8 BnetzA / TenneT / 50Hertz / Amprion \n", "9 50Hertz / TenneT \n", "10 TransnetBW / TenneT / 50Hertz / Amprion \n", "11 TenneT / 50Hertz / Amprion \n", "12 TransnetBW \n", "13 BNetzA \n", "14 BNetzA \n", "15 BNetzA \n", "16 BNetzA \n", "17 BNetzA \n", "18 BNetzA \n", "19 BNetzA \n", "20 TransnetBW \n", "21 TenneT \n", "22 Amprion \n", "23 Energistyrelsen \n", "24 Energistyrelsen \n", "25 Energistyrelsen \n", "26 gouv.fr \n", "27 gouv.fr \n", "28 gouv.fr \n", "29 gouv.fr \n", ".. ... \n", "42 Urzad Regulacji Energetyki \n", "43 Urzad Regulacji Energetyki \n", "44 Urzad Regulacji Energetyki \n", "45 Urzad Regulacji Energetyki \n", "46 Urzad Regulacji Energetyki \n", "47 Urzad Regulacji Energetyki \n", "48 Urzad Regulacji Energetyki \n", "49 IRENA \n", "50 IRENA \n", "51 IRENA \n", "52 IRENA \n", "53 IRENA \n", "54 IRENA \n", "55 IRENA \n", "56 IRENA \n", "57 IRENA \n", "58 IRENA \n", "59 IRENA \n", "60 IRENA \n", "61 IRENA \n", "62 IRENA \n", "63 IRENA \n", "64 IRENA \n", "65 IRENA \n", "66 OPSD \n", "67 OPSD \n", "68 OPSD \n", "69 OPSD \n", "70 OPSD \n", "71 OPSD \n", "\n", "[72 rows x 5 columns]" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import pandas as pd\n", "pd.read_csv('input/value_translation_list.csv')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## 5.3 Validation marker\n", "\n", "Validation markers are used in comments column in order to mark units for which we identified one of the following issues:" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Validation markerShort explanationLong explanation
0R_1data_source = BnetzA and commissioning_date < ...This powerplant is probably also represented b...
1R_2notification_reason other than „Inbetriebnahme...This powerplant is probably also represented b...
2R_3commissioning_date not specifiedNaN
3R_4electrical_capacity not specifiedNaN
4R_5decommissioned from the gridThis powerplant is probably commissioned again...
5R_6decommissionedThis powerplant is completely decommissioned.
6R_7not connected to the European gridThis powerplant is located in regions belongin...
\n", "
" ], "text/plain": [ " Validation marker Short explanation \\\n", "0 R_1 data_source = BnetzA and commissioning_date < ... \n", "1 R_2 notification_reason other than „Inbetriebnahme... \n", "2 R_3 commissioning_date not specified \n", "3 R_4 electrical_capacity not specified \n", "4 R_5 decommissioned from the grid \n", "5 R_6 decommissioned \n", "6 R_7 not connected to the European grid \n", "\n", " Long explanation \n", "0 This powerplant is probably also represented b... \n", "1 This powerplant is probably also represented b... \n", "2 NaN \n", "3 NaN \n", "4 This powerplant is probably commissioned again... \n", "5 This powerplant is completely decommissioned. \n", "6 This powerplant is located in regions belongin... " ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import pandas as pd\n", "pd.read_csv('input/validation_marker.csv')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## 5.4 Energy source structure\n", "![OPSD-Tree](http://open-power-system-data.org/2016-10-25-opsd_tree.svg)\n", " \n", "# 6. License\n", "This Jupyter Notebook as well as all other documents in this repository is published under the [MIT License](LICENSE.md)." ] } ], "metadata": { "anaconda-cloud": {}, "kernelspec": { "display_name": "Python [default]", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.5.2" }, "latex_envs": { "bibliofile": "biblio.bib", "cite_by": "apalike", "current_citInitial": 1, "eqLabelWithNumbers": true, "eqNumInitial": 0 } }, "nbformat": 4, "nbformat_minor": 0 }