Load multiple CSV rows into same node

[steve5]

I have the following CSV:

id  attr   value
1   abc    1.1    
1   eww    -9.4  
1   ssv    likj
2   we2    1 
2   eww   900  
3   kuku   -91  
3   lulu   383
3   ssv    bubu 

I would like to create 3 nodes that consists of:

Node 1: {id:1, abc: 1.1, eww: -9.4, ssv: "likj"}
Node 2: {id:2, we2: 1, eww: 900}
Node 3: {id:3, kuku: -91, lulu: 383, ssv: "bubu"}

How can I build it in Neo4j cypher?

[Cobra]

Hello @steve5

This should work with apoc.load.csv() function:

CALL apoc.load.csv('file:///data.csv')
YIELD map
MERGE (n:Node {id: map.id})
SET n += map

Regards,
Cobra

[Cobra]

Because you have to use APOC to laod your CSV. I used the apoc.load.csv() function and not LOAD CSV.

[steve5]

But how can I load it using my URL? @Cobra

[Cobra]

This should work:

WITH "https://drive.google.com/u/0/uc?id=1kcNZm0A2I3k9xN1IfNRITOHEzdnqgG7e&export=download" AS requests_url
CALL apoc.load.csv(requests_url)
YIELD map
MERGE (n:Node {id: map.id})
SET n += map

[Cobra · Accepted solution]

In your CSV, the first column doesn't have a column name so in the map object you have a key which has "" as name and that's why you have this error.

So this query will remove the column with no name then load nodes:

WITH "https://drive.google.com/u/0/uc?id=1kcNZm0A2I3k9xN1IfNRITOHEzdnqgG7e&export=download" AS requests_url
CALL apoc.load.csv(requests_url)
YIELD map
WITH apoc.map.clean(map, [""], []) AS map
MERGE (n:Node {request_id: map.request_id})
SET n += map

[steve5]

@Cobra
I have changed the URL but still it doesn't work. Please have a look:

WITH "xxxxxxxxx" AS requests_url
CALL apoc.load.csv(requests_url)
YIELD map
WITH apoc.map.clean(map, [""], []) AS map
MERGE (n:Node {request_id: map.request_id})
SET n += map

Please advise.

[Cobra]

The request works but the file is no longer accessible. That's why it's not working.

[Cobra]

I'm sorry, I will repeat myself. Your link is not working that's why the query doesn't work with your link but the query is good. So in order to work, you need to make sure that your file is externally accessible.

[steve5]

Weird, but it worked, thanks, your solution is working. Thanks.