Neo4j-admin import with some missing values

[Spaxe]

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_armbrust]

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-wit... contains some hints for this.