File:EEG-Surcharge (English).svg

Original file (SVG file, nominally 1,080 × 720 pixels, file size: 63 KB)

Summary

Description
English: Development of the EEG-Surcharge according to the German law about renewable energies (EEG).
Deutsch: Entwicklung der EEG-Umlage.
Date
Source Own work
Author TDF

Data

Data shown (CSV data, save as "surcharge_data.csv" to use the plot script below):

year,surcharge (ct/kWh),source,link
2000,0.19,erneuerbare-energien.de,https://www.erneuerbare-energien.de/EE/Redaktion/DE/Downloads/eeg-in-zahlen-pdf.pdf%3F__blob%3DpublicationFile
2001,0.25,erneuerbare-energien.de,https://www.erneuerbare-energien.de/EE/Redaktion/DE/Downloads/eeg-in-zahlen-pdf.pdf%3F__blob%3DpublicationFile
2002,0.36,erneuerbare-energien.de,https://www.erneuerbare-energien.de/EE/Redaktion/DE/Downloads/eeg-in-zahlen-pdf.pdf%3F__blob%3DpublicationFile
2003,0.37,erneuerbare-energien.de,https://www.erneuerbare-energien.de/EE/Redaktion/DE/Downloads/eeg-in-zahlen-pdf.pdf%3F__blob%3DpublicationFile
2004,0.54,erneuerbare-energien.de,https://www.erneuerbare-energien.de/EE/Redaktion/DE/Downloads/eeg-in-zahlen-pdf.pdf%3F__blob%3DpublicationFile
2005,0.70,erneuerbare-energien.de,https://www.erneuerbare-energien.de/EE/Redaktion/DE/Downloads/eeg-in-zahlen-pdf.pdf%3F__blob%3DpublicationFile
2006,0.89,erneuerbare-energien.de,https://www.erneuerbare-energien.de/EE/Redaktion/DE/Downloads/eeg-in-zahlen-pdf.pdf%3F__blob%3DpublicationFile
2007,1.03,erneuerbare-energien.de,https://www.erneuerbare-energien.de/EE/Redaktion/DE/Downloads/eeg-in-zahlen-pdf.pdf%3F__blob%3DpublicationFile
2008,1.16,erneuerbare-energien.de,https://www.erneuerbare-energien.de/EE/Redaktion/DE/Downloads/eeg-in-zahlen-pdf.pdf%3F__blob%3DpublicationFile
2009,1.32,erneuerbare-energien.de,https://www.erneuerbare-energien.de/EE/Redaktion/DE/Downloads/eeg-in-zahlen-pdf.pdf%3F__blob%3DpublicationFile
2010,2.047,netztransparenz.de,https://www.netztransparenz.de/EEG/EEG-Umlagen-Uebersicht
2011,3.530,netztransparenz.de,https://www.netztransparenz.de/EEG/EEG-Umlagen-Uebersicht
2012,3.592,netztransparenz.de,https://www.netztransparenz.de/EEG/EEG-Umlagen-Uebersicht
2013,5.277,netztransparenz.de,https://www.netztransparenz.de/EEG/EEG-Umlagen-Uebersicht
2014,6.240,netztransparenz.de,https://www.netztransparenz.de/EEG/EEG-Umlagen-Uebersicht
2015,6.170,netztransparenz.de,https://www.netztransparenz.de/EEG/EEG-Umlagen-Uebersicht
2016,6.354,netztransparenz.de,https://www.netztransparenz.de/EEG/EEG-Umlagen-Uebersicht
2017,6.880,netztransparenz.de,https://www.netztransparenz.de/EEG/EEG-Umlagen-Uebersicht
2018,6.792,netztransparenz.de,https://www.netztransparenz.de/EEG/EEG-Umlagen-Uebersicht
2019,6.405,netztransparenz.de,https://www.netztransparenz.de/EEG/EEG-Umlagen-Uebersicht
2020,6.756,netztransparenz.de,https://www.netztransparenz.de/EEG/EEG-Umlagen-Uebersicht

Script

Python source to generate the plots:

import pandas as pd 
import matplotlib.pyplot as plt
import seaborn as sns

# if the data does not load, try to remove the encoding option (which then defaults to utf-8).
data = pd.read_csv('./surcharge_data.csv', encoding='utf-16')
#print(data) # For developing/debugging: Comment out to print the data that was read.

yearKey = 'year'
valueKey = 'surcharge (ct/kWh)'
sourceKey = 'source'
linkKey = 'link'
relDiffKey = 'rel. diff. next year'

# Calculate the relative difference to the next year, since the original Wikipedia table
# showed it. Not convinced that it's worth plotting this, though.
data[relDiffKey] = data[valueKey].diff()/ data[valueKey]

# Label settings for different language versions
labels_EN = { 'main': 'EEG-Surcharge (€ct/kWh)', 'source': 'Source', 'delim' : '.'}
labels_DE = { 'main': 'EEG-Umlage (ct/kWh)',     'source': 'Quelle', 'delim' : ','}


def doPlot(labels = labels_EN):
    '''Perform the actual plot (on screen). The visible labels are passed as parameter 
    for multi-language support. Save the image in the window as PDF to get the actual
    image file.'''
    sns.set()
    plt.figure(figsize=(12,8))
    palette = sns.cubehelix_palette(3)
    ax = sns.barplot(yearKey, valueKey, data=data, hue=sourceKey, palette=palette, dodge=False)    
    for p in ax.patches:
        # plot the values on top of the bars
        ax.annotate(
            format(p.get_height(), '.2f').replace('.', labels['delim']), 
            (p.get_x() + p.get_width() / 2., p.get_height()), 
            ha = 'center', va = 'center', 
            xytext = (0, 10), textcoords = 'offset points'
        )
    ax.set_xticklabels(ax.get_xticklabels(), rotation=45)
    ax.set_xlabel('')
    ax.set_ylabel(labels['main'])
    ax.get_legend().set_title(labels['source'])
    plt.show()

doPlot(labels_EN)
doPlot(labels_DE)

Licensing

I, the copyright holder of this work, hereby publish it under the following license:
Creative Commons CC-Zero This file is made available under the Creative Commons CC0 1.0 Universal Public Domain Dedication.
The person who associated a work with this deed has dedicated the work to the public domain by waiving all of their rights to the work worldwide under copyright law, including all related and neighboring rights, to the extent allowed by law. You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission.

Captions

Add a one-line explanation of what this file represents

Items portrayed in this file

depicts

19 August 2020

File history

Click on a date/time to view the file as it appeared at that time.

Date/TimeThumbnailDimensionsUserComment
current14:29, 19 August 2020Thumbnail for version as of 14:29, 19 August 20201,080 × 720 (63 KB)TDFUploaded own work with UploadWizard

The following page uses this file:

Metadata