3 ms·
I started on something similar as a side project[1]. I decided to build a dataset from the AFI Top 100 Films list and persist it in neo4j. The goal was to fin
by mcphilip 13y ago
I started on something similar as a side project[1]. I decided to build a dataset from the AFI Top 100 Films list and persist it in neo4j. The goal was to find interesting questions to answer with this dataset that couldn't easily be googled.
Most of my time thus far has been spent gathering the dataset, but I do have a few example cypher queries answering the following simple questions [2]:
1) What actors have appeared in the most AFI Top 100 films?
2) What are the genres of the top ten films?
3) Have any actors appeared in 2 or more of the top 25 films?
I'm working on building a much larger data set using a combination of freebase and imdb so that I can have enough data to start exploring much more interesting interesting questions (e.g. graph the frequencies of genres over the past 60 years; for a given film, find movies with the greatest overlap in genres, actors, and directors; generalize the n-degrees-to-bacon problem to work on any two actors; etc).
[1]https://github.com/mcphilip/film-graph https://github.com/mcphilip/film-graph
[2]http://htmlpreview.github.io/?https://github.com/mcphilip/film-graph/blob/master/film-graph-overview.html#query1 http://htmlpreview.github.io/?https://github.com/mcphilip/fi...
- rpicard 13y agoVery cool. Thanks for posting this. The n-degrees-to-bacon problem is actual what made me think of this in the first place. It would be great to be able to plug in two actors and have it spit out an answer with the shortest path.