Neo4j-admin import with some missing values


(Spaxe) #1

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?


(Stefan Armbruster) #2

I'd preprocess the csv files e.g. using awk to replace NA with an empty value. https://stackoverflow.com/questions/41537084/find-part-of-a-string-in-csv-and-replace-whole-cell-with-new-entry contains some hints for this.