Neo4j-admin import with some missing values

In a CSV file I'm loading into Neo4j, a float type column has numbers in some rows, and "NA" in some other rows. This of course results in an error when importing: "Not a number".

I would still like to import this, but with the float stored as a NaN, or omit the property entirely. How can I do this?

I'd preprocess the csv files e.g. using awk to replace NA with an empty value. python - Find part of a string in CSV and replace whole cell with new entry? - Stack Overflow contains some hints for this.

1 Like