My csv file has large amount of data. Under the header there are same names,values and contains empty cells. How can i clear this? Thanks in advance.
What would you like to βclear?β Do you want to skip rows the have any empty cells?
i want nodes excluding the null values
This should skip any row that has at least one missing value.
load csv with headers from "file:///import.csv" as row
with row as header_row
limit 1
load csv with headers from "file:///import.csv" as row
with header_row, row
skip 1
where any(i in keys(header_row) where row[i] is null)
create(n{name:row.name, title:row.title})
1 Like