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