py2neo介绍

• 介绍

Py2neo是一个客户端库和工具包，用于从Python应用程序和命令行使用Neo4j（

Neo4j Graph Data Platform | Graph Database Management System

）。该库同时支持 Bolt 和 HTTP，并提供高级 API、OGM、管理工具、交互式控制台、Pygments 的 Cypher 词法分析器以及许多其他功能。

• 安装

pip install py2neo

注：Neo4j也需要安装，地址https://neo4j.com/

py2neo基本使用

• 启动Neo4j

• 连接代码

from py2neo import Graph, Node, Relationship
 
graph = Graph("http://localhost:7474//browser", name='neo4j', auth=("neo4j", "12345678"))
print(graph.run("show databases"))

基于xsls文件的demo

• demo效果

• xls文件内容

• sheet 结构

• “关系”sheet内容如下

• 下面的表格分别对应”
  
  恒山派
  
  “、”
  
  华山派
  
  “、”
  
  日月教
  
  “sheet中的内容（）

• demo依赖

pip install pandas
pip install openpyxl

Neo4j和py2neo也是需要的。

• demo主要代码块

import os

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


sheetNameList = [
    {'sheet':'恒山派',     'type':'Node'},
    {'sheet':'华山派',     'type':'Node'},
    {'sheet':'日月教',     'type':'Node'},
    {'sheet':'关系',       'type':'Relationship'},
]

def __init__(self, filename=None):
    self.filename = filename

    self.nodeList             = []
    self.relationshipList     = []

    self._loadfile()
    self._buildGraph()

 def _loadfile(self):
    if not os.path.exists(self.filename):
        print('_loadfile', 'file not exist')
        return False

    for sheetName in sheetNameList:
        sheetData = pd.read_excel(self.filename, index_col=None, comment='#', sheet_name=sheetName['sheet'])

        if sheetName['type'] == 'Node':
            keys=[]
            for index, row in sheetData.iterrows():
                if not row['title']:
                    continue
                keys.append(row['title'])
            
            keyval = dict(zip(keys, keys))
            node = Node(sheetName['sheet'], name=sheetName['sheet'], **keyval)
            self.nodeList.append(node)

            for index, row in sheetData.iterrows():
                if not row['title']:
                    continue
                subNode = Node(sheetName['sheet'], name=row['title'])
                self.nodeList.append(subNode)
                rel = Relationship(node, '属性', subNode)
                self.relationshipList.append(rel)

        elif sheetName['type'] == 'Relationship':
            startNode = None
            endNode   = None
            for index, row in sheetData.iterrows():
                if not row['from'] or not row['to']:
                    continue

                for node in self.nodeList:
                    if node['name'] == row['from']:
                        startNode = node
                    elif node['name'] == row['to']:
                        endNode   = node
                    else:
                        pass
                rel = Relationship(startNode, row['type'], endNode)
                self.relationshipList.append(rel)
        else:
            pass

def _buildGraph(self):
    graph = Graph("http://localhost:7474//browser", name='neo4j', auth=("neo4j", "12345678"))
    graph.delete_all()

    for node in self.nodeList:
        graph.create(node)

    for rel in self.relationshipList:
        graph.merge(rel)
        pass

    graph.begin()

参考

• 
  The Py2neo Handbook — py2neo 2021.1
  

• 
  Python创建知识图谱_python知识图谱 md_趋吉避凶的博客-CSDN博客
  

• 
  Python neo4j建立知识图谱，药品知识图谱，neo4j知识图谱，知识图谱的建立过程，智能用药知识图谱，智能问诊必备知识图谱_医学小达人的博客-CSDN博客
  

• 
  Neo4j简介及Py2Neo的用法_neo4j py2neo_yayun_kg的博客-CSDN博客
  

• 
  pandas处理Excel基本方法_<编程路上>的博客-CSDN博客