flight_graph

A Neo4j graph database of flight data.

Create the DB

Data is located here. Select the pre-zipped checkbox and download. Unzip the file. Make sure you're pointing to the correct file name at line 8 of import.py.

Also download the lookup tables for UniqueCarrier and OriginAirportID. Save these as .csv, not .csv-. They should be called L_UNIQUE_CARRIERS.csv and L_AIRPORT_ID.csv.

python schema.py
python import.py
python import_lookups.py

To run the above scripts you will need to install the following python packages if you don't have them installed already.

pip install py2neo
pip install unicodecsv

Query

Watch Intro to Cypher with this dataset here. Queries are located in queries.