How to create relationship with same label from csv file

[lingzheng2101]

I have two csv files , one is persons.csv and the other is relationship.csv file, they have below structure:
person.csv
name, age, sex
Bob, 25, male
Jone, 36, male
Nancy, 34, female

relationship.csv
name0, name1, relationship_weight
Bob, Jone, 20
Nancy, Bob, 30
Jone, Nancy, 100

I want to load the csv files, and create relationship with the realtionship.csv file, anyone can help me? thanks in advanced

[ameyasoft · Accepted solution]

lingzheng2101:

relationship.csv
name0, name1, relationship_weight
Bob, Jone, 20
Nancy, Bob, 30
Jone, Nancy, 100

Try this:

LOAD CSV WITH HEADERS FROM "file:///relationship.csv" AS row
with row

MATCH (a:Name {name: row,name0})
MATCH (b:Name {name: row.name1})
MERGE (a)-[:KNOWS {weight: toInteger(row.relationship_weight)}->(b)

[lingzheng2101]

Thanks amyasoft a lot , it works