nicolewhite / neo4j-complaints Goto Github PK

The tutorial on "Using LOAD CSV in the Real World" was very informative even though it was made back in 2015.
As more and more people start learning Neo4j, I think they would try to follow this example to import csv into graph.
But the TOINT and UPPER functions were depricated long back and it would be great if they were replaced with their new counterparts so people could follow this example with ease.

Hi Nicole,
I love your video, it has been a huge help in prepping me for using Neo4J at my new job. I have found it near impossible to upload the downloaded csv file from my computer onto Neo4J Desktop, but I have had success with:

LOAD CSV WITH HEADERS FROM
"https://data.consumerfinance.gov/api/views/s6ew-h6mp/rows.csv?accessType=DOWNLOAD" AS line

Since I am unable to go in directly to take out columns with empty values, do you know of a solution using only Cypher?

I also already changed the MERGE line for response to "Company response to consumer."

Any help is appreciated! Thank you

Hello, files subissues.csv and subproducts.csv are missing. Where I can find them. In addition, the cql crashes with:

localhost:~/Servers/neo4j-community-2.2.2/bin$ neo4j-shell -host 127.0.0.1 -file ~/Projects/recommendation-engine/neo4j-complaints/LOAD_CSV.cql > ~/Projects/recommendation-engine/neo4j-complaints/result.log
ERROR (-v for expanded information):
QueryExecutionKernelException: Cannot merge node using null property value for name

Any idea, how to debug this?
Thanks in advance

The column name in the dataset is no longer called Company response, but rather Company response to consumer.

This must be changed in the script, or a null reference exception is encountered with the merge statement.