cancel
Showing results for 
Search instead for 
Did you mean: 

Join the community at Nodes 2022, our free virtual event on November 16 - 17.

Graph Academy: Importing csv files Challenge string to date

Tartar1
Node

Good morning,

I ran the files according to instructions (born and died are dates).

I can not validate the results (I used the cleaning procedure ("MATCH (n) DETACH DELETE n) and imported the initial graph again

What did I wrong?

Thanks for your help.

1 REPLY 1

Hello @Tartar1 ,

After the Data Import using the Data Importer app, this Cypher should return true:

MATCH ()-[r]->()
WITH count(r) AS Relationships
MATCH (n)
WITH count(n) as Nodes, Relationships
CALL apoc.meta.nodeTypeProperties( ) yield propertyTypes, totalObservations
with Relationships, Nodes, sum(totalObservations) AS numProperties
CALL apoc.meta.nodeTypeProperties( ) yield propertyTypes, totalObservations
with * where propertyTypes = ["Long"] OR propertyTypes = ["Double"]
with Relationships, Nodes, numProperties, sum(totalObservations) AS numNumericProperties
RETURN Relationships + Nodes + numProperties + numNumericProperties = 12417 as outcome

If your Cypher does not return true, then you have some extra labels, property keys etc. in the graph. 

MATCH (n) DETACH DELETE n will remove all nodes and relationships in the graph, but does not remove property keys and constraints. If you want to really start from nothing for the data import, try this command:
CREATE OR REPLACE DATABASE neo4j

Then do the import.

Elaine