Wednesday, 9 September 2015

World Bank Indicators: collect and process them in Google Sheet

Hey guys!

I recently found myself in having to process some statistics data about countries performances...
Actually, I'm looking to expat and found this could be an interisting method for picking up a destination.

So what have I found?
World Bank is giving us loads of free data to play with, about countries:

  • GDP, 
  • electricity access, 
  • health,
  • education,
  • etc.

I thought: why don't load a bunch of these data in a sheet, set some filters and see what could be my best place to be?

So here we go, you can download it here: https://docs.google.com/spreadsheets/d/1TyI-98fVfl1BsVGM0t6b6V65WysPulW8Z2zUsYTul04

Follow the instructions on the spreadsheet.

One suggestion: the command inside the sheet for loading indicators will load about 13-15 thousands of them!!!
Use the World Bank web page for finding indicators could be easier: http://data.worldbank.org/
It must be the last bit of an indicator web link, i.e. for GDP
Web link: http://data.worldbank.org/indicator/NY.GDP.MKTP.CD
Indicator: NY.GDP.MKTP.CD

Authorization are for running some Google Apps Script code.
If you are interested in the code, follow this link: http://pavatechpit.blogspot.it/2015/09/world-bank-xml-service-and-google-apps.html

Also, don't forget World Bank data is available on the Google Public Data Explorer project: http://www.google.com/publicdata/explore?ds=d5bncppjof8f9_&hl=en&dl=en

No comments:

Post a Comment