Who wants to live where?

After working for a while on a residential preferences project of the German SINUS milieus, I finally finished the analysis and am able to calculate not only the residence preference of the SINUS milieus but also the residence preference of any given subpopulation in Germany (I will write more about this in the next few

Continue reading Who wants to live where?

Merge R data frames with SQL

R provides many ways for selecting data from a data frame. You can use, e.g., [], logical functions and functions like subset. If you know SQL you might think that all this could be way easier if you could just use some of the SQL commands that you know. As I found on the Revolutionanalytics blog, there is

Continue reading Merge R data frames with SQL

Immersion: A people-centric view of your email life

Immersion by the MIT Media Lab is a view into your inbox that shows who you interact with via email over the years. Immersion is an invitation to dive into the history of your email life in a platform that offers you the safety of knowing that you can always delete your data. Just like a cubist

Continue reading Immersion: A people-centric view of your email life


After a long initial development, we are happy to publish the morgenstadtDB today. Tobias Hauck, a student of mine, and I developed the database to store all the information that was collected within the Morgenstadt CityInsights project in a structured way. The database is the fundament to analyze the collected data and present the data

Continue reading morgenstadtDB

%d bloggers like this: