Add Users Ratings

Challenge

In this challenge, you will add movie ratings to the graph.

You will create a new node for each User and a RATED relationship between the User and the Movie nodes.

The data for the node and relationship is stored in a single file, ratings.csv, which contains the following columns:

The User node should have userId and name properties, and the RATED relationship should have rating and timestamp properties.

The process is the same as importing from a single file as it is from multiple files:

Upload the ratings.csv.
Create the model for the data, in this case, a User node and a RATED relationship to the Movie node.
Map the columns to the model. The node and the relationship will use the same ratings.csv file.
Import the data.

You can check you have imported the data by running the following query to return User nodes and the RATED relationship:

cypher

MATCH (u:User)-[r:RATED]->(m:Movie)
RETURN u,r,m
LIMIT 25

Need to download a working solution?

This Data Importer model, person-movie-user-import.zip, contains a working solution for this exercise.

Download the model and open it using the Open model (with data) button in the … menu.

Note that this will replace your existing model.

In this lesson, you learned how to import multiple nodes and relationships from a single file.

In the next lesson, you will explore the considerations for using Data Importer.