Doing multiple nodes and relations from 1 csv

Neo4j Graph Platform
,
1

How can I create the following from 1 csv file:

Screenshot 2023-12-20 180219
Screenshot 2023-12-20 1802191105×594 25.6 KB

  1. Nodes:
  • App
  • Category
  • Content Rating
  • Genre
  1. Relationships:
  • BELONGS_TO_CATEGORY: Connects App nodes to Category nodes.
  • HAS_CONTENT_RATING: Connects App nodes to Content Rating nodes.
  • HAS_GENRE: Connects App nodes to Genre nodes.
  1. Node Properties:
  • App: Name, Rating, Reviews, Size, Installs, Type, Price, Last Updated, Current Ver, Android Ver
  • Category: Name
  • Content Rating: Name
  • Genre: Name
2

That can be done but you may have to parse it more than once, either loading everything into a graph first and then refactoring, or making multiple passes through the CSV.

1 Like
3

What does each row represent? It looks like one node from each type. If so, are they all related in one row?

The 'App' attributes are not the same for each row. Do you want to create a new 'App' node for each row, and then link it to each of the other nodes identified in the row?