datamade/ipeds-csv

Name: ipeds-csv

Owner: datamade

Description: Make file for generating a CSV for importing into the College Matching site.

Created: 2017-01-19 16:40:52.0

Updated: 2017-01-19 22:42:09.0

Pushed: 2017-06-02 18:53:02.0

Homepage: null

Size: 594

Language: Python

GitHub Committers

User	Most Recent Commit	# Commits

Other Committers

User	Email	Most Recent Commit	# Commits

README

ipeds-csv

Use this Makefile to generate a clean, decoded, sparkling CSV, which can be imported into the College Matching site.

Dependencies

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

On Ubuntu, install requirements like this:

 apt-get install postgres

On Mac OS X, install requirements like this:

 install postgres python

Getting Started

Before running this Makefile, you need a PostGres database with tables built from the Integrated Postsecondary Education Data System (IPEDS). Use the Makefile in ipeds-db to create your DB.

Usage

Run the Makefile! It queries the IPEDS database, generates a CSV, and finally decodes that CSV into a human-readable format. You can find the results in the build directory.

 all

Want something different? Clean out the build directory, and start over.

 clean

Find a usable, human-readable CSV document in /build/schools_processed.csv. This document provides the data for the College Matching site: move it into the /data/ directory of that repo.

Copyright

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