All information related to the LOAD CSV meetup / webinar.
Switch branches/tags
Nothing to show
Clone or download
Permalink
Failed to load latest commit information.
.gitignore Update queries and switch to .cql. Nov 20, 2014
LICENSE Initial commit Nov 11, 2014
README.md Update README.md Jun 30, 2015
load.cql Check that properties are not null Oct 21, 2015
query.cql Updates: Jun 20, 2015

README.md

consumer_complaints

This code accompanies the webinar Using LOAD CSV in the Real World.

Setup

  • Download Consumer_Complaints.csv here. Note that your .csv file might have more rows than mine did; they appear to update the data regularly.

  • Find the arrows tool here.

  • Sublime Text 2 (the editor used in the webinar) along with the Cypher plugin.

Import

  • Change line 1 of load.cql to point to the location of your Consumer_Complaints.csv file.

    • OSX and Unix: file:///path/to/Consumer_Complaints.csv
    • Windows: file:C:/path/to/Consumer_Complaints.csv
  • Send load.cql to the neo4j-shell: ./bin/neo4j-shell -file load.cql

Important Note that this import was done on a 16GB machine. If you have less RAM and particularly if you are on Windows, please see these blog posts:

Also note that in the original webinar, I split Consumer_Complaints.csv into separate files to deal with rows with empty strings. Since then, I've modified the script to only use Consumer_Complaints.csv but with empty strings filtered out for the subissues and subproducts:

FROM {FILEPATH} AS line
WITH line WHERE line.`Sub-issue` <> ''
FROM {FILEPATH} AS line
WITH line WHERE line.`Sub-product` <> ''

Query

Run all the example queries:

./bin/neo4j-shell -file query.cql