datamade/ipeds-db

Name: ipeds-db

Owner: datamade

Description: Build a Postgres DB from IPEDS Access files

Created: 2017-01-17 16:59:44.0

Updated: 2018-02-22 23:54:11.0

Pushed: 2017-06-02 19:01:09.0

Homepage: null

Size: 5

Language: Makefile

GitHub Committers

User	Most Recent Commit	# Commits

Other Committers

User	Email	Most Recent Commit	# Commits

README

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

 apt-get install mdbtools postgres
install csvkit

On Mac OS X, install requirements like

 install mdbtools postgres wget python
install csvkit

To use

 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.