问题场景:
neo4j是学习知识图谱很好用的一个工具,在手动构建知识图谱时,可以通过python代码来实现读取excel或csv数据,并将数据导入neo4j库中。
数据示例:
代码示例:
# -*- coding: utf-8 -*-
from py2neo import Graph, Node, Relationship, NodeMatcher
import pandas as pd
graph = Graph('http://localhost:7474', username='neo4j', password='neo4j')
gjpath = './gj.xls'
gj = pd.read_excel(gjpath) #如果是csv文件则将read_excel改为read_csv
gjlabel = list(gj)
country = Node("世界各国", 标签="世界各国")
for i in range(0, len(gj)):
print(gj.loc[i][gjlabel[0]])
gjnode = Node("国家", 标签=str(gj.loc[i][gjlabel[0]]))
for l in gjlabel[1:]:
print(gj.loc[i][l])
gjnode[l] = str(gj.loc[i][l])
graph.create(Relationship(count