导入CSV文件中的Neo4j

Question

在使用此命令 LOAD CSV FROM "file:///artists.csv" AS line CREATE (:Artist { name: line.Name, year: toInt(line.Year)})

我得到 错误：Type mismatch: expected Any, Map, Node or Relationship but was List<String> (line 2, column 25 (offset: 68)) "CREATE (:Artist { name: line.Name, year: toInt(line.Year)})"

CSV文件 "1","ABBA","1992" "2","Roxette","1986" "3","Europe","1979" "4","The Cardigans","1992"

Answer 1

您的CSV没有头，所以你可以按名称访问列，即当你这样做时：line.Name。

你必须列索引做到这一点：line[0]

干杯