read_lazega.cypher

LOAD CSV WITH HEADERS FROM 'https://raw.githubusercontent.com/neylsoncrepalde/lazega_lawyers_csv/main/lawyers_attributes.csv' 
    AS row FIELDTERMINATOR ';'
WITH row WHERE row.id IS NOT NULL
MERGE (p:Person {name: row.id})
SET p.status = row.status
SET p.sex = row.sex
SET p.office = row.office
SET p.tenure = toInteger(row.tenure)
SET p.age = toInteger(row.age)
SET p.practice = row.practice
SET p.school = row.school;

LOAD CSV WITH HEADERS FROM 'https://raw.githubusercontent.com/neylsoncrepalde/lazega_lawyers_csv/main/lawyers_advices.csv' 
    AS row FIELDTERMINATOR ';'
WITH row WHERE row.sender IS NOT NULL
MATCH (v:Person {name: row.sender})
MATCH (p:Person {name: row.receiver})
MERGE (v)-[:ASK_ADVICE]->(p);