Tools for parsing annual school report card data from the state of Illinois
Most of these dependencies are installed by default
sudo apt-get install postgresql
pip install csvkit
pip install xlsx2csv
Most of these dependencies are installed by default
brew install postgresql
pip install csvkit
pip install xlsx2csv
You will need to run createdb schools to initialize the postgres database.
Running make database will import the data into
normalized tables in a postgresql database.
Right now, the database scripts only fully process the school-level data that appears in all 22 years of data. These include:
- ACT Scores
- Demography and enrollment
- Time spent on subject
- Class sizes, by grade
- School level characteristics like parent involvement, truancy, and graduation rate.
If you just wish to download the data without importing it into a database, run make csv. It will:
- Download ISBE report card data from 1997-2015
- Convert the fixed width files to csv format, with year-over-year normalized column names