PYTHON::知识图谱

周小董 2020-06-16

仅当作记录

import py2neo
from py2neo import Graph,Node,Relationship
import pandas as pd

graph = Graph("http://localhost:7474")

graph = Graph("http://localhost:7474",uername="neo4j",password="lh990816")

graph.delete_all()#清空所有内容

data = pd.read_excel("D:/data.xlsx")
print(data.shape)
datalable = list(data)
data_row = len(data)
print(data_row)

# print(data.columns[1])
# b = Node(‘Person‘,name=‘yingying‘)
# graph.create(b)

datalable2 = len(datalable)
print(datalable2)
for i in range(0,data_row):
    print(data.loc[i][datalable[1]])
    Nodee = Node(‘impentity‘,name = str(data.loc[i][datalable[1]]))
    graph.create(Nodee)
    for j in range(2,datalable2):
        print(data.loc[i][j])
        print(data.columns[j])
        # if(data.loc[i][j]==data.loc[i-1][j]):
        #     selector = py2neo.matching.NodeMatcher(graph)
        #     ndoe = selector.match(‘entity‘).where(‘_.name = "data.loc[i][j]"‘).first()
        # else:
        node = Node(‘entity‘,name = str(data.loc[i][j]))
        graph.create(node)
        graph.create(Relationship(Nodee,data.columns[j],node))
#print(data.head())

相关推荐