jexp/load-csv.txt

## load-csv.txt
//Loading CSV with Nodes
load csv with headers from
“file:/Users/rvanbruggen/Cloud/Neo Technology/Demo/DEMO-2.1.0-M01/IMPORT/INPUT/nodes.csv”
as nodes
create (n {id: nodes.Node, name: nodes.Name, type: nodes.Label})

//Loading CSV with Rels
load csv with headers from
“file:/Users/rvanbruggen/Cloud/Neo Technology/Demo/DEMO-2.1.0-M01/IMPORT/INPUT/rels.csv”
as rels
match (from {id: rels.From}), (to {id: rels.To})
create from-[:REL {type: rels.`Relationship Type`}]->to

//Assign labels for Males and Females
match (n {type:"Male"}), (m {type:"Female"})
set n:Male, m:Female
return n,m

//Create duplicate relationship with appropriate type
match (n)-[r1 {type:"MOTHER_OF"}]->(m), (s)-[r2 {type:"FATHER_OF"}]->(t)
create n-[:MOTHER_OF]->m, s-[:FATHER_OF]->t
return *;

//Remove duplicate relationships
match ()-[r:REL]-() delete r;

## nodes.csv

          
            Node
            Name
            Label

            
              1
              Amada Emory
              Female

            
              2
              Rana Seely
              Female

            
              3
              Detra Thatcher
              Female

            
              4
              Melda Reza
              Female

            
              5
              Shana Willems
              Female

            
              6
              Sharonda Peele
              Female

            
              7
              Dagny Agee
              Female

            
              8
              Tisa Woodman
              Female

            
              9
              Shelba Mutchler
              Female

            
              10
              Anderson Spagnola
              Male

            
              11
              Pamala Forward
              Female

            
              12
              Melva Fairchild
              Female

            
              13
              Antione Selman
              Male

            
              14
              Carmelia Cali
              Female

            
              15
              Fairy Daughtery
              Female

            
              16
              Stefany Mcamis
              Female

            
              17
              Kermit Meaney
              Male

            
              18
              Williemae Dossantos
              Female

            
              19
              Marth Sparling
              Female

            
              20
              Jarvis Noland
              Male

## rels.csv

          
            From
            Name
            Relationship Type
            To
            Name

            
              1
              Amada Emory
              MOTHER_OF
              11
              Pamala Forward

            
              1
              Amada Emory
              MOTHER_OF
              12
              Melva Fairchild

            
              1
              Amada Emory
              MOTHER_OF
              13
              Antione Selman

            
              2
              Rana Seely
              MOTHER_OF
              14
              Carmelia Cali

            
              2
              Rana Seely
              MOTHER_OF
              15
              Fairy Daughtery

            
              2
              Rana Seely
              MOTHER_OF
              16
              Stefany Mcamis

            
              3
              Detra Thatcher
              MOTHER_OF
              17
              Kermit Meaney

            
              3
              Detra Thatcher
              MOTHER_OF
              18
              Williemae Dossantos

            
              3
              Detra Thatcher
              MOTHER_OF
              19
              Marth Sparling

            
              10
              Anderson Spagnola
              FATHER_OF
              20
              Jarvis Noland

            
              14
              Carmelia Cali
              MOTHER_OF
              1
              Amada Emory

            
              11
              Pamala Forward
              MOTHER_OF
              2
              Rana Seely

            
              11
              Pamala Forward
              MOTHER_OF
              3
              Detra Thatcher

            
              12
              Melva Fairchild
              MOTHER_OF
              4
              Melda Reza

            
              12
              Melva Fairchild
              MOTHER_OF
              5
              Shana Willems

            
              12
              Melva Fairchild
              MOTHER_OF
              6
              Sharonda Peele

            
              17
              Kermit Meaney
              FATHER_OF
              7
              Dagny Agee

            
              13
              Antione Selman
              MOTHER_OF
              8
              Tisa Woodman

            
              13
              Antione Selman
              MOTHER_OF
              9
              Shelba Mutchler

            
              20
              Jarvis Noland
              FATHER_OF
              1
              Amada Emory

## shell-tools.txt
// create nodes
import-cypher -d , -i ./IMPORT/INPUT/nodes.csv -o ./IMPORT/OUTPUT/nodesoutput.txt create (n:#{Label} {id:{Node},name:{Name}}) return *

//create rels
import-cypher -d , -i ./IMPORT/INPUT/rels.csv -o ./IMPORT/OUTPUT/relsoutput.txt MATCH (from {id:{From}}), (to {id:{To}}) create from-[:#{Relationship Type}]->to return *


## spreadsheet-output.cql
//IMPORT SAMPLE
create (n1:Female {id:1, name:'Amada Emory'})
create (n2:Female {id:2, name:'Rana Seely'})
create (n3:Female {id:3, name:'Detra Thatcher'})
create (n4:Female {id:4, name:'Melda Reza'})
create (n5:Female {id:5, name:'Shana Willems'})
create (n6:Female {id:6, name:'Sharonda Peele'})
create (n7:Female {id:7, name:'Dagny Agee'})
create (n8:Female {id:8, name:'Tisa Woodman'})
create (n9:Female {id:9, name:'Shelba Mutchler'})
create (n10:Male {id:10, name:'Anderson Spagnola'})
create (n11:Female {id:11, name:'Pamala Forward'})
create (n12:Female {id:12, name:'Melva Fairchild'})
create (n13:Male {id:13, name:'Antione Selman'})
create (n14:Female {id:14, name:'Carmelia Cali'})
create (n15:Female {id:15, name:'Fairy Daughtery'})
create (n16:Female {id:16, name:'Stefany Mcamis'})
create (n17:Male {id:17, name:'Kermit Meaney'})
create (n18:Female {id:18, name:'Williemae Dossantos'})
create (n19:Female {id:19, name:'Marth Sparling'})
create (n20:Male {id:20, name:'Jarvis Noland'})
create n1-[:MOTHER_OF]->n11
create n1-[:MOTHER_OF]->n12
create n1-[:MOTHER_OF]->n13
create n2-[:MOTHER_OF]->n14
create n2-[:MOTHER_OF]->n15
create n2-[:MOTHER_OF]->n16
create n3-[:MOTHER_OF]->n17
create n3-[:MOTHER_OF]->n18
create n3-[:MOTHER_OF]->n19
create n10-[:FATHER_OF]->n20
create n14-[:MOTHER_OF]->n1
create n11-[:MOTHER_OF]->n2
create n11-[:MOTHER_OF]->n3
create n12-[:MOTHER_OF]->n4
create n12-[:MOTHER_OF]->n5
create n12-[:MOTHER_OF]->n6
create n17-[:FATHER_OF]->n7
create n13-[:MOTHER_OF]->n8
create n13-[:MOTHER_OF]->n9
create n20-[:FATHER_OF]->n1
	//Loading CSV with Nodes
	load csv with headers from
	“file:/Users/rvanbruggen/Cloud/Neo Technology/Demo/DEMO-2.1.0-M01/IMPORT/INPUT/nodes.csv”
	as nodes
	create (n {id: nodes.Node, name: nodes.Name, type: nodes.Label})

	//Loading CSV with Rels
	load csv with headers from
	“file:/Users/rvanbruggen/Cloud/Neo Technology/Demo/DEMO-2.1.0-M01/IMPORT/INPUT/rels.csv”
	as rels
	match (from {id: rels.From}), (to {id: rels.To})
	create from-[:REL {type: rels.`Relationship Type`}]->to

	//Assign labels for Males and Females
	match (n {type:"Male"}), (m {type:"Female"})
	set n:Male, m:Female
	return n,m

	//Create duplicate relationship with appropriate type
	match (n)-[r1 {type:"MOTHER_OF"}]->(m), (s)-[r2 {type:"FATHER_OF"}]->(t)
	create n-[:MOTHER_OF]->m, s-[:FATHER_OF]->t
	return *;

	//Remove duplicate relationships
	match ()-[r:REL]-() delete r;
Node	Name	Label
1	Amada Emory	Female
2	Rana Seely	Female
3	Detra Thatcher	Female
4	Melda Reza	Female
5	Shana Willems	Female
6	Sharonda Peele	Female
7	Dagny Agee	Female
8	Tisa Woodman	Female
9	Shelba Mutchler	Female
10	Anderson Spagnola	Male
11	Pamala Forward	Female
12	Melva Fairchild	Female
13	Antione Selman	Male
14	Carmelia Cali	Female
15	Fairy Daughtery	Female
16	Stefany Mcamis	Female
17	Kermit Meaney	Male
18	Williemae Dossantos	Female
19	Marth Sparling	Female
20	Jarvis Noland	Male
From	Name	Relationship Type	To	Name
1	Amada Emory	MOTHER_OF	11	Pamala Forward
1	Amada Emory	MOTHER_OF	12	Melva Fairchild
1	Amada Emory	MOTHER_OF	13	Antione Selman
2	Rana Seely	MOTHER_OF	14	Carmelia Cali
2	Rana Seely	MOTHER_OF	15	Fairy Daughtery
2	Rana Seely	MOTHER_OF	16	Stefany Mcamis
3	Detra Thatcher	MOTHER_OF	17	Kermit Meaney
3	Detra Thatcher	MOTHER_OF	18	Williemae Dossantos
3	Detra Thatcher	MOTHER_OF	19	Marth Sparling
10	Anderson Spagnola	FATHER_OF	20	Jarvis Noland
14	Carmelia Cali	MOTHER_OF	1	Amada Emory
11	Pamala Forward	MOTHER_OF	2	Rana Seely
11	Pamala Forward	MOTHER_OF	3	Detra Thatcher
12	Melva Fairchild	MOTHER_OF	4	Melda Reza
12	Melva Fairchild	MOTHER_OF	5	Shana Willems
12	Melva Fairchild	MOTHER_OF	6	Sharonda Peele
17	Kermit Meaney	FATHER_OF	7	Dagny Agee
13	Antione Selman	MOTHER_OF	8	Tisa Woodman
13	Antione Selman	MOTHER_OF	9	Shelba Mutchler
20	Jarvis Noland	FATHER_OF	1	Amada Emory
	// create nodes
	import-cypher -d , -i ./IMPORT/INPUT/nodes.csv -o ./IMPORT/OUTPUT/nodesoutput.txt create (n:#{Label} {id:{Node},name:{Name}}) return *

	//create rels
	import-cypher -d , -i ./IMPORT/INPUT/rels.csv -o ./IMPORT/OUTPUT/relsoutput.txt MATCH (from {id:{From}}), (to {id:{To}}) create from-[:#{Relationship Type}]->to return *
	//IMPORT SAMPLE
	create (n1:Female {id:1, name:'Amada Emory'})
	create (n2:Female {id:2, name:'Rana Seely'})
	create (n3:Female {id:3, name:'Detra Thatcher'})
	create (n4:Female {id:4, name:'Melda Reza'})
	create (n5:Female {id:5, name:'Shana Willems'})
	create (n6:Female {id:6, name:'Sharonda Peele'})
	create (n7:Female {id:7, name:'Dagny Agee'})
	create (n8:Female {id:8, name:'Tisa Woodman'})
	create (n9:Female {id:9, name:'Shelba Mutchler'})
	create (n10:Male {id:10, name:'Anderson Spagnola'})
	create (n11:Female {id:11, name:'Pamala Forward'})
	create (n12:Female {id:12, name:'Melva Fairchild'})
	create (n13:Male {id:13, name:'Antione Selman'})
	create (n14:Female {id:14, name:'Carmelia Cali'})
	create (n15:Female {id:15, name:'Fairy Daughtery'})
	create (n16:Female {id:16, name:'Stefany Mcamis'})
	create (n17:Male {id:17, name:'Kermit Meaney'})
	create (n18:Female {id:18, name:'Williemae Dossantos'})
	create (n19:Female {id:19, name:'Marth Sparling'})
	create (n20:Male {id:20, name:'Jarvis Noland'})
	create n1-[:MOTHER_OF]->n11
	create n1-[:MOTHER_OF]->n12
	create n1-[:MOTHER_OF]->n13
	create n2-[:MOTHER_OF]->n14
	create n2-[:MOTHER_OF]->n15
	create n2-[:MOTHER_OF]->n16
	create n3-[:MOTHER_OF]->n17
	create n3-[:MOTHER_OF]->n18
	create n3-[:MOTHER_OF]->n19
	create n10-[:FATHER_OF]->n20
	create n14-[:MOTHER_OF]->n1
	create n11-[:MOTHER_OF]->n2
	create n11-[:MOTHER_OF]->n3
	create n12-[:MOTHER_OF]->n4
	create n12-[:MOTHER_OF]->n5
	create n12-[:MOTHER_OF]->n6
	create n17-[:FATHER_OF]->n7
	create n13-[:MOTHER_OF]->n8
	create n13-[:MOTHER_OF]->n9
	create n20-[:FATHER_OF]->n1