| 123456789101112131415161718192021222324 |
- 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)
|
