College Scorecard API Tutorial

Many researchers studying American higher education want to work with the College Scorecard dataset, which was created under the Obama administration and contains detailed information about college quality, affordability, and student outcomes.

It is possible to download the entire dataset, but the file is large and difficult to navigate, and for most researchers, a more efficient strategy is to learn how to query the database for just the data that you are interested in.

In the video below, I explain how to use Python to submit an API query to the server that hosts the College Scorecard data, and show how to convert the JSON output into a Pandas dataframe or Excel spreadsheet. I also demonstrate a few data analysis and visualization tasks.

The video assumes a very basic understanding of Python.