Andrej Warkentin - Visualizing FragDenStaat.de





The interactive transcript could not be loaded.


Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jun 1, 2016

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.


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.


The results of my work so far.

Materials available here: https://github.com/awakenting/fds-sta...

Comments are turned off
When autoplay is enabled, a suggested video will automatically play next.

Up next

to add this to Watch Later

Add to

Loading playlists...