cypher - load multiple csv files

Viewed 1482

I have many csv files with names 0_0.csv , 0_1.csv , 0_2.csv , ... , 1_0.csv , 1_1.csv , ... , z_17.csv.

I wanted to know how can I import them in a loop or something ?

Also I wanted to know am I doing it good ? ( each file is 50MB and whole files size is about 100GB )

This is my code :

create index on :name(v)
create index on :value(v)    

USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM "file:///0_0.txt" AS csv
FIELDTERMINATOR ',' 
MERGE (n:name {v:csv.name}) 
MERGE (m:value {v:csv.value})
CREATE (n)-[:kind {v:csv.kind}]->(m)
1 Answers
Related