Skip to content

Instantly share code, notes, and snippets.

@jeanmidevacc

jeanmidevacc/neo4j_evaluation_users.py

Created May 11, 2020 01:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jeanmidevacc/1b73380ba13178ebecf4f8362d545321 to your computer and use it in GitHub Desktop.
Save jeanmidevacc/1b73380ba13178ebecf4f8362d545321 to your computer and use it in GitHub Desktop.
Download ZIP
neo4j_evaluation_users.py
Raw
neo4j_evaluation_users.py
query = """
MATCH (n:User)
RETURN n.id AS user_id, size((n)-[:BOOKMARKED]->()) AS count_bookmarked, size((n)-[:REVIEWED]->()) AS count_reviewed, size((n)-[:IS_FRIEND_WITH]->()) AS count_friends, size((n)-[:IS_FOLLOWED_BY]->()) AS count_followed, size((n)-[:FOLLOWS]->()) AS count_follow
"""
with driver.session() as session:
result = session.run(query)
df_evaluation_users = pd.DataFrame([r.values() for r in result], columns=result.keys())
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment