Importing a CSV doc "Cannot merge the following node because of null property value for 'Name': " error

Neo4j Graph Platform Import / Export
1

Hello Neo4J community,

I am very new to Neo4j and am struggling with an error.
I am trying to import a CSV file which has NULL values.
When I enter the Cypher, I get this error: Cannot merge the following node because of null property value for 'Name':

How do I fix this?

Here is the Cypher:

LOAD CSV WITH HEADERS from 'file:///tree.csv' as row with row where row.company is not null
MERGE (b:country {Name:row.country})
MERGE (a:company {Name:row.company})
MERGE (c:plot_id {Name:row.plot_id})
MERGE (d:creation_date {Name:row.creation_date})
MERGE (e:tree_id {Name:row.tree_id})
MERGE (f:tree_height {Name:row.tree_height})
MERGE (g:crown_depth {Name:row.crown_depth})
MERGE (h:trunk_structure {Name:row.trunk_structure})
MERGE (i:single_trunk_circumference {Name:row.single_trunk_circumference})
MERGE (j:branch_number {Name:row.branch_number})
MERGE (k:multiple_trunk_diameter {Name:row.multiple_trunk_diameter})
MERGE (l:multiple_trunk_circumference {Name:row.multiple_trunk_circumference})
MERGE (a) -[:TO]-> (b)
MERGE (b) -[:TO]-> (c)
MERGE (c) -[:TO]-> (d)
MERGE (d) -[:TO]-> (e)
MERGE (e) -[:TO]-> (f)
MERGE (f) -[:TO]-> (g)
MERGE (g) -[:TO]-> (h)
MERGE (h) -[:TO]-> (i)
MERGE (j) -[:TO]-> (k)

Screen Shot 2022-02-07 at 5.25.11 PM
Screen Shot 2022-02-07 at 5.25.11 PM1708×372 60.3 KB

Thank you!

2

Alternatively, I have tried doing this, which hasn't worked either.

LOAD CSV WITH HEADERS from 'file:///tree.csv' as row with row where row.single_trunk_circumference is not null AND where row.branch_number is not null AND where row.multiple_trunk_diameter is not null AND where row.multiple_trunk_circumference is not null

MERGE (b:country {Name:row.country})

MERGE (a:company {Name:row.company})

MERGE (c:plot_id {Name:row.plot_id})

MERGE (d:creation_date {Name:row.creation_date})

MERGE (e:tree_id {Name:row.tree_id})

MERGE (f:tree_height {Name:row.tree_height})

MERGE (g:crown_depth {Name:row.crown_depth})

MERGE (h:trunk_structure {Name:row.trunk_structure})

MERGE (i:single_trunk_circumference {Name:row.single_trunk_circumference})

MERGE (j:branch_number {Name:row.branch_number})

MERGE (k:multiple_trunk_diameter {Name:row.multiple_trunk_diameter})

MERGE (l:multiple_trunk_circumference {Name:row.multiple_trunk_circumference})

MERGE (a) -[:TO]-> (b)

MERGE (b) -[:TO]-> (c)

MERGE (c) -[:TO]-> (d)

MERGE (d) -[:TO]-> (e)

MERGE (e) -[:TO]-> (f)

MERGE (f) -[:TO]-> (g)

MERGE (g) -[:TO]-> (h)

MERGE (h) -[:TO]-> (i)

MERGE (j) -[:TO]-> (k)

4

Try removing the WHERE clause before the AND clauses so you have WHERE row.a is not null AND row.b is not null AND row.c is not null, etcs

Did your statement run without error with that syntax?

5

Thank you for your answer.
I have removed the ANDs, but it does not run anything... Do you have any ideas why this is?

Uploading: Screen Shot 2022-02-08 at 3.36.45 PM.png...

6

The screenshot did not render. Also, can you provide the test data, or is it proprietary?

7

