Add Movie Nodes

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:

  1. Download the movies.csv file and import it into Data Importer

  2. Update the model to add a new Node label Movie

  3. Map the columns from the CSV file to the properties of the Movie node

  4. Run the import to create Movie nodes 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:

Update property names
From To

movie_imdbId

imdbId

movie_poster

poster

movie_tmdbId

tmdbId

movie_url

`url

You can verify that the Movie nodes have been created by running the following Cypher query to return the first 25 Movie nodes:

cypher
MATCH (m:Movie) RETURN m LIMIT 25
A graph showing 25 `Movie` nodes

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.

The Open model (with data) button highlighted 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.

Chatbot

Hi, I am an Educational Learning Assistant for Intelligent Network Exploration. You can call me E.L.A.I.N.E.

How can I help you today?