DIRECTED relationship

To complete this challenge, you will need to create the DIRECTED relationships between the Person and Movie nodes.

DIRECTED relationships

Your challenge is to write a Cypher statement to create the DIRECTED relationship between the Person and Movie nodes.

The directed.csv file contains just the movieId and person_tmdbId IDs.

Unlike the ACTED_IN relationship, the DIRECTED relationship has no properties (e.g. role), so you will not need to use the SET clause.

ACTED_IN relationship

Here is the Cypher you used to create to the ACTED_IN relationship.

cypher

LOAD CSV WITH HEADERS
FROM 'https://data.neo4j.com/importing-cypher/acted_in.csv' AS row
MATCH (p:Person {tmdbId: toInteger(row.person_tmdbId)})
MATCH (m:Movie {movieId: toInteger(row.movieId)})
MERGE (p)-[r:ACTED_IN]->(m)
SET r.role = row.role

To verify that you created the DIRECTED relationship successfully, run the following Cypher statement:

cypher

MATCH (p:Person)-[r:DIRECTED]->(m:Movie) RETURN p, r, m LIMIT 25

Directed and acted in

Once you have created the ACTED_IN and DIRECTED relationships, you can use the data to find people who directed and acted in the same movie.

cypher

MATCH (p:Person)-[:ACTED_IN]->(m:Movie)<-[:DIRECTED]-(p:Person)
RETURN p, m

Validate relationships

Once you have created DIRECTED relationships, click the Check Database button to verify that the task is complete.

Hint

Create and run a Cypher statement for the DIRECTED relationships, which:

Uses the directed.csv file
Uses MERGE to create the directed relationship.

Solution

Run this Cypher statement to create the DIRECTED relationships:

cypher

LOAD CSV WITH HEADERS
FROM 'https://data.neo4j.com/importing-cypher/directed.csv' AS row
MATCH (p:Person {tmdbId: toInteger(row.person_tmdbId)})
MATCH (m:Movie {movieId: toInteger(row.movieId)})
MERGE (p)-[r:DIRECTED]->(m)

Summary

In this lesson, you created the Cypher to create the DIRECTED relationship between the Person and Movie nodes.

In the next lesson, you will complete a quiz on the lessons from this module.

Importing CSV data into Neo4j

Importing Data

Creating Nodes, Properties, and Relationships

Data Types, Lists, and Labels

Importing data considerations

DIRECTED relationship