Stack Overflow
Stack Overflow

Questions tagged [load-csv]

Tag for Neo4j questions related to the LOAD CSV command.

LOAD CSV is a file import / data ingestion clause for 's , which imports data from files.

Example of use

LOAD CSV FROM 'http://neo4j.com/docs/2.3.2/csv/artists.csv' AS line
CREATE (:Artist { name: line[1], year: toInt(line[2])})

References

90 questions
1
vote
1 answer

neo4j load csv invalid "ON MATCH"

I'm loading a file using the LOAD CSV command,and i have a strange situation, when a new row gets a propery added in the "on match" block. here is the code: USING PERIODIC COMMIT 10000 LOAD CSV WITH HEADERS FROM 'file://1.csv' AS line…
Lior Goldemberg
  • 866
  • 13
  • 26
1
vote
1 answer

neo4j load csv - some part doesnt work

i have a problem with import from csv. i'm running the following in the shell, and the last part (MERGE (e1)-[:NEXT]->(hit)))) never happens. little frustrating... Each session has x hits. I want to find the last hit of inserted session, and…
Lior Goldemberg
  • 866
  • 13
  • 26
1
vote
2 answers

Sending Cypher script with LOAD CSV via REST isn't working for me

I'm trying to send this cypher script via REST: {"statements":[{"statement":"LOAD CSV WITH HEADERS FROM \"http://localhost:9000/api/csv/Countries/csv\" as csvLine MERGE (c:Country { Code: csvLine.Code }) RETURN…
Daniel Corbett
  • 255
  • 2
  • 10
1
vote
1 answer

Neo4J Load CSV from Cypher throws "Unknown Error" or DeadlockDetected

I'm evaluating using Neo4J Community 2.1.3 to store a list of concepts and relationships between them. I'm trying to load my sample test data (CSV files) into Neo4J using Cypher from the Web interface , as described in the online manual. My data…
alexycyap
  • 11
  • 2
0
votes
1 answer

How to convert date column from INT to DATE type in large CSV files?

I have a CSV file of over 30 GB, and I want to load and store it into a DolphinDB database using the loadTextEx function. The file contains a column named “date” which is stored as INT type, with values like “20230731”. I would like to convert the…
carbonhydrate
  • 348
  • 5
0
votes
1 answer

Incredibly Long load time for Load CSV in Neo4j Desktop

Using straightforward Cypher to load data from a CSV and just create nodes. Code is as follows: :auto LOAD CSV WITH HEADERS FROM 'file:///registrants.csv' AS row CALL { WITH row MERGE (r:Registrant {row_wid:…
Windstorm1981
  • 2,564
  • 7
  • 29
  • 57
0
votes
1 answer

Load CSV into Neo4j from local path without modifying config

I need to load a CSV file into a Neo4j database using its .NET driver. I can use the following code to load the file. var dataFile = "data.csv"; var driver = GraphDatabase.Driver(uri, AuthTokens.Basic(user, password)); using var session =…
Dr. Strangelove
  • 2,725
  • 3
  • 34
  • 61
0
votes
1 answer

Use Dictionary (key) as input from user , then from same Dictionary load .csv files(value)

Here is how it looks like: dictionary = { '1' : 'mine.csv' , '2' : 'yours.csv' , '3' : 'ours.csv' ...} I want to ask user input : def get_filters(): question = input('which file would you like to view its contents ?' , 1) so answer should be like…
Khadijah Moustafa
  • 1
  • 2
0
votes
1 answer

calling a @classmethod within __init__

So I'm trying to take an OOP approach to make a deck of cards that will be composed of a card class and a deck class. I have a .csv file that consists of 2 columns (suits and ranks) for each card (52…
LaidBackLuck
  • 5
  • 3
0
votes
1 answer

Neo4j loading csv for a very long time

Hi everyone on Stackoverflow, I have simple query to load csv, but browser takes long time to load and still shows loading sign. Here is my query: LOAD CSV WITH HEADERS FROM "file:///ratings_small.csv" AS line WITH line MERGE…
Anna
  • 1
  • 1
  • 4
0
votes
1 answer

How can we load an s3 directory with 1000s of part files in neo4j

I have seen this article about loading a single file from s3 in neo4j. But, if I have the data in multiple part files (usually, in case of large datasets), how can we efficiently load this into a neo4j db?
dumbledorevsbalrog
  • 13
  • 2
0
votes
1 answer

Create Relationship between each Node in Array while using LOAD CSV

I have a given CSV file: 1,2016-10-09T21:14:44Z,Anna Long,"[{"_id": "1", "objectType": "primaryTag"}]" 2,2016-10-10T14:03:51Z,Jonathan Collier,"[{"_id": "2", "objectType": "primaryTag"}, {"_id": "3", "objectType":…
Moritz Kampfinger
  • 95
  • 3
  • 12
0
votes
1 answer

Neo4j load csv performance issues

I am trying to ingest data using load csv command in neo4j 4.0.4 enterprise edition CSV file has 15k rows and 9 columns below is my load csv command: USING PERIODIC COMMIT LOAD CSV WITH HEADERS FROM…
ck22
  • 264
  • 3
  • 16
0
votes
1 answer

How to improve performance of LOAD CSV in NEO4J

I am using community edition of neo4j.I am trying to create 50000 nodes and 93400 relationships using CSV file.But the load csv command in neo4j is taking around 40 mins to create the nodes and relationships. Using py2neo package in python to…
ck22
  • 264
  • 3
  • 16
0
votes
1 answer

How to write a more efficient import query in Neo4j using APOC

I have a large DB and when I try to execute my query: https://textuploader.com/1cduz It takes more than 4 days to finish. Can you help me to build a new one that may be using APOC?
Alex D.
  • 41
  • 6
1 2 3
4
5 6