Training

01 - Introduction

We have created training bundles which provide various material on how to interact with the OEP. Each training bundle provides learning materials which cater to different levels of expertise. Some are targeted at fluent programmers, others are targeted at persons who prefer to interact with the OEP visually.

You can unfold each of the questions in the green boxes. You will then see a targeted selection of training materials. Each of these materials is described by a short abstract that will help you decide whether this is material that will be helpful for you. If it is, please click the link to view the material.

As a visual guide regarding what to expect behind the links, we use the following icons:

links to written training material. The material may include some code for guidance.
links to material focussing on code.
is some informational text without a link to specific material.

Our training courses can grow over time. If you see the need for further documentation, please feel free to get in touch with us via our contact form.

02 - Download - Find and download / interact with data

You want to find data on the OEP? You want to download and / or interact with the data on the OEP? Below we have bundled various information for you.

How to find data on the OEP? (tutorial):
This tutorial teaches you how to use the free text search and tags to filter for data on the OEP. You will see that you can use both approaches individually, but also combine freetext and tags to specify your data filter further.

Process query result data and save to file (tutorial):
Learn how to use the REST-full-HTTP API in Python for selecting data on the OEP, make calculations with it and save the results to a file.

How to download data - CSV and data package (tutorial):
Learn how easy it is do download any data table you are viewing on the OEP table with only one click and why a data package makes a difference.

Data queries via API (tutorial):
This tutorial provides an overview of how you can select and filter data that resides on the OEP via the REST-full-HTTP API in Python

Process query result data and save to file (tutorial):
Learn how to use the REST-full-HTTP API in Python for selecting data on the OEP, make calculations with it and save the results to a file.

Our current scenario factsheets provide some dedicated information about specific scenarios for which projection data is available on the OEP. Please note, however, that their format was developed some time ago and they will undergo substantial updates. In the future, these scenario factsheets will be succeeded by study factsheets (alpha) that will hold more functionality. These improved factsheets will be based on RDF and the Open Energy Knowledge Graph (OEKG) which is currently under heavy development. Please note that this is therefore just a preview and not a fully functional feature yet.

drawing
Authors: Hannah Förster, Anne Siemons
Copyright: Öko-Institut
Contact: oedb@oeko.de
License: CC BY 4.0
Attribution: Öko-Institut (2022): Download - Find and download / interact with data
Last update: 2022-11-01

03 - Upload - Contribute data to the OEP

Publishing data on the OEP can basically happen in two ways. You can do it using programming skills, or by using an interface to the OEP if you prefer not to program. We have a range of tutorials available to suit your needs and this capacity building package bundles them together for you and specifies for each, what you can expect from each of them.

Upload tables as csv (tutorial):
This tutorial teaches you step-by-step on how to upload data from a .csv file to the OEP using the csv upload wizard.

, Beginners Guide: How to upload data to the OpenEnergy Platform and initiate the review process (tutorial):
This tutorial (also available as PDF) describes how to upload data to the OEP using Python and the REST-API. Several steps are needed to contribute actively to the platform. Some of these you only need to do once to get started. The steps described in this document are the following: Register at the OpenEnergy Platform, Register at github and get invited to the OpenEnergy Platform Group, Create data table(s) and upload data table(s), create metadata and upload metadata to github, initiate data review, create scenario factsheets.

Upload csv data to a new table on the OEP using the oedialect (tutorial):
This jupyter notebook tutorial teaches you how to upload data from a .csv file to the OEP.
Table creation and OEP upload with an SQLAlchemy Dialect (tutorial):
If you are interested in using the SQLAlchemy dialect, this tutorial is for you. It shows you how to create and upload tables to the OEP using that dialect. This is a jupyter notebook tutorial.
How to Upload Your Data and Metadata to the OEP (tutorial):
This jupyter notebook tutorial provides you a quick way of having all the code at hand to upload your data and metadata to the OEP.

drawing
Authors: Hannah Förster, Anne Siemons
Copyright: Öko-Institut
Contact: oedb@oeko.de
License: CC BY 4.0
Attribution: Öko-Institut (2022): Upload - Contribute data to the OEP
Last update: 2022-08-10

Tutorials by category

Category Name Medium Level
Default 01 - Introduction
notebook
notebook
Default 02 - Download - Find and download / interact with data
notebook
notebook
Default 03 - Upload - Contribute data to the OEP
notebook
notebook
Upload/Download API tutorial 1 - Introduction to the OEP-API and basic table opperations
notebook
notebook
Upload/Download API tutorial 2 - Advanced OEP-API data queries using query parameters
notebook
notebook
Other Topics API tutorial 3 - Plot data and spatial data
notebook
notebook
Upload/Download API tutorial 4 - Process query result data and save to file
notebook
notebook
Default Beginners Guide: How to upload data to the OpenEnergy Platform and initiate the review process
notebook
notebook
Default CBM-Template
notebook
notebook
Default Checklist for working with open data
notebook
notebook
Upload/Download Create a (Geo)Dataframe from OEP Data and export it as geopackage
notebook
notebook
Default Create and upload table from csv using the platform wizard
notebook
notebook
Data Structure Create simple Entity-Relationship-Modell (ERM) diagrams for any table on the OEP
notebook
notebook
Default FAQ
notebook
notebook
Default Find data on the OEP
notebook
notebook
Upload/Download Getting started with postgis spatial functions using python
notebook
notebook
Publication/Licensing Guidebook - How to Publish Your Data on the OEP
notebook
notebook
Default How to download data - CSV and datapackage
notebook
notebook
Default How to generate database conform data?
notebook
notebook
Default How to normalize/denormalize data?
notebook notebook
notebook
Default How to upload data to the OEP: 2 ways!
notebook
notebook
Default Jupyter Notebooks - How to install and run them on Linux
notebook notebook
notebook
Default Jupyter Notebooks - What they are and how to use them
notebook notebook
notebook
Data Structure Normalize and Denormalize Dataframes
notebook
notebook
Publication/Licensing OEMetadata - What is it and how do I use it?
notebook
notebook
Upload/Download OEP Upload Process for data and metadata
notebook
notebook
Publication/Licensing Open Data Licensing Guide
notebook
notebook
Default Open Energy Ontology
notebook notebook
notebook
Default Open Licensing Course
notebook
notebook
Data Structure UML- Description and Plotting
notebook
notebook
Data Structure, Other Topics UML- Plotting a Germany Model
notebook
notebook
Data Structure UML- Plotting a Scenario for Brandenburg and Berlin
notebook
notebook
Upload/Download Upload csv data to a new table on the OEP using the oedialect
notebook
notebook
Upload/Download, Data Structure oedialect - Table Creation and OEP Upload with an SQLAlchemy Dialect
notebook
notebook