📊 GIRLS JUST WANNA HAVE SOME STATS

Welcome to today's workshop! This page will guide you through the Destatis workshop at 37c3, Day 4.

Prerequisites

• This workshop requires beginner programming/data analysis skills: You should have an editor of your choise set up, and be able to do basic things like read in a csv file.
• The workshop materials use Python 3.

Preparation steps

Account registration for API access

• To access the Destatis API, you'll need to registeer an account.
  • Go to Genesis-Online Registration.
  • Click Registrieren and follow the instructions.

Repository download

• Clone or download this repository to your local machine.
  • Git Clone: Use git clone. Learn how to do this here.
  • GitHub Download: Go to the GitHub page, click the green "Code" button, then "Download ZIP".
  • If unfamiliar with Git, simply ensure you download and extract the files to your computer.

Configuration file setup

• Duplicate the config/login_example.yaml file.
• Rename the duplicate to config/login.yaml.
• Enter your Destatis login credentials in this file.

Environment and Package Installation

• (Optional) Set up a virtual environment for package management.
• Install required packages using pip: Run pip install -r requirements.txt in your terminal or command prompt.

Try out

Try out the notebook to look at pay by gender!

• Notebook Name: get_data.ipynb
• Open and run the notebook to try out the workshop material. This notebook is designed to guide you through the process of fetching data using the API.

Explore 🚀

Discover data attributes in Destatis:

• Use the Destatis Online Search to look for specific attributes, like geschlecht.

  • You can get lists of tables directly from the notebook, but the website is more user-friendly for getting an overview.
  • This search will provide an overview of tables containing the searched variable. Note down the table ID numbers for API interactions.

• The API handbook will be your friend.

Notes

• Compatibility: This code has been tested using Python version 3.10.9.
• For any questions, clarifications, or feedback regarding the workshop content, feel free to raise your hand or contact me afterwards!