cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! Site migration is underway. Phase 2: migrate recent content

Client Error: null property value

Reuben
Graph Buddy
ClientError: {code: Neo.ClientError.Statement.SemanticError} {message: Cannot merge the following node because of null property value for 'scope': (:scope {scope: null})}

"LOAD CSV WITH HEADERS FROM $path AS row "

"MERGE (sc:scope {scope: row.Scope_name}) "
"SET sc.Chinese_name = row.Chinese, sc.English_name = row.English "

Please, what could I be missing?

#CSV #neo4J

1 ACCEPTED SOLUTION

Hi,

this is a quite annoying error in the beginning if you don't know it but quite easy to solve. It means that there is an entry in your csv file that is null. Does your csv file maybe look something like this:

Chinese,English
name1,name2
name3,name4
,
,

i.e. there are additional empty lines at the bottom? Or maybe like this:

Chinese,English
name1,name2
name3,name4
,name5
name6,

i.e. there are some empty "cells" somewhere? Then this error occurs. Tipp: Don't look at the file in Excel, rather look at it in a text editor (e.g. Notepad++) because you won't see the empty lines in Excel.

In the first step have a look at your files and clean them up. There should be no empty lines at the bottom. But if there are cases where empty cells are ok and you specifically don't want to fill them in your csv file, you can use the coalesce function:

SET sc.Chinese_name = COALESCE(row.Chinese,"No Chinese Name"), sc.English_name = COALESCE(row.English,"No English Name")

It will then replace any null value it encounters in a column with the value that you give as the second argument (here e.g. "No Chinese Name").

Regards,
Elena

View solution in original post

3 REPLIES 3

Hi,

this is a quite annoying error in the beginning if you don't know it but quite easy to solve. It means that there is an entry in your csv file that is null. Does your csv file maybe look something like this:

Chinese,English
name1,name2
name3,name4
,
,

i.e. there are additional empty lines at the bottom? Or maybe like this:

Chinese,English
name1,name2
name3,name4
,name5
name6,

i.e. there are some empty "cells" somewhere? Then this error occurs. Tipp: Don't look at the file in Excel, rather look at it in a text editor (e.g. Notepad++) because you won't see the empty lines in Excel.

In the first step have a look at your files and clean them up. There should be no empty lines at the bottom. But if there are cases where empty cells are ok and you specifically don't want to fill them in your csv file, you can use the coalesce function:

SET sc.Chinese_name = COALESCE(row.Chinese,"No Chinese Name"), sc.English_name = COALESCE(row.English,"No English Name")

It will then replace any null value it encounters in a column with the value that you give as the second argument (here e.g. "No Chinese Name").

Regards,
Elena

Thanks, Elena for the explanation.

Reuben
Graph Buddy

#For others who may face a similar problem

*Another approach is to remove the commas at the endings of the words in the columns (Dataframe) during data cleaning:

#removing comma at the end of the words


df["Column_name"]=df['Column_name'].str.rstrip(',')