本小节示例neo4j的应用。
一、安装neo4j
windows安装 下载地址:
Neo4j Download Center - Neo4j Graph Data Platform
在安装成功后,会让修改密码,我直接将密码改为了7474。
neo4j的启动方法为neo4j.bat console
二、导入库并连接数据库
注意:auth中第二个参数为在第一步安装过程中配置的密码7474
from neo4j import GraphDatabase, basic_auth
driver = GraphDatabase.driver("bolt://localhost", auth=basic_auth("neo4j", "7474"))
session = driver.session()
三、导入关系数据
微博关注关系如图所示:
代码如下
# Insert data
insert_query = '''
UNWIND {pairs} as pair
MERGE (p1:Person {name:pair[0]})
MERGE (p2:Person {name:pair[1]})
MERGE (p1)-[:KNOWS]-(p2);
'''
data = [["Jim","Mike"],["Jim","Billy"],["Anna","Jim"],
["Anna","Mike"],["Sally","Anna"],["Joe","Sally"],
["Joe","Bob"],["Bob","Sally"]]
session.run(insert_query, parameters={"pairs": data})
四、查询数据
(1)查询1
# Friends of a friend
foaf_query = '''
MATCH (person:Person)-[:KNOWS]-(friend)-[:KNOWS]-(foaf)
WHERE person.name = {name}
AND NOT (person)-[:KNOWS]-(foaf)
RETURN foaf.name AS name
'''
results = session.run(foaf_query, parameters={"name": "Joe"})
for record in results:
print(record["name"])
运行结果
Anna
(2)查询2
# Common friends
common_friends_query = """
MATCH (user:Person)-[:KNOWS]-(friend)-[:KNOWS]-(foaf:Person)
WHERE user.name = {user} AND foaf.name = {foaf}
RETURN friend.name AS friend
"""
results = session.run(common_friends_query, parameters={"user": "Joe", "foaf": "Sally"})
for record in results:
print(record["friend"])
运行结果
Bob
(3)查询3
# Connecting paths
connecting_paths_query = """
MATCH path = shortestPath((p1:Person)-[:KNOWS*..6]-(p2:Person))
WHERE p1.name = {name1} AND p2.name = {name2}
RETURN path
"""
results = session.run(connecting_paths_query, parameters={"name1": "Joe", "name2": "Billy"})
for record in results:
print (record["path"])
运行结果
<Path start=<Node id=3 labels={'Person'} properties={'name': 'Joe'}> end=<Node id=6 labels={'Person'} properties={'name': 'Billy'}> size=4>
五、可视化
Neo4j的原始数据如下所示
Neo4j关联关系图如下所示