Ghengis Khan's Family Tree in Neo4j

gistfile1.txt

WITH 'https://storage.googleapis.com/meetup-data/ghengis-khan-family-tree.csv' as data

LOAD CSV WITH HEADERS FROM data AS line
MERGE (p:Person { id: line.id })
SET 
    p.name = line.name,
    p.born = coalesce(line.born, 'Unknown'),
    p.died = coalesce(line.died, 'Unknown')
WITH p, line
MERGE (father:Person { id: coalesce(line.father_id, apoc.create.uuid()) })
MERGE (mother:Person { id: coalesce(line.mother_id, apoc.create.uuid()) })
MERGE (p)-[:FATHER]->(father)
MERGE (p)-[:MOTHER]->(mother);