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
0
votes
0 answers

Defining syntax for csv import to Neo4j

i am using the Neo4j database on my mac (mac OS High Sierra) and would like to import a csv file into the database. I wanna use the "Load CSV" command and my question is how to structure the command? The structure of the csv-file is as…
David
  • 41
  • 5
0
votes
2 answers

Import CSV file in Neo4j 3.x via Cypher-Shell

I'm trying to import a large CSV file into Neo4j 3.x via the Cypher Shell (instead of the Neo4j - Shell) on a macOS dev machine. The import statements are defined within a cypher script file. I have set the correct import directory within the conf…
Krid
  • 269
  • 1
  • 3
  • 14
0
votes
1 answer

How to create relationships with load CSV from a batch-import file relationships

I have already created the nodes before and I would like to use the relationships file used some time ago during a batch- import, to create relationships using the load CSV method. This is my relationships CSV file:
ErEcTuS
  • 777
  • 1
  • 14
  • 33
0
votes
0 answers

Load CSV to Pandas as MultiIndex

At the moment i try to read a *.txt with "read_csv". Works fine so far. In[1]: df = pd.read_csv('Data.txt', skiprows=range(0,4), sep='\t', header = 0, skipinitialspace = True) If i set the header = 0 i get the Elementlabels, but they repeat for…
Nils
  • 409
  • 6
  • 16
0
votes
2 answers

Couldn't load the external resource at: file:/var/lib/neo4j/import with Neo4j docker image

I am trying to load the node from csv in Neo4j, however, every time I try to do this I get such an error: Neo.ClientError.Statement.ExternalResourceFailed: Couldn't load the external resource at: file:/var/lib/neo4j/import/events.csv My event.csv…
Cassie
  • 339
  • 1
  • 3
  • 13
0
votes
1 answer

Neo4j LOAD CSV not working when I use link from github

I have this piece of code which loads a csv from another site. LOAD CSV FROM 'https://www.quackit.com/neo4j/tutorial/genres.csv' AS line CREATE (:Genre { GenreId: line[0], Name: line[1]}) But when I upload the same csv to my github account and try…
Jp Reddy
  • 366
  • 1
  • 4
  • 15
0
votes
1 answer

Neo4j - LOAD-CSV not creating all nodes

I am just getting started on Neo4J, and I am trying to load some data into Neo4j 3.1 using LOAD CSV with the following script: USING PERIODIC COMMIT 1000 LOAD CSV WITH HEADERS FROM "file:///Fake59.csv" AS line MERGE (person:Person {firstName:…
Cracoras
  • 347
  • 3
  • 16
0
votes
1 answer

Create unique nodes and make labels with multiple values

I'm a noob in neo4j, and my question can look very simple. I have CSV file, with next structure: Id is a Persons ID, and Fam is a project ID, where this person took part. I want to connect persons if they worked on the same project. What is the…
Фанки Джаз
  • 69
  • 2
  • 9
0
votes
2 answers

Adding relationships using load csv in neo4j taking huge time

I'm loading relationships into my graph db in Neo4j using the load csv operation. The nodes are already created. I have four different types of relationships to create from four different CSV files (file 1 - 59 relationships, file 2 - 905…
MohanVS
  • 167
  • 1
  • 1
  • 10
0
votes
1 answer

can we use update with load query?

I've loaded a csv file(which contains columns studentsID and marks) into a table. Now am loading another csv file into same table(with same columns but with the updated marks of same students). Now it should check for the condition if there is…
lucky
  • 39
  • 8
0
votes
2 answers

Load csv merge performance

I have a performance issue with bulk insert into neo4j. I have a csv file with 400k rows which produces about 3.5 million rows, and I use LOAD CSV command, with the latest version on neo4j. I've noticed that when I user Create statement, the load…
Lior Goldemberg
  • 866
  • 13
  • 26
0
votes
1 answer

Neo4j import csv to database

I want to import Publications from csv to neo4j. And make Query which will select all authors which are authors of publication or at least one author. I have csv file in format Author,Publication Sanjeev Saxena,Parallel Integer Sorting and…
kanion
  • 117
  • 1
  • 7
-1
votes
1 answer

session.run(LOAD CSV) issues

When using LOAD CSV function with session.run() to execute cypher statements into Neo4J it doesn't return anything. Have tried removing LOAD CSV and it works perfectly fine in creating nodes. This is the code: import { neo4jgraphql } from…
MrKnudz
  • 41
  • 6
-1
votes
2 answers

How to import excel relationship matrix to Neo4j?

I want to import an excel file which is actually a relationship matrix nxn with several relationship types between the n elements. id| name | element1 | element2 | element3 ... n 1 | element1 1;2;3 1;5 2 | element2 1;2;3 3…
RR_514
  • 23
  • 5
-1
votes
1 answer

error loading csv file for R

when i loading csv file for R, i can see the error but i don't know why this happening i wrote following code: setwd("C:\\Users\\규남\\Desktop\\twitter") library(KoNLP) useSejongDic() txt <- readLines(file("test.csv")) and, this error appear txt <-…
L.kyunam
  • 53
  • 12
1 2 3 4 5
6