How regional is the coverage in daily newspapers?

An Analysis and Visualization with Pandas and Tableau

Map of Austria showing how many news articles in the regional newspapers dealt with the respective localities and towns. / Graphic by the author

The data

I have 217,595 contributions distributed among the following 15 publishers:

The analysis

The above chart shows on a map of Austria how many news articles in the regional newspapers dealt with the respective towns and cities. The color-coding indicates in which newspaper the article was published.

The results for regional media

In the chart at the beginning of the article, the federal state newspapers Oberösterreichische Nachrichten, Niederösterreichische Nachrichten, Salzburger Nachrichten, Tiroler Tageszeitung, Kleine Zeitung and Vorarlberg Online are shown together. At first glance, it is noticeable that Oberösterreichische Nachrichten, Niederösterreichische Nachrichten, and Tiroler Tageszeitung have a strong connection to the respective federal province, whereas Kleine Zeitung is distributed over the entire federal territory. The Salzburger Nachrichten and Vorarlberg Online are difficult to identify in the presentation. If we look at them individually, we also see a strong concentration on the federal state in the case of Vorarlberg Online.

Mentions per city for vol.at / Graphic by the author
Mentions per city for Salzburger Nachrichten / Graphic by the author

Results for national media

Let us now look at the national media. A joint presentation of these shows a distribution over the entire federal territory in each case.

Mentions per city for national media / Graphic by the author
Mentions per city for ORF / Graphic by the author
Mentions per city for Volksblatt / Graphic by the author

Development over time — animation

If you want to see the development over time in the period under consideration, then it makes sense to look at an animation based on the maps. For this purpose, I have taken the publication date of the articles, summarised them into days, and compiled the individual graphics into an animation.

The implementation

In the following, I would like to show how and with which tools the analysis and visualization were carried out. The following Python script with the help of the package “Pandas” is used to search for the place names and the data is converted into the desired form for import into Tableau.

Data after import in Tableau
Histogram for the mentions of cities / Graphic by the author
Tableau with the map / Graphic by the author

Conclusion

I showed how to prepare the data with a few lines of “Pandas code” and how to easily create the corresponding graphics and animations with the standard functions of “Tableau”. Concerning regionality, clear differences between the publishers were very easy to recognize based on the visualizations.

University of Applied Sciences Upper Austria / School of Informatics, Communications and Media http://www.stoeckl.ai/profil/