This is part of the data, (I can't show more than this):

Screen Shot 2022-02-08 at 4.03.37 PM
Screen Shot 2022-02-08 at 4.03.37 PM1980×872 212 KB

Thank you for your help

8

Screen Shot 2022-02-08 at 4.05.36 PM
Screen Shot 2022-02-08 at 4.05.36 PM1778×1208 212 KB

9

The MERGE clause will not create new nodes after you have run the script once, so no changes. Try deleting everything and running it.

Also, what is the warning the browser is giving you?

10

Screen Shot 2022-02-08 at 4.26.00 PM
Screen Shot 2022-02-08 at 4.26.00 PM1806×1378 244 KB

I've tried it but it is not working again.
Additionally, I check if the csv was properly copied in the imported file, which it is

11

I just noticed in the records you are showing, that no row has all four attributes as not null, so the WHERE clause will be false for the rows shown (1-26).

Perhaps the data model is not correct. Are each column supposed to be a separate entity, or are some attributes of an aggregate entity, as "Tree?" The attributes in columns F-L would be attributes of a Tree node that has id = tree_id. No?

12

Yes that is correct. No row has all four attributes as not null.
You are also correct. Each columns are attributes of an entity Tree (of individual tree_id).

Does that mean that I am supposed to use OR ?
Just as a reminder, I am required to represent everything from the basis of the company (which company owns which tree and all their attributes).

13

Seems like you want something like the following:

Screen Shot 2022-02-08 at 11.01.02 AM
Screen Shot 2022-02-08 at 11.01.02 AM1540×286 30.8 KB

If true, you don't want the merges for f-l, as those are attributes you sent on node e.

Also, node d is not need, as creation_date is a property of another node, plot or tree?

14

This is exactly what I need.
Once I have this, how do I import all the attributes (from f to l) of the tree in the node? As in, how to I set multiple labels on the tree?

I would want Company -> Country -> Tree_ID (with all the labels: creation date, height etc.).

Thank you very much for your time.

15

Is the plot_id an attribute of a tree, or is plot an entity itself that has multiple trees associated to it?

16

I am not sure what it is and decided I will not use it in the graph.

17

I have been looking up how to put multiple label from a csv document, but cannot find anything. Do you have any ideas?

18 
Try this. Use COALESCE to handle null values.
LOAD CSV WITH HEADERS from 'file:///tree.csv' as row 

MERGE (b:Country {Name:row.country})

MERGE (a:Company {Name:row.company})

MERGE (c:Plot {Name:row.plot_id, creationDate:row.creation_date}})

MERGE (e:Tree{Name:row.tree_id, height:row.tree_height, crownDepth:row.crown_depth, trunkStructure: COALESCE(row.trunk_structure, 'NA'), singleTrunkCircumference:COALESCE(row.single_trunk_circumference, 'NA'), branchNumber: COALESCE(row.branch_number, 'NA'), multipleTrunkDiameter: COALESCE(ow.multiple_trunk_diameter, 'NA'), multipleTrunkCircumference: COALESCE(row.multiple_trunk_circumference, 'NA')})

MERGE (b)-[:COMPANY]->(a)
MERGE (a)-[:PLOT]->(c)
MERGE (c)-[:TREE]->(e)
1 Like
19

@ameyasoft provide a solution. I would just recommend using HAS_COMPANY, HAS_PLOT, and HAS_TREE for the relationship types. Also, eliminate the Plot node if you don't want it; merging Company to Tree directly.

1 Like
20

Thank you both really much for your help.

Here is the Cypher used:
LOAD CSV WITH HEADERS from 'file:///tree.csv' as row with row where row.tree_id is not null

MERGE (b:Country {Name:row.country})

MERGE (a:Company {Name:row.company})

MERGE (c:TREE {Name:row.tree_id, date:row.creation_date, height:row.tree_height, crownDepth:row.crown_depth, trunkStructure: COALESCE(row.trunk_structure, 'NA'), singleTrunkCircumference:COALESCE(row.single_trunk_circumference, 'NA'), branchNumber: COALESCE(row.branch_number, 'NA'), multipleTrunkDiameter: COALESCE(row.multiple_trunk_diameter, 'NA'), multipleTrunkCircumference: COALESCE(row.multiple_trunk_circumference, 'NA')})

MERGE (b)-[:HAS_COMPANY]->(a)
MERGE (c)-[:HAS_COUNTRY]->(b)

Screen Shot 2022-02-08 at 7.12.33 PM
Screen Shot 2022-02-08 at 7.12.33 PM1920×1063 130 KB

It worked to some extent. However, it only shows the results for one company (there are two in total).
Any suggestions?

21

The relationships seem odd to me. I read it as stating a 'tree has a country and a country has a company.' Is it not more like 'a country has a company and a company has a tree?'

The query looks correct. Does your data have a second country in the csv file? If so, is the country on all rows that have tree_id that is null, so it is getting filtered out?