Script to import the votes from the Ballon d'Or 2014 into a Neo4j graph.

Import_ballon_or.cql

CREATE CONSTRAINT ON (e:PERSON) ASSERT e.name IS UNIQUE;
CREATE CONSTRAINT ON (e:TYPE) ASSERT e.name IS UNIQUE;
CREATE CONSTRAINT ON (e:COUNTRY) ASSERT e.name IS UNIQUE;
 
USING PERIODIC COMMIT 2000
LOAD CSV WITH HEADERS FROM "file:c:/ballon_or.csv" AS line
FIELDTERMINATOR ';'
MERGE (:PERSON {name: line.Name, type: line.Voter, country: line.Country})
MERGE (:TYPE {name: line.Voter})
MERGE (:COUNTRY {name: line.Country})
MERGE (:VOTER {name: line.Voter});

USING PERIODIC COMMIT 2000
LOAD CSV WITH HEADERS FROM "file:c:/ballon_or.csv" AS line
FIELDTERMINATOR ';'
MERGE (:PERSON {name: line.Nominee});
 
USING PERIODIC COMMIT 2000
LOAD CSV WITH HEADERS FROM "file:c:/ballon_or.csv" AS line
FIELDTERMINATOR ';'
MATCH (a:PERSON)
MATCH (b:TYPE { name: a.type})
MERGE (a)-[:HAS_TYPE]->(b);
 
USING PERIODIC COMMIT 2000
LOAD CSV WITH HEADERS FROM "file:c:/ballon_or.csv" AS line
FIELDTERMINATOR ';'
MATCH (a:PERSON { name: line.Nominee })
SET a:NOMINEE;
 
USING PERIODIC COMMIT 2000
LOAD CSV WITH HEADERS FROM "file:c:/ballon_or.csv" AS line
FIELDTERMINATOR ';'
MATCH (a:PERSON)
MATCH (b:COUNTRY { name: a.country})
MERGE (a)-[:HAS_COUNTRY]->(b);

USING PERIODIC COMMIT 2000
LOAD CSV WITH HEADERS FROM "file:c:/ballon_or.csv" AS line
FIELDTERMINATOR ';'
MATCH (a:PERSON {name: line.Name})
MATCH (b:PERSON {name: line.Nominee})
MERGE (a)-[:NOMINATED {position: line.Position}]->(b);

Add degree : MATCH (a:NOMINEE)<-[r:NOMINATED]-(:PERSON) WITH a,count(r) as degree SET a.votes_total = degree

Who voted for who? The Ballon d’Or voting data : https://gist.github.com/jvilledieu/3048e86171fb9048553b