Jovian
Sign In
Learn practical skills, build real-world projects, and advance your career
4 years ago

Analysis of the German Power Market (with Python)

Along with France, Germany is one of the top energy producers in Central Europe. Its aggressive Energy Transition policy, known as the Energiewende, positioned the country as a renewable energy production leader in Europe. According to the Fraunhofer Institute for Solar Energy Systems ISE, in 2019, the share of renewables in Germany's net electricity generation reached 46 percent, up from 40.6 percent in 2018.

In this article, we will analyze data from the german power market using Python and its libraries. Our dataset shows daily information on the German power market from 07-Jul-2020 to 01-Oct-2020. It contains:
- Energy Consumption
- Wind + Solar Power Generation
- Other Sources Power Generation
- Electricity Spot Price

The information is provided in timeslices with a duration of 4 hours. According to this, each day is divided in 6 timeblocks. The timeslices are:
- From 00:00 to 04:00
- From 04:00 to 08:00
- From 08:00 to 12:00
- From 12:00 to 16:00
- From 16:00 to 20:00
- From 20:00 to 00:00

Data Preparation

As first step, we need to import the libraries we expect to use:

!pip install jovian
import jovian
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
%matplotlib inline
Collecting jovian Downloading jovian-0.2.20-py2.py3-none-any.whl (65 kB) |████████████████████████████████| 65 kB 454 kB/s eta 0:00:011 Requirement already satisfied: requests in /opt/conda/lib/python3.7/site-packages (from jovian) (2.23.0) Requirement already satisfied: click in /opt/conda/lib/python3.7/site-packages (from jovian) (7.1.1) Collecting uuid Downloading uuid-1.30.tar.gz (5.8 kB) Requirement already satisfied: pyyaml in /opt/conda/lib/python3.7/site-packages (from jovian) (5.3.1) Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in /opt/conda/lib/python3.7/site-packages (from requests->jovian) (1.24.3) Requirement already satisfied: certifi>=2017.4.17 in /opt/conda/lib/python3.7/site-packages (from requests->jovian) (2020.6.20) Requirement already satisfied: idna<3,>=2.5 in /opt/conda/lib/python3.7/site-packages (from requests->jovian) (2.9) Requirement already satisfied: chardet<4,>=3.0.2 in /opt/conda/lib/python3.7/site-packages (from requests->jovian) (3.0.4) Building wheels for collected packages: uuid Building wheel for uuid (setup.py) ... done Created wheel for uuid: filename=uuid-1.30-py3-none-any.whl size=6500 sha256=3e7bc1f16f2d99218be5fd0cfed239f9a515fefdcf85ce9362830f4b30874cfa Stored in directory: /root/.cache/pip/wheels/2a/ea/87/dd57f1ecb4f0752f3e1dbf958ebf8b36d920d190425bcdc24d Successfully built uuid Installing collected packages: uuid, jovian Successfully installed jovian-0.2.20 uuid-1.30