Skip to content

datamade/ipeds-db

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 

Repository files navigation

ipeds-db

Use the Makefile to build a Postgres DB from IPEDS Access files.

Currently, it uses the 2014-15 Provisional data from https://nces.ed.gov/ipeds/Section/accessdatabase/

Requirements

  • posix operating system (linux or mac os, that sort of thing)
  • mdbtools
  • python
  • csvkit
  • postgres
  • wget
  • make

On Ubuntu, install requirements like

sudo apt-get install mdbtools postgres
pip install csvkit

On Mac OS X, install requirements like

brew install mdbtools postgres wget python
pip install csvkit

To use

make
make clean

Running the MakeFile generates a PSQL database called ipeds. You can query this database however you like, or you can use the ipeds-csv repository to create a spreadsheet of college data, importable to the College Matching site.

Copyright

Copyright (c) 2017 DataMade. Released under the MIT License.

About

Build a Postgres DB from IPEDS Access files

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published