Using LOAD CSV in the Real World | Nicole White, Data Scientist, Neo4j
Why Stack Overflow recommends it
Stack Overflow users link it when they are following the tutorial to load CSV data into Neo4j and hit questions about modeling, null values, or file paths.
Recommended by 0 people across 0 different months, 2016 to 2020.
What it is
A 2015 Neo4j webinar where data scientist Nicole White walks through importing a real CSV of bank consumer complaints into Neo4j. It covers cleaning the file, sketching a graph data model, writing Cypher LOAD CSV queries and running the import.
What people said
Cites Timothy Lombard · 2016-04 · Stack Overflow · on “cypher statement returns (no changes, no rows)”
I've watched Nicole White's awesome youtube “ Using LOAD CSV in the Real World [this video] ” and decided to re-create the neo4j data using the same method. I’ve cloned her git repo on this subject and have been working this example on the community version of neo4j on my Mac. I’m stepping thru the load.cql file one command at a time pasting each command into the command window. Things are going pretty good- I’ve got a bunch of nodes created. To deal with null values for sub_products and sub_issues in the master file, I created two other csv files: sub_issues.csv and sub_products.csv as described in the video. But when I try reading ether these files, I get "(no changes, no rows)” somehow I get t
Cites Monica Heddneck · 2016-04 · Stack Overflow · on “When to use a Property as opposed to a Label in Neo4j?”
I am going over this [this video] , "Using LOAD CSV in the Real World". The tutorial shows how to take a CSV, where each row is a complaint made against some bank, and model it as a Neo4j dictionary. When doing so, the narrator sets Properties on the Complaint node: CREATE (complaint:Complaint {id: line.`Complaint ID`}) SET complaint.year= TOINT(date[2]), complaint.month= TOINT(date[0]), complaint.day = TOINT(date[1]) I'm confused about a small point -- what makes this date information more of a 'Property' than a Label? Could this be modeled instead where the node has this information encapsulated as Labels instead of Properties? At what point do you need one of these and not the other?
Cites Dhiraj · 2017-03 · Stack Overflow · on “Errors while using `appendCypher()` in RNeo4j”
I am trying to create a graph database in R using the RNeo4j package. Basically what @Nicloe White has shown here [this video] is what I am trying to achieve entirely through the RStudio IDE. I have read in the data [LINK] into R and done some basic housekeeping on the date fields by using the lubridate package. Thereafter I am following what Nicole has shown here [LINK] for the hflights dataset. This is the relevant code: query=" CREATE (complaint:Complaint {id: TOINT({ComplaintID})}) SET complaint.day = ({ComplaintDay}), complaint.month = ({ComplaintMonth}), complaint.year = ({ComplaintYear}) MERGE (company:Company {name:{CompanyName}}) MERGE (response:Response {name:{Companyresponsetoconsumer}
Cites Charlie_Oh · 2018-06 · Stack Overflow · on “LOAD CSV command keeps using old file: location, ignores command input”
I am using Community edition 3.0.5 on Windows 10 . I made multiple efforts to execute a LOAD CSV command before being told that such files cannot reside on an external drive. When I moved the file to users/user/ and tried to execute the LOAD CSV command I got the same message "Couldn't load the external resource at: file:/F:/Neo4j%20DBs/Data.gov%20Consumer%20Complaints/Consumer%20Complaints%20DB/import/Users/CharlieOh/Consumer_Complaints.csv" in spite of the fact the command I entered was "LOAD CSV WITH HEADERS FROM 'file:///Users/CharlieOh/Consumer_Complaints.csv' AS line WITH line LIMIT 1 RETURN line" I tried to locate the file neo4j.conf and could only find C:\Program Files (x86)\Neo4j Co
Cites prasys · 2020-09 · Stack Overflow · on “Neo4j Cannot merge node using null property value”
Problem Statement : I am trying to import the CSV data (will provide sample of it) into Neo4J I am trying to follow the tutorial from YouTube (by Neo4J - [this video] ) on trying to get it work. However, when I try to run the following query , it fails at Cannot merge node using null property value for customer_id (Failure when processing file '/Users/zuperduper/stuff.csv' on line 2.) Dataset There aren't any null in the fields , all of the fields are populated. customer_id,review_id,product_id,product_category,review_date 33620853,R1QRX00VPUAA1G,B00A7W0VLY,Baby,2014-10-23 40919284,R1SZE4TH7QPXG6,B00NGV8RUU,Baby,2014-10-18 36567020,R2NST8F25WDOG2,B00LIRJ2NU,Baby,2014-10-15 Cypher Code // CREATE U