{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "\n", " \n", " \n", " \n", "
\n", " National generation capacity: Main notebook\n", " \n", "
This Notebook is part of the National Generation Capacity Datapackage 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 [datapackages](http://frictionlessdata.io/data-packages/). The one you are looking at is on [national generation capacity](http://data.open-power-system-data.org/national_generation_capacity/), \n", "\n", "This notebook processes data on aggregated generation capacity for European countries. The data includes generation capacities for nuclear, fossil and renewable fuels on an aggregated and, if possible, disaggregated technology levels. The majority of data reflects the years 2013 and 2014.\n", "The final output of the notebook is a list of national generation capacity differentiated by input fuels and technologies, as well as by different data sources\n", "\n", "# 4. Data sources\n", "The raw data is based on an extensive research of available national and international statistics. Due to the diverse structure of data sources, a compiled and structured dataset is used as input for further processing. Generally, three cross-national data sources are considered, complemented by national data sources.\n", "\n", "The cross-national data sources are:\n", "- [EUROSTAT \"Annual data on electricity infrastructure\"](http://ec.europa.eu/eurostat/product?code=nrg_113a&mode=view)\n", "- [ENTSOE \"Net generating capacity\"](https://www.entsoe.eu/db-query/miscellaneous/net-generating-capacity)\n", "- [ENTSOE \"Scenario Outlook & Adequacy Forecasts\"](https://www.entsoe.eu/outlooks/maf/Pages/default.aspx)\n", "\n", "The fourth listed cross-national data source [UN Statistical Office](http://data.un.org/Data.aspx?d=EDATA&f=cmID%3AEC) is only used for countries which are not listed in EUROSTAT data, i.e. Switzerland and Norway.\n", "\n", "Beside this, the data is complemented by national sources, which includes national statistical offices, ministries, regulatory authorities, transmission system operators, as well as other associations. All data sources are listed subsequently and in the `datapackage.json` including their link.\n", "\n", "|\tCountry\t|\tData type\t|\tSource\t\t|\tType of Institution\t|\tDescription\t|\tType of document\t|\tCoverage\t|\n", "| :--- | :--- | :---:|:---|:---|:---:|---:|\n", "|\tMultiple\t|\tAggregated capacities\t|\t[ENTSOE](https://www.entsoe.eu/outlooks/maf/Pages/default.aspx)\t\t|\tAssociation of European Transmission Network Operators\t|\tSystem Outlook and Adequacy Forecasts\t|\tReport\t|\t2011-2016|\n", "|\tMultiple\t|\tAggregated capacities\t|\t[ENTSOE](https://www.entsoe.eu/db-query/miscellaneous/net-generating-capacity)\t\t|\tAssociation of European Transmission Network Operators\t|\tNet generating capacity\t|\tStatistics\t|\t1994-2015\t|\n", "|\tMultiple\t|\tAggregated capacities\t|\t[EUROSTAT](http://ec.europa.eu/eurostat/product?code=nrg_113a&mode=view)\t\t|\tEuropean Statistical Office\t|\tCountry Datasheets 2016 by the European Commission\t|\tStatistics\t|\t1990-2015\t|\n", "|\tMultiple\t|\tAggregated capacities\t|\t[UN Statistical Office](http://data.un.org/Data.aspx?d=EDATA&f=cmID%3AEC)\t\t|\tStatistical Office of the United Nations\t|\tElectricity, net installed capacity of electric power plants\t|\tStatistics\t|\t1990-2013\t|\n", "|\tAT\t|\tAggregated capacities\t|\t[e-control](http://www.e-control.at/statistik/strom/bestandsstatistik)\t\t|\tRegulatory Authority\t|\tEngpassleistung nach Kraftwerkstypen zum 31. Dezember 2015\t|\tStatistics\t|\t2013, 2014, 2015\t|\n", "|\tBE\t|\tList of generation units\t|\t[ELIA](http://www.elia.be/en/grid-data/power-generation/generating-facilities)\t\t|\tTransmission System Operator\t|\tOverview of Generating Facilities\t|\tStatistics\t|\tactual\t|\n", "|\tBG\t|\tAggregated capacities\t|\t[TSO Bulgaria ](http://www.tso.bg/uploads/file/Profile/en/ESO_Annual_Report_2012_en.pdf)\t\t|\tTransmission System Operator\t|\tGeneration Capacities\t|\tReport\t|\t2012\t|\n", "|\tCH\t|\tAggregated capacities\t|\t[BFE](http://www.bfe.admin.ch/themen/00526/00541/00542/00630/index.html?dossier_id=00765)\t\t|\tMinistry\t|\tSchweizerische Elektrizitätsstatistik (Electricity statistics)\t|\tReport\t|\t1998-2015\t|\n", "|\tCZ\t|\tAggregated capacities\t|\t[ERU](http://www.eru.cz/en/elektrina/statistika-a-sledovani-kvality/rocni-zpravy-o-provozu)\t\t|\tRegulatory Authority\t|\tYearly Report on Operations\t|\tReport\t|\t2010-2015\t|\n", "|\tDE\t|\tAggregated capacities\t|\t[BMWi](http://www.bmwi.de/BMWi/Redaktion/Binaer/Energiedaten/energietraeger10-stromerzeugungskapazitaeten-bruttostromerzeugung,property=blob,bereich=bmwi2012,sprache=de,rwb=true.xls)\t\t|\tMinistry\t|\tEnergiedaten (Energy Data)\t|\tStatistics\t|\t1990-2014\t|\n", "|\tDE\t|\tList of generation units\t|\t[BNetzA](http://www.bundesnetzagentur.de/EN/Areas/Energy/Companies/SecurityOfSupply/GeneratingCapacity/PowerPlantList/PubliPowerPlantList_node.html)\t\t|\tRegulatory Authority\t|\tList of Power Plants (>10 MW)\t|\tStatistics\t|\tactual\t|\n", "|\tDE\t|\tList of generation units\t|\t[UBA](https://www.umweltbundesamt.de/dokument/datenbank-kraftwerke-in-deutschland)\t\t|\tEnvironmental Agency\t|\tKraftwerke in Deutschland (Power Plants in Germany, > 100 MW)\t|\tStatistics\t|\tactual\t|\n", "|\tDK\t|\tAggregated capacities\t|\t[DEA](http://www.ens.dk/en/info/facts-figures/energy-statistics-indicators-energy-efficiency/annual-energy-statistics)\t\t|\tEnergy Agency\t|\tAnnual Energy Statistics\t|\tStatistics\t|\t2010-2013\t|\n", "|\tEE\t|\tAggregated capacities\t|\t[Statistics Estonia](http://pub.stat.ee/px-web.2001/Dialog/varval.asp?ma=FE032&ti=CAPACITY+AND+PRODUCTION+OF+POWER+PLANTS&path=../I_Databas/Economy/07Energy/02Energy_consumption_and_production/01Annual_statistics/&lang=1)\t\t|\tNational Statistical Office\t|\tCapacity and Production of Power Plants\t|\tStatistics\t|\t1999-2014\t|\n", "|\tES\t|\tAggregated capacities\t|\t[REE](http://www.ree.es/en/publications/statistical-data-of-spanish-electrical-system/national-indicators/)\t\t|\tTransmission System Operator\t|\tNational Indicators\t|\tStatistics\t|\t1990-2016\t|\n", "|\tFI\t|\tAggregated capacities\t|\t[Statistics Finland](http://pxnet2.stat.fi/PXWeb/pxweb/en/StatFin/StatFin__ene__ehk/240_ehk_tau_112_en.px/table/tableViewLayout1/?rxid=31077c25-37e4-480e-81e6-49a66cbe4dc2)\t\t|\tNational Statistical Office\t|\tCapacity of Electricity Generation\t|\tStatistics\t|\t1970-2015\t|\n", "|\tFR\t|\tAggregated capacities\t|\t[RTE](http://www.rte-france.com/en/documents)\t\t|\tTransmission System Operator\t|\tOverview of electrical energy in France\t|\tReport & Statistics\t|\t2014-2016\t|\n", "|\tFR\t|\tList of generation units\t|\t[RTE](http://clients.rte-france.com/lang/an/visiteurs/vie/prod/parc_reference.jsp)\t\t|\tTransmission System Operator\t|\tInstalled Capacity of Units\t|\tStatistics\t|\tactual\t|\n", "|\tGR\t|\tAggregated capacities\t|\t[REA](http://www.rae.gr/site/file/system/docs/ActionReports/national_2012)\t\t|\tRegulatory Authority\t|\tNational Report 2012\t|\tReport\t|\t2012\t|\n", "|\tHR\t|\tAggregated capacities\t|\t[HOPS](http://www.hops.hr/wps/portal/en/web/documents/publications)\t\t|\tTransmission System Operator\t|\tBasic Data\t|\tReport\t|\t2009-2013\t|\n", "|\tHU\t|\tList of generation units\t|\t[Mavir](http://www.mavir.hu/web/mavir-en/92)\t\t|\tTransmission System Operator\t|\tPlanned Installed Generation Capacity\t|\tReport\t|\t2010-2014\t|\n", "|\tIE\t|\tList of generation units\t|\t[Eirgrid](http://www.eirgridgroup.com/library/index.xml)\t\t|\tTransmission System Operator\t|\tAll-Island Generation Capacity Statement\t|\tReport\t|\t2012-2016\t|\n", "|\tIT\t|\tList of generation units\t|\t[Terna](https://www.terna.it/it-it/sistemaelettrico/transparencyreport/generation/installedgenerationcapacity.aspx)\t\t|\tTransmission System Operator\t|\tInstalled Generation Capacity\t|\tStatistics\t|\t2010-2015\t|\n", "|\tLT\t|\tList of generation units\t|\t[Litgrid](http://www.litgrid.eu/index.php/power-system/power-system-information/generation-capacity/546)\t\t|\tTransmission System Operator\t|\tGeneration Capacities\t|\tStatistics\t|\tactual\t|\n", "|\tLU\t|\tAggregated capacities\t|\t[ILR](http://www.ilr.public.lu/electricite/statistiques/index.html)\t\t|\tRegulatory Authority\t|\tCentrales de productions au Luxembourg\t|\tStatistics\t|\t2001-2014\t|\n", "|\tLV\t|\tAggregated capacities\t|\t[Central Statistical Bureau of Latvia](http://data.csb.gov.lv/pxweb/en/vide/vide__ikgad__energetika/EN0130.px/table/tableViewLayout1/?rxid=a79839fe-11ba-4ecd-8cc3-4035692c5fc8)\t\t|\tNational Statistical Office\t|\tElectrical Capacity\t|\tStatistics\t|\t2007-2015\t|\n", "|\tNL\t|\tAggregated capacities\t|\t[Tennet](http://energieinfo.tennet.org/dataexport/exporteerdatacountry.aspx)\t\t|\tTransmission System Operator\t|\tInstalled Generation Capacity\t|\tStatistics\t|\t2011-2016\t|\n", "|\tNO\t|\tAggregated capacities\t|\t[Ministry of Petroleum and Energy](https://www.regjeringen.no/globalassets/upload/oed/faktaheftet/facts_energy_water.pdf)\t\t|\tMinistry\t|\tFacts: Energy and Water Resources in Norway\t|\tReport\t|\t2013\t|\n", "|\tNO\t|\tAggregated capacities\t|\t[Ministry of Petroleum and Energy](https://www.regjeringen.no/contentassets/fd89d9e2c39a4ac2b9c9a95bf156089a/facts_2015_energy_and_water_web.pdf)\t\t|\tMinistry\t|\tFacts: Energy and Water Resources in Norway\t|\tReport\t|\t2015\t|\n", "|\tPL\t|\tAggregated capacities\t|\t[CIRE](http://www.rynek-energii-elektrycznej.cire.pl/st,33,207,tr,75,0,0,0,0,0,podstawowe-dane.html)\t\t|\tEnergy Market Information Center\t|\tMoc zainstalowana (Installed Capacity)\t|\tStatistics\t|\t2014\t|\n", "|\tPT\t|\tAggregated capacities\t|\t[REN](http://www.ren.pt/en-GB/media/publications/)\t\t|\tTransmission System Operator\t|\tTechnical Data\t|\tReport\t|\t2013 - 2015\t|\n", "|\tRO\t|\tAggregated capacities\t|\t[Anre ](http://www.anre.ro/download.php?f=ga%2BCig%3D%3D&t=vdeyut7dlcecrLbbvbY%3D)\t\t|\tRegulatory Authority\t|\tReport\t|\tReport\t|\t2013 - 2015\t|\n", "|\tSE\t|\tAggregated capacities\t|\t[Svensk Energi](http://www.svenskenergi.se/Vi-erbjuder/Webbshop/Gratis-publikationer/Statistik/)\t\t|\tEnergy Agency\t|\tStatistics Sweden\t|\tReport\t|\t2013 -2015\t|\n", "|\tSI\t|\tAggregated capacities\t|\t[Agencija za energijo](http://www.agen-rs.si/web/en/publications/-/asset_publisher/TCdo6cWN9Shk/content/te-1?_101_INSTANCE_TCdo6cWN9Shk_redirect=%2Fweb%2Fen%2Fpublications)\t\t|\tRegulatory Authority\t|\tReport on the Energy Sector in Slovenia\t|\tReport\t|\t2011-2015\t|\n", "|\tSK\t|\tAggregated capacities\t|\t[Statistical Office of Slovakia](https://slovak.statistics.sk/wps/portal/ext/themes/multi/energy/publications/!ut/p/b1/jZLBToQwEIafxSdgaIGyxwJLaRYrpbSuXAwHYzDurgfj81tY1BjiYG_NfF87_7RBHxyD_jx8jM_D-3g5D6_Tvk8eXd2kWRZyEKwLQSplrEs1tZJ54MEDXGttaudAOFKCpKEAZS1Al8y-ZvLqp5kjIJlqw4PWghRbfslmHzn-6ueCVxGrAdJaxCB5ZdudphQ4_V__8MfigN5ffvlIwMkvTUP4LhJ50d55v8tJauqEAISLjwBI_7ddtPgI8Hv-hzz35bgrYqdos49W_a8AzPfjwf1lfj_lmIEvGz87Z8DA2l8BSP69Ajz_BGy8_33Qzwj2g2YA-yJbj9yjKcp4A_ApVHU5PQVvJ_u9jjDKl4jffAIuhKL8/dl4/d5/L2dJQSEvUUt3QS80SmtFL1o2X1ZMUDhCQjFBMEc3VDEwSU5OU1VWOFEzVUM0/)\t\t|\tNational Statistical Office\t|\tEnergy Statistics\t|\tReport\t|\t2008-2015\t|\n", "|\tUK\t|\tAggregated capacities\t|\t[Department of Energy & Climate Change UK](https://www.gov.uk/government/statistics/electricity-chapter-5-digest-of-united-kingdom-energy-statistics-dukes)\t\t|\tMinistry\t|\tPlant Capacity\t|\tStatistics\t|\t2010-2015\t|" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# 5. Notation\n", "As we compile different source for national generation capacity, we define a consolidated classifiation scheme based on energy sources and technologies. The classification scheme is related to four different energy source levels, to reflect the structural relations among the categories:\n", "\n", "- **Energy source level 0** - Total generation capacity\n", "- **Energy source level 1** - Generation capacity by energy type (fossil, nuclear, renewable, other)\n", "- **Energy source level 2** - Generation capacity by fuel or energy source (e.g. coal, lignite, hard coal, natural gas, wind)\n", "- **Energy source level 3** - Generation capacity by fuel or energy source and detailed fuel for bioenergy\n", "- **Technology level** - Generation capacity by fuel and technology (e.g. combined cycle natural gas, gas turbine, onshore wind, offshore wind)\n", "\n", "Additionally, the definition of the energy source levels ensures that the total capacity is identical for each energy source level.\n", "\n", "Moreover, some specific comments on particular categories:\n", "\n", "|\tCategory/Technology\t|\tNote\t|\n", "| :--- | :--- | \n", "|*Differently categorized …*|\tThese categories comprise either capacities which cannot be assigned to specific categories at the same level, or capacities with unspecified fuel or technology.| \n", "|*Reservoir including pumped storage*|\tAggregated capacity of reservoirs and pumped storage, or combinations of both. Relevant for AT.|\n", "|*Pumped storage with natural inflow*|\tPumped storage with natural inflow, or reservoirs with pumping capacity.|\n", "\n", "\n", "The information on the technology levels is rearranged the following table. It displays the four general technology levels and the corresponding categories:" ] }, { "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", "
Level 0Level 1Level 2Level 3Technology level
Technology
Fossil fuelsTrue
- LigniteTrueTrueTrue
- Hard coalTrueTrueTrue
- OilTrueTrueTrue
- Natural gasTrueTrue
- Combined cycleTrue
- Gas turbineTrue
- Other and unknown natural gasTrue
- Differently categorized natural gasTrue
- Non-renewable wasteTrueTrueTrue
- Mixed fossil fuelsTrueTrueTrue
- Other fossil fuelsTrueTrueTrue
- Differently categorized fossil fuelsTrueTrueTrue
NuclearTrueTrueTrueTrue
Renewable energy sourcesTrue
- HydroTrueTrue
- Run-of-riverTrue
- ReservoirTrue
- Reservoir including pumped storageTrue
- Pumped storageTrue
- Pumped storage with natural inflowTrue
- Differently categorized hydroTrue
- WindTrueTrue
- OnshoreTrue
- OffshoreTrue
- Differently categorized windTrue
- SolarTrueTrue
- PhotovoltaicsTrue
- Concentrated solar powerTrue
- Differently categorized solarTrue
- GeothermalTrueTrueTrue
- MarineTrueTrueTrue
- Bioenergy and renewable wasteTrue
- Biomass and biogasTrueTrue
- Sewage and landfill gasTrueTrue
- Other bioenergy and renewable wasteTrueTrue
- Differently categorized renewable energy sourcesTrueTrueTrue
Other or unspecified energy sourcesTrueTrueTrueTrue
TotalTrue
\n", "
" ], "text/plain": [ " Level 0 Level 1 Level 2 \\\n", "Technology \n", "Fossil fuels True \n", "- Lignite True \n", "- Hard coal True \n", "- Oil True \n", "- Natural gas True \n", "- Combined cycle \n", "- Gas turbine \n", "- Other and unknown natural gas \n", "- Differently categorized natural gas \n", "- Non-renewable waste True \n", "- Mixed fossil fuels True \n", "- Other fossil fuels True \n", "- Differently categorized fossil fuels True \n", "Nuclear True True \n", "Renewable energy sources True \n", "- Hydro True \n", "- Run-of-river \n", "- Reservoir \n", "- Reservoir including pumped storage \n", "- Pumped storage \n", "- Pumped storage with natural inflow \n", "- Differently categorized hydro \n", "- Wind True \n", "- Onshore \n", "- Offshore \n", "- Differently categorized wind \n", "- Solar True \n", "- Photovoltaics \n", "- Concentrated solar power \n", "- Differently categorized solar \n", "- Geothermal True \n", "- Marine True \n", "- Bioenergy and renewable waste True \n", "- Biomass and biogas \n", "- Sewage and landfill gas \n", "- Other bioenergy and renewable waste \n", "- Differently categorized renewable energy sources True \n", "Other or unspecified energy sources True True \n", "Total True \n", "\n", " Level 3 Technology level \n", "Technology \n", "Fossil fuels \n", "- Lignite True True \n", "- Hard coal True True \n", "- Oil True True \n", "- Natural gas True \n", "- Combined cycle True \n", "- Gas turbine True \n", "- Other and unknown natural gas True \n", "- Differently categorized natural gas True \n", "- Non-renewable waste True True \n", "- Mixed fossil fuels True True \n", "- Other fossil fuels True True \n", "- Differently categorized fossil fuels True True \n", "Nuclear True True \n", "Renewable energy sources \n", "- Hydro True \n", "- Run-of-river True \n", "- Reservoir True \n", "- Reservoir including pumped storage True \n", "- Pumped storage True \n", "- Pumped storage with natural inflow True \n", "- Differently categorized hydro True \n", "- Wind True \n", "- Onshore True \n", "- Offshore True \n", "- Differently categorized wind True \n", "- Solar True \n", "- Photovoltaics True \n", "- Concentrated solar power True \n", "- Differently categorized solar True \n", "- Geothermal True True \n", "- Marine True True \n", "- Bioenergy and renewable waste \n", "- Biomass and biogas True True \n", "- Sewage and landfill gas True True \n", "- Other bioenergy and renewable waste True True \n", "- Differently categorized renewable energy sources True True \n", "Other or unspecified energy sources True True \n", "Total " ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import os, pandas as pd;\n", "energylevels = pd.read_excel(os.path.join('input', 'National_Generation_Capacities.xlsx'),\n", " sheetname='Summary',\n", " header=0,\n", " na_values=['-'],\n", " parse_cols='A:F',\n", " index_col=0,\n", " skiprows=5)\n", "energylevels = energylevels[pd.notnull(energylevels.index)]\n", "energylevels = energylevels.replace({0: ' ', 1: True})\n", "energylevels.index.name = 'Technology'\n", "energylevels" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# 6. License\n", "This 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" } }, "nbformat": 4, "nbformat_minor": 0 }