Analyse Government Expenditure on Education by Level

Today I looked into education expenditure with World Bank data on Google BigQuery.

The dataset can be queried using SQL through either UI or one of the client libraries for bigquery API. I used bigrquery package.

While extracting the data is rather simple, cleaning this particular dataset proofed to be the most time-consuming part, with countries missing records in certain years as well as expenditure types.

To keep it simple, I filtered for countries with at least 5 years of records, grouped anything other than primary/secondary/tertiary eduction (such as pre-primary or post-secondary vocational etc) into others, and viewed their mix across 2008 to 2014 which are the latest records available.

Image for post
Image for post

We can see:

  • Some African and Latin American countries such as Togo, Uganda, Guatemala, had their biggest portion of education budget on primary education
  • Places like Singapore, HK, Guinea, Austria etc topped the tertiary expenditure%
  • Governments like Netherlands and New Zealand have rather balanced split between primary/secondary and tertiary

This is #day64 of my #100dayprojects on data science and visual storytelling. Full code on my github. Thanks for reading. If you like it, please share it. Suggestions of new topics and feedbacks are always welcomed.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store