Skip to content

Latest commit

 

History

History
64 lines (36 loc) · 2.48 KB

README.md

File metadata and controls

64 lines (36 loc) · 2.48 KB
Raw

📊 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.

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!