Скачать или смотреть Importing CSV Files into Neo4j: A Beginner's Guide to Cypher and Graph Relationships

Learn the essential steps to import CSV files into Neo4j using Cypher to create nodes and relationships in your graph database.
---
This video is based on the question https://stackoverflow.com/q/66902154/ asked by the user 'computer' ( https://stackoverflow.com/u/15529337/ ) and on the answer https://stackoverflow.com/a/66909943/ provided by the user 'jose_bacoy' ( https://stackoverflow.com/u/7371893/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Neo4j/Cypher Import a CSV file

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Importing CSV Files into Neo4j: A Beginner's Guide to Cypher and Graph Relationships

Are you new to Neo4j and Cypher and eager to import a CSV file containing video game sales data? You’re not alone! Many beginners find themselves grappling with the nuances of graph databases, especially when it comes to establishing relationships between data points. In this guide, we’ll tackle a common challenge: how to properly import a CSV file into Neo4j while ensuring that relationships are created between the nodes (data points).

Understanding the Problem

You have a CSV file, titled vgsales.csv, which contains essential data on video game sales, spread across 11 columns including Rank, Year, Name, and sales data across different regions. Your initial Cypher query successfully creates nodes but fails to establish any relationships between them. As a result, when visualizing the schema using CALL db.schema.visualization, you only see isolated nodes instead of a rich, interconnected graph.

So, what went wrong? Let's dive into the solution step by step.

The Solution: Correcting the Cypher Query

The primary issue in your Cypher query stems from a syntax error, specifically regarding the use of the WITH clause. Let's break down the correct approach to importing your CSV file with proper relationships.

1. Correct the Cypher Syntax

Your original Cypher query included a line that should be removed. The corrected query looks like this:

[[See Video to Reveal this Text or Code Snippet]]

2. Explanation of the Query

LOAD CSV WITH HEADERS: This part of the query reads the CSV file and treats the first row as headers.

CREATE (v:Vgsales { ... }): This creates a new node with the label Vgsales for each entry in your CSV, populating properties like rank, name, platform, and year.

MERGE (g:GENRE { ... }): This creates or matches a node labeled GENRE for each game genre. This ensures that there is only one node per genre.

MERGE (p:PUBLISHER { ... }): This does the same for the publisher, ensuring unique publisher nodes.

MERGE (v)-[:IN_GENRE]- (g): This line establishes a relationship stating that a video game is of a certain genre.

MERGE (p)-[:PUBLISHED]- (v): This defines a relationship indicating that a publisher published the corresponding video game.

3. Running the Query

Once the syntax is corrected and you run the query in your Neo4j browser, you should see:

Added 3 labels

Created 3 nodes

Set 11 properties

Established 2 relationships

Completed the operation in a matter of milliseconds!

4. Visualization of the Graph

To see the rich connections within your graph, simply run the command:

[[See Video to Reveal this Text or Code Snippet]]

This will provide you with a visualization of the nodes and their relationships in the Neo4j browser.

Conclusion

With this guide, you should now be able to import CSV files into Neo4j effectively, creating both nodes and meaningful relationships between them. Having a grasp of Cypher syntax will enhance your ability to manipulate and query graph databases efficiently.

If you have any questions or need further assistance, feel free to reach out in the comments below. Happy graphing!