Neo4j Cypher - 使用 LOAD CSV 创建节点和设置标签 [英] Neo4j Cypher - creating nodes and setting labels with LOAD CSV

问题描述

我正在尝试使用 LOAD CSV 来创建节点，并将标签设置为来自 CSV 的值.那可能吗?我正在尝试类似的东西:

I’m trying to use LOAD CSV to create nodes with the labels being set to values from the CSV. Is that possible? I’m trying something like:

LOAD CSV WITH HEADERS FROM 'file:///testfile.csv' AS line
CREATE (x:line.label)

...但我收到无效的语法错误.有没有办法做到这一点?

...but I get an invalid syntax error. Is there any way to do this?

推荐答案

bcpence,

首先，使用 Java 批量导入应用程序很容易做到，而且编写起来也不难.请参阅此批处理插入器示例.您可以使用 opencsv 来读取您的 CSV 文件.

First off, this is pretty easy to do with a Java batch import application, and they aren't hard to write. See this batch inserter example. You can use opencsv to read your CSV file.

如果您更愿意坚持使用 Cypher，并且您有一组有限的标签可供使用，那么您可以执行以下操作:

If you would rather stick with Cypher, and if you have a finite set of labels to work with, then you could do something like this:

USING PERIODIC COMMIT 1000
LOAD CSV WITH HEADERS FROM 'file:///testfile.csv' AS LINE
CREATE (n:load {lab:line.label, prop:line.prop});

CREATE INDEX ON :load(lab);

MATCH (n:load {lab:'label1'})
SET n:label1
REMOVE n:load
REMOVE n.lab;

MATCH (n:load {lab:'label2'})
SET n:label2
REMOVE n:load
REMOVE n.lab;

恩惠与平安，

吉姆

这篇关于Neo4j Cypher - 使用 LOAD CSV 创建节点和设置标签的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！