Analyse Government Expenditure on Education by Level

Hannah Yan Han
Oct 5, 2017 · 1 min read

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.

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.

Hannah Yan Han

Written by

#100daysproject on data science and visual storytelling ✈️🗺️

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade