I tried sandbox with neo4j. movielens, I tried it. I made a recommendation.
MATCH (u:User {id:21})
MATCH (u)-[r:RATING]->(m:Movie)
WITH u,
avg(r.rating) AS average
MATCH (u)-[r:RATING]->(m:Movie)
WHERE r.rating > average
RETURN m.title,
r.rating
limit 5
title rating
Short Circuit (1986) 4.0
Rush Hour (1998) 3.5
Da Vinci Code, The (2006) 3.5
Never Say Never Again (1983) 5.0
Thunderball (1965) 4.5
that's all.
Recommended Posts