File:EEG-Surcharge (English).svg

From Wikimedia Commons, the free media repository
Jump to navigation Jump to search

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

Captions

Captions

Add a one-line explanation of what this file represents

Summary[edit]

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

Related images[edit]

Data[edit]

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[edit]

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[edit]

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.

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)TDF (talk | contribs)Uploaded own work with UploadWizard

There are no pages that use this file.

File usage on other wikis

The following other wikis use this file:

Metadata