HW Assignment 4 - Neo4J Graph DB Higgs Boson
Due Sep 22 by 11:59pm Points 20 Submitting a text entry box or a file upload
Submit Assignment
The Higgs dataset has been built after monitoring the spreading processes on Twitter before, during and
after the announcement of the discovery of a new particle with the features of the elusive Higgs boson
on 4th July 2012.
Here are the summary statistics on the twitter data as shown in the web site.
Social Network statistics
Nodes 456626
Edges 14855842
Retweet Network statistics
Nodes 256491
Edges 328132
Reply Network statistics
Nodes 38918
Edges 32523
Mention Network statistics
Nodes 116408
Edges 150818
I uploaded the above nodes and relationship data to the Neo4J Graph database accessible at the same
endpoint that you used for the neo4j sample program.
The nodes use the label "User"
The four relationship edges use the following Labels :
Followers Social Network edge label "Follows"
9/15/2020 HW Assignment 4 - Neo4J Graph DB Higgs Boson
https://pacific.instructure.com/courses/64091/assignments/267472 2/3
Retweet Network edge label "Retweets"
Reply Network edge label "Replys"
Mention Network edge label "Mentions"
Now answer the following questions using Neo4J Graph queries. When executed your python program
should print the question and then print the answer to the question after that. You will need to submit
your Python code and program output from print statements.
1) your python program as a .py file, and
2) your program’s output as a text output
For the first three questions I have given you the queries given. Use these queries in your code, perform
the neo4J query transactions and print the results. For questions 4 onwards build the queries and print
the results.
1. How many total nodes with Label :User are there in the database? (1)
match (:User) return count(*) as User_Count
1. How many Social Network relationships are there in the database ? (1)
match ()-[follows:Follows]->() return count(follows)
1. How many Social Network followers does user 89805 have ? (1)
match (follower)-[:Follows]->(:User{user:89805}) return count(follower)
4. How many total times did users in this network retweet ? (1)
5. How many times did users in this network reply to other user's tweets ? (1)
6. How many times did users in this network mention other users in their tweets ? (1)
7. How many users follow user 89805 ? (1)
8. How many users does user 89805 follow ? (1)
9. Did user 14907 ever retweet user 89805 ? (2)
9/15/2020 HW Assignment 4 - Neo4J Graph DB Higgs Boson
https://pacific.instructure.com/courses/64091/assignments/267472 3/3
10. Did user 89805 ever retweet user 14907 ? (2)
11. Find out the top 5 users with the highest number of followers ? (3)
12. What is the total count of followers of followers of user 89805 ? (3)
13. Explore and find some interesting statistic from the data. Print out what you found. (2)
Here is a good neo4j reference on the Cypher language. You can use it to learn simple and advanced
queries and operations on neo4j.
https://neo4j.com/docs/cypher-refcard/current/ (https://neo4j.com/docs/cypher-refcard/current/)