Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- LOAD CSV WITH HEADERS FROM 'file:///movies.clean.csv' as l
- CREATE (m:Movie{movieId:toInteger(l.movieId), tmdbId:l.tmdbId, imdbId:l.imdbId, title:l.title, year:date(l.year)})
- CREATE INDEX ON :Movie(movieId)
- LOAD CSV WITH HEADERS FROM 'file:///users.csv' as l
- CREATE (u:User{userId:toInteger(l.userId)})
- CREATE INDEX ON :User(userId)
- LOAD CSV WITH HEADERS FROM 'file:///genres.csv' as l
- MERGE (g:Genre{name:l.genre})
- WITH g,l.movieId as movieId
- MATCH (m:Movie{movieId:toInteger(movieId)})
- MERGE (m)-[:IsGenre]->(g)
- LOAD CSV WITH HEADERS FROM 'file:///ratings.csv' as l
- MATCH (m:Movie{movieId:toInteger(l.movieId)})
- MATCH (u:User{userId:toInteger(l.userId)})
- CREATE (u)-[:Rates{rating:toFloat(l.rating), time:datetime(l.time)}]->(m)
- LOAD CSV WITH HEADERS FROM 'file:///tags.csv' as l
- MATCH (m:Movie{movieId:toInteger(l.movieId)})
- MATCH (u:User{userId:toInteger(l.userId)})
- CREATE (u)-[:Tags{tag:l.tag, time:datetime(l.time)}]->(m)
Add Comment
Please, Sign In to add comment