{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "
\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", "## 4.5 Switzerland - CH\n", "- [Swiss Federal Office of Energy](http://www.bfe.admin.ch/themen/00612/02073/index.html?dossier_id=02166&lang=de)\n", "\n", ">Data of all renewable power plants receiving \"Kostendeckende Einspeisevergütung\" (KEV) which is the Swiss feed in tarif for renewable power plants. \n", "Geodata is based on municipality codes.\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", "\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": {}, "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
..................
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_2Type of energy source / generationEuropeOPSD
89capacityelectrical_capacityInstalled electrical capacity in MWEuropeOPSD
90sourcedata_sourceNaNEuropeOPSD
91Country / AreacountryNaNEuropeIRENA
92Sub TechnologytechnologyNaNEuropeIRENA
93YearyearNaNEuropeIRENA
94Valueelectrical_capacityNaNEuropeIRENA
95Anlage_\\nEnergieträgerenergy_source_level_2Type of energy source / generationCHBFE
96AnlagentyptechnologyType of used technologyCHBFE
97Leistung [kW]electrical_capacityInstalled electrical capacity in MWCHBFE
98Anlage_Inbetriebnahme-\\ndatumcommissioning_dateNaNCHBFE
99Anlage_PLZmunicipality_codeNaNCHBFE
100Anlage_OrtmunicipalityNaNCHBFE
101Anlage_Projekt-Bezeichnungproject_namename of the project/asset or companyCHBFE
102Produktion [kWh]**productionproduction in kWhCHBFE
103Vergütung 2016 [CHF]tarifftariff in CHF for 2016CHBFE
104Anmeldedatumnotification_datedate of data entriy at BFECHBFE
105Anlage_Vertragsendecantract_period_endend of the contract periodCHBFE
106Anlage_Strassestreetname of the streetCHBFE
107Anlage_Kantoncantonname of the cantones/ member states of the Swi...CHBFE
108Produzent_Firmacompanyname of the companyCHBFE
109Produzent_Anredetitletitel of ownerCHBFE
110Produzent_Namesurnamefamily name of ownerCHBFE
111Produzent_\\nVornamefirst_namegiven name of ownerCHBFE
\n", "

112 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", "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", "95 Anlage_\\nEnergieträger energy_source_level_2 \n", "96 Anlagentyp technology \n", "97 Leistung [kW] electrical_capacity \n", "98 Anlage_Inbetriebnahme-\\ndatum commissioning_date \n", "99 Anlage_PLZ municipality_code \n", "100 Anlage_Ort municipality \n", "101 Anlage_Projekt-Bezeichnung project_name \n", "102 Produktion [kWh]** production \n", "103 Vergütung 2016 [CHF] tariff \n", "104 Anmeldedatum notification_date \n", "105 Anlage_Vertragsende cantract_period_end \n", "106 Anlage_Strasse street \n", "107 Anlage_Kanton canton \n", "108 Produzent_Firma company \n", "109 Produzent_Anrede title \n", "110 Produzent_Name surname \n", "111 Produzent_\\nVorname first_name \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", "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 Type of energy source / generation Europe \n", "89 Installed electrical capacity in MW Europe \n", "90 NaN Europe \n", "91 NaN Europe \n", "92 NaN Europe \n", "93 NaN Europe \n", "94 NaN Europe \n", "95 Type of energy source / generation CH \n", "96 Type of used technology CH \n", "97 Installed electrical capacity in MW CH \n", "98 NaN CH \n", "99 NaN CH \n", "100 NaN CH \n", "101 name of the project/asset or company CH \n", "102 production in kWh CH \n", "103 tariff in CHF for 2016 CH \n", "104 date of data entriy at BFE CH \n", "105 end of the contract period CH \n", "106 name of the street CH \n", "107 name of the cantones/ member states of the Swi... CH \n", "108 name of the company CH \n", "109 titel of owner CH \n", "110 family name of owner CH \n", "111 given name of owner CH \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", "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", "95 BFE \n", "96 BFE \n", "97 BFE \n", "98 BFE \n", "99 BFE \n", "100 BFE \n", "101 BFE \n", "102 BFE \n", "103 BFE \n", "104 BFE \n", "105 BFE \n", "106 BFE \n", "107 BFE \n", "108 BFE \n", "109 BFE \n", "110 BFE \n", "111 BFE \n", "\n", "[112 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": {}, "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
..................
62DenmarkDKNaNEuropeIRENA
63FranceFRNaNEuropeIRENA
64GermanyDENaNEuropeIRENA
65PolandPLNaNEuropeIRENA
66Bioenergy and other renewale fuelsBioenergy and renewable wasteBioenergyEuropeOPSD
67SolarSolarNaNEuropeOPSD
68WindWindNaNEuropeOPSD
69GeothermalGeothermalNaNEuropeOPSD
70Differently categorized hydroHydroNaNEuropeOPSD
71Tide, wave, and oceanMarineNaNEuropeOPSD
72BiomasseBiomassBioenergyCHBFE
73WindWindWindCHBFE
74PhotovoltaikPhotovoltaicsSolarCHBFE
75WasserkraftHydroHydroCHBFE
76AbwasserkraftwerkWaste water plantNaNCHBFE
77SchlammverbrennungsanlageBiomass and biogasBioenergyCHBFE
78KehrrichtverbrennungsanlageBiomass and biogasBioenergyCHBFE
79Integrierte AnlageIntegrated unitNaNCHBFE
80Angebaute AnlageConnected unitNaNCHBFE
81DurchlaufkraftwerkRun-of-riverNaNCHBFE
82Freistehende AnlageStand alone unitNaNCHBFE
83Dotierwasserkraftwerkother HydroNaNCHBFE
84KlärgasanlageBiomass and biogasBioenergyCHBFE
85übrige Biomasse - übrige WKK-AnlageBiomass and biogasBioenergyCHBFE
86übrige Biomasse - DampfprozessBiomass and biogasBioenergyCHBFE
87AusleitkraftwerkDiversion plantHydroCHBFE
88UnbekanntUnknownNaNCHBFE
89natürliche PersonNatural personNaNCHBFE
90juristische PersonLegal entityNaNCHBFE
91TrinkwasserkraftwerkDrinking water plantHydroCHBFE
\n", "

92 rows × 5 columns

\n", "
" ], "text/plain": [ " original_name opsd_name \\\n", "0 Wind Land Onshore \n", "1 Wind See Offshore \n", "2 Klärgas Sewage and landfill gas \n", "3 Grubengas Other fossil fuels \n", "4 Freifläche PV Photovoltaics ground \n", "5 Deponiegas Sewage and landfill gas \n", "6 Biomasse Biomass and biogas \n", "7 Wasserkraft Run-of-river \n", "8 Geothermie Geothermal \n", "9 Windenergie Offshore Offshore \n", "10 Solar Photovoltaics \n", "11 Windenergie Onshore \n", "12 Windenergie an Land Onshore \n", "13 HS high voltage \n", "14 HS/MS high voltage / medium voltage \n", "15 HöS extra high voltage \n", "16 HöS/HS high voltage / extra high voltage \n", "17 MS Medium voltage \n", "18 MS/NS Medium voltage / low voltage \n", "19 NS Low voltage \n", "20 TransnetBW GmbH TransnetBW \n", "21 TenneT TSO GmbH TenneT \n", "22 Amprion GmbH Amprion \n", "23 HAV Offshore \n", "24 LAND Onshore \n", "25 Land Onshore \n", "26 Biomasse Biomass and biogas \n", "27 Eolien Wind \n", "28 Géothermie Geothermal \n", "29 Hydraulique Hydro \n", ".. ... ... \n", "62 Denmark DK \n", "63 France FR \n", "64 Germany DE \n", "65 Poland PL \n", "66 Bioenergy and other renewale fuels Bioenergy and renewable waste \n", "67 Solar Solar \n", "68 Wind Wind \n", "69 Geothermal Geothermal \n", "70 Differently categorized hydro Hydro \n", "71 Tide, wave, and ocean Marine \n", "72 Biomasse Biomass \n", "73 Wind Wind \n", "74 Photovoltaik Photovoltaics \n", "75 Wasserkraft Hydro \n", "76 Abwasserkraftwerk Waste water plant \n", "77 Schlammverbrennungsanlage Biomass and biogas \n", "78 Kehrrichtverbrennungsanlage Biomass and biogas \n", "79 Integrierte Anlage Integrated unit \n", "80 Angebaute Anlage Connected unit \n", "81 Durchlaufkraftwerk Run-of-river \n", "82 Freistehende Anlage Stand alone unit \n", "83 Dotierwasserkraftwerk other Hydro \n", "84 Klärgasanlage Biomass and biogas \n", "85 übrige Biomasse - übrige WKK-Anlage Biomass and biogas \n", "86 übrige Biomasse - Dampfprozess Biomass and biogas \n", "87 Ausleitkraftwerk Diversion plant \n", "88 Unbekannt Unknown \n", "89 natürliche Person Natural person \n", "90 juristische Person Legal entity \n", "91 Trinkwasserkraftwerk Drinking water plant \n", "\n", " energy_source_level_2 country \\\n", "0 Wind DE \n", "1 Wind DE \n", "2 Bioenergy DE \n", "3 Other fossil fuels DE \n", "4 Solar DE \n", "5 Bioenergy DE \n", "6 Bioenergy DE \n", "7 Hydro DE \n", "8 Geothermal DE \n", "9 Wind DE \n", "10 Solar DE \n", "11 Wind DE \n", "12 Wind DE \n", "13 NaN DE \n", "14 NaN DE \n", "15 NaN DE \n", "16 NaN DE \n", "17 NaN DE \n", "18 NaN DE \n", "19 NaN DE \n", "20 NaN DE \n", "21 NaN DE \n", "22 NaN DE \n", "23 Wind DK \n", "24 Wind DK \n", "25 Wind DK \n", "26 Bioenergy FR \n", "27 Wind FR \n", "28 Geothermal FR \n", "29 Hydro FR \n", ".. ... ... \n", "62 NaN Europe \n", "63 NaN Europe \n", "64 NaN Europe \n", "65 NaN Europe \n", "66 Bioenergy Europe \n", "67 NaN Europe \n", "68 NaN Europe \n", "69 NaN Europe \n", "70 NaN Europe \n", "71 NaN Europe \n", "72 Bioenergy CH \n", "73 Wind CH \n", "74 Solar CH \n", "75 Hydro CH \n", "76 NaN CH \n", "77 Bioenergy CH \n", "78 Bioenergy CH \n", "79 NaN CH \n", "80 NaN CH \n", "81 NaN CH \n", "82 NaN CH \n", "83 NaN CH \n", "84 Bioenergy CH \n", "85 Bioenergy CH \n", "86 Bioenergy CH \n", "87 Hydro CH \n", "88 NaN CH \n", "89 NaN CH \n", "90 NaN CH \n", "91 Hydro CH \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", "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", "72 BFE \n", "73 BFE \n", "74 BFE \n", "75 BFE \n", "76 BFE \n", "77 BFE \n", "78 BFE \n", "79 BFE \n", "80 BFE \n", "81 BFE \n", "82 BFE \n", "83 BFE \n", "84 BFE \n", "85 BFE \n", "86 BFE \n", "87 BFE \n", "88 BFE \n", "89 BFE \n", "90 BFE \n", "91 BFE \n", "\n", "[92 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": {}, "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 3", "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.6.3" }, "latex_envs": { "bibliofile": "biblio.bib", "cite_by": "apalike", "current_citInitial": 1, "eqLabelWithNumbers": true, "eqNumInitial": 0 } }, "nbformat": 4, "nbformat_minor": 1 }