Skip to content

Instantly share code, notes, and snippets.

@hrwgc

hrwgc/kenya_bank_join_about.md Secret

Created June 29, 2012 19:14
Show Gist options
  • Save hrwgc/7a2999057bdf51fecf7b to your computer and use it in GitHub Desktop.
Save hrwgc/7a2999057bdf51fecf7b to your computer and use it in GitHub Desktop.
Download ZIP
About the Join - Kenya Bank Education Databases
Raw
kenya_bank_join_about.md

Final Numbers

  • 3,235 schools matched to location information from 2007 and KCSE exam performance information from 2010
  • Approximately 35,000 unique records (student performance by gender and grade each had separate rows, up to 15+ per school) condensed into 3,235 rows, with records transposed into columns.

Starting Point:

Kenya Grades Database

  • 5,946 unique schools reporting grades for 2010
  • 64,949 unique rows needing to be joined
  • school_name column contains 7972 unique entries total;
  • 5,946 unique schools reporting grades for 2010
  • counties, districts, across two databases not necessarily compatible due to changes since 2007, when schools database was created.
  • unique identifying school codes, such as "MOE code" and "knec code", in both databases, but no code is in both databases.

Resources

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment