neo4j导入数据

1.从网络文件导入

# 导入节点
WITH "https://github.com/neo4j-graph-analytices/book/raw/master/data" AS base 
WITH base + "transport-nodes.csv" AS uri
LOAD CSV WITH HEADERS FROM uri AS row
MERGE (place:Place {id:row.id})
SET place.latitude = toFloat(row.latitude),
    place.longitude = toFloat(row.longitude),
    place.population = toInteger(row.population)

# 导入关系
WITH "https://github.com/neo4j-graph-analytices/book/raw/master/data" AS base 
WITH base + "transport-relationships.csv" AS uri
LOAD CSV WITH HEADERS FROM uri AS row
MATCH (origin:Place{id:row.src})
MATCH (destination:Place{id:row.dst})
MERGE (origin)-[:EROAD {distance: toInteger(row.cost)}]->(destination)

2.从本地csv文件导入

Github国内可能无法访问，可以将文件下载到本地，再复制到neo4j安装目录的import文件夹下

数据地址：book/data at master · neo4j-graph-analytics/book · GitHub

 

 在console中导入数据：

注意：文件路径是file:///xxx 

# 导入节点
LOAD CSV WITH HEADERS  FROM "file:///transport-nodes.csv" AS line
MERGE (place:Place{id:line.id})

# 导入关系
LOAD CSV WITH HEADERS  FROM "file:///transport-relationships.csv" AS line
MATCH (origin:Place{id:line.src})
MATCH (destination:Place{id:line.dst})
MERGE (origin)-[:EROAD {distance: toInteger(line.cost)}]->(destination)

点击console右边关系“EROAL”即可查看导入的数据

 点击节点名称或关系名称，即可调整图形的颜色、线条粗细、显示的属性值等