Countries with the most mentions

Here are the countries ranked by how many post titles mention them.

Countries with the highest average scores

How about which countries have the highest average score per post? These countries are not just popular, but posts about them are well-liked as well.

How I compiled the lists

I didn't do anything fancy here. If a post title has a word which matches the name of a country, I assume the post is related to that country. That causes some difficulties when there are homonyms, such as "Jordan" appearing in a post which is actually not talking about the country, but instead about Michael Jordan the computer scientist (or someone else with that name). Here is my whole mapping.

Instead of running this analysis on my own computer, I used Google BigQuery to find the names of countries in post titles. If you would like to learn how to run similar queries yourself, check out this great introduction to BigQuery analysis of Reddit.

The only fancy thing I did do is allowing multiple words to refer to the same country. For instance for "Germany" and "Japan", I also accept the demonyms "German" and "Japanese" in as well. For multi-word country names I also wanted to count abbreviations ("US", "U.S.", "USA", "U.S.A."). My query already removes dots, so it was enough to have "US", "USA" in the list. To prevent "US" from also matching "us", I decided to stick with case sensitivity.

I decided not to include "English" as a word for UK, because it more commonly refers to the language. Since it was ambiguous what "Korea" appearing along would refer to, I didn't count that as referring to anything unless it was preceded by "North" or "South".

By Bemmu, the guy behind Candy Japan.