The Compleat Hangler

Oxford Open Data Day

For Open Data Hack Day in Oxford, Gili and I decided to play around with data from the International Broadband Pricing Study released last year by Google. We decided to look at mobile broadband prices around the world: in which countries can you obtain data on your mobile device for the least money, relative to your purchasing power in that country? The study collects information on consumer mobile plans sold by major carriers in each country, so we had to do some data aggregation first. Initially, we took all the available data plans in each country and took the average price per gigabyte. However, we noticed some significant outliers, which in turn led to some bizarrely high prices, such as $1200/GB for mobile data in Turkey! The final map shows the¬†cheapest possible price per gigabyte of mobile data. (Of course, there are problems with this approach, too; it’s probably not reflective of what the typical consumer is paying each month.) We divided the cases into quintiles, and colour-coded countries according to which price range they landed in. Countries for which no data was available are coloured grey. Click on the image (or here) for the interactive version, which might take a moment to load.

Mobile broadband prices

The results are perhaps not too surprising: the cheapest mobile broadband tends to be found in the developed world, especially Scandinavia and Central Europe. (The reverse pattern does not hold, though: there are plenty of developed countries, including the United States, where mobile broadband is not particularly cheap.) The most expensive countries are scattered around the world, but there is a definite concentration in Africa. The single most expensive country in the world is Cameroon, with the cheapest mobile data plan costing $81.26 per gigabyte! The (messy!) code is on GitHub here. Please feel free to get in touch with any questions, feedback, or suggestions.¬†Finally, you can check out some of the other participants’ projects here. Thanks to the organizers for arranging an excellent day of hacking!

Comments