Look Who it Was Random video

Andrej Warkentin - Visualizing FragDenStaat.de

432 views · Published 1 June 2016 · 26:28 · Indexed 25 October 2026

Channel: PyData · 2016 · Science & Technology

Watch on YouTube

PyData Berlin 2016

FragDenStaat.de is a website that helps people to make freedom of information requests in Germany. Starting in 2011, they collected over 12000 of these requests. Using pandas and matplotlib, I tried to bring life into this interesting data set.

Motivation

FragDenStaat.de offers an API with which you can scrape more than 12000 public freedom of information requests. Each request contains information about: when it was sent, to which public body and to which jurisdiction it was sent, how long it took the public body to complete the request, whether the request was successful and if not, why so. Visualizing all these aspects of the data set might lead to new insights about this transparency process.

Data preparation

How I scraped the data set and organized it using pandas.

Data visualization

How I visualized the data set using pandas and matplotlib.

Visualizations

The results of my work so far.

Materials available here: https://github.com/awakenting/fds-statistics 00:00 Welcome!
00:10 Help us add time stamps or captions to this video! See the description for details.

Want to help add timestamps to our YouTube videos to help with discoverability? Find out more here: https://github.com/numfocus/YouTubeVideoTimestamps

More from this channel