从包含三列的csv文件创建neo4j图

Question

我有一个csv文件，包含一些主题的生产者和消费者。e.g

producer,topic,consumer
PRODUCER-1,TOPIC-A,CONSUMER-1
PRODUCER-2,TOPIC-B,CONSUMER-2
PRODUCER-1,TOPIC-C,CONSUMER-3
PRODUCER-1,TOPIC-D,CONSUMER-1
PRODUCER-2,TOPIC-E,CONSUMER-3

我试图用齐柏林飞艇笔记本中的neo4j绘制一个图形来实现这一点。我成功地加载了csv，如下所示，但无法通过主题工作获得显示生产者和消费者之间关系的发布图。

LOAD CSV FROM 'file:///data/pubsub.csv' AS row
WITH row[0] AS Producer, row[1] AS Topic, row[2] AS Consumer
RETURN Producer, Topic, Consumer

如果你能帮忙的话。提前感谢

Answer 1

首先尝试将数据集存储到Neo4j中，然后查询它.这将帮助您实现齐柏林飞艇的可视化。

LOAD CSV WITH HEADERS FROM 'file:///data/pubsub.csv' AS row
MERGE (p:Producer{id:row.producer})
MERGE (t:Topic{id:row.topic})
MERGE (c:Consumer{id:row.consumer})
MERGE (p)-[:PRODUCER]->(t)
MERGE (t)-[:CONSUMER]->(c)

现在，您已经将数据保存到图形中，您可以尝试在齐柏林飞艇中查询它：

MATCH p=()-->()
RETURN p