Your challenge is to import data about movies from a CSV file and create Movie nodes in the database.
To complete this challenge, you will need to:
-
Download the
movies.csvfile and import it into Data Importer -
Update the model to add a new Node label
Movie -
Map the columns from the CSV file to the properties of the
Movienode -
Run the import to create
Movienodes in the database
You can use the movieId as the unique identifier for the Movie nodes.
You should also update some of the default property names to be more concise:
| From | To |
|---|---|
|
|
|
|
|
|
|
`url |
You can verify that the Movie nodes have been created by running the following Cypher query to return the first 25 Movie nodes:
MATCH (m:Movie) RETURN m LIMIT 25
Validate Results
Once you have imported the Movie nodes, click the Check Database button to verify that the task is complete.
Hint
Follow the same steps as the previous lesson, where you imported the Person nodes from the persons.csv file.
Solution
This Data Importer model, person-movie-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.
Review the model; you will see that a Movie node has properties mapped from the movies.csv file.
Run the import to add the Movie nodes to the graph.
Summary
In this challenge, you create Movie nodes in the database by importing data from a CSV file.
In the next lesson, you will learn how to add relationships between nodes.