import pandas as pd

from py2neo import Node, Graph, Relationship

graph = Graph('http://192.168.1.202:7474/', user='neo4j', password='password', name="neo4j")
graph.delete_all()

io = '''数据表结构.xlsx'''

df = pd.read_excel(io, sheet_name='Sheet1', header=[0])

df.字段描述.fillna(value='', inplace=True)
df['字段'] = df.字段.str.upper()

for row in df.itertuples():
    try:
        start_node = Node("表", name=row.表, c_name=row.表名)
        end_node   = Node("列", name=row.字段, type=row.字段类型, detail=row.字段描述)
        relation   = Relationship(start_node, 'has', end_node)
        graph.merge(start_node, "表", "name")
        graph.merge(end_node, "列", "name")
        graph.merge(relation, "值", "名称")
    except:
        print(row)