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
1 answer

Can we use more than 1 row in LOAD CSV(neo4j)?

LOAD CSV reads row by row and one can do any kind of operation on that row. Is it possible to use more than one row at a time, for example, say I want to assign a relationship where every i'th row is a friend of (i-1)'th row? Or is it possible to…
Sahil Chimnani
  • 105
  • 6
0
votes
0 answers

BigQuery Could not parse '\N' as datetime for field BIRTH_DATE

I want to load a CSV file into BigQuery.There are columns where the types are DATETIME, but some missing values are '\N'. So when I use the BigQuery UI to load, got the following error: Error while reading data, error message: Could not parse '\N'…
user13419531
0
votes
1 answer

Multiple LOAD CSV statements in one Cypher query

Trying to import rows and create nodes from different .csv files in one cypher query: // User nodes LOAD CSV WITH HEADERS FROM 'file:///profile.csv' AS profile_line CREATE (user:User { userId: profile_line.User }) // Project nodes LOAD CSV WITH…
abk
  • 309
  • 6
  • 15
0
votes
1 answer

In D3, how to update global value by a Asynchronous function?

I defined an empty variable dataset: var dataset = []; Load data from a .csv file by d3.dsv function, the schema likes d3.dsv(",", "filename.csv", function(d){ return { key1: value, key2: value, ... }; }).then(function(d) { //do something…
StephenQX
  • 1
0
votes
1 answer

Neo4j LOAD CSV process arrays in CSV documents using a separator

I'm using LOAD CSV to import data from csv to neo4j. My dataset contains multiple values in the country field. Currently I'm using a semicolon as the separator of those multiple…
yasithlokuge
  • 253
  • 5
  • 16
0
votes
1 answer

Create relationship on Neo4j using CSV files

I want to create a simple DB using some CSV files, like this: attore.csv, film.csv, recita.csv. I created successfully the nodes with the label Attore and Film, simple files like this: attore.csv: nome nome1 nome2 nome3 film.csv …
simone di tanna
  • 11
  • 2
0
votes
2 answers

Not able to load relationships from CSV

I have a list of cities their latitude and longitude, their states and country which is available here. I want to a make hierarchical structure…
Kunal Mukherjee
  • 5,775
  • 3
  • 25
  • 53
0
votes
1 answer

Import particular nodes into Neo4J from CSV file

I'm doing some tests in order to figure out how to best import data from a CSV file into Neo4J. I have the following data in the Person.csv file (3 headers, Person_ID, Name, and Type): Person_ID Name Type HUA001 Jaap …
Jaap
  • 87
  • 6
0
votes
2 answers

How to match line of csv which is ignored by constraint and create only relationship

I have been created a graph having a constraint on primary id. In my csv a primary id is duplicate but the other proprieties are different. Based on the other properties I want to create relationships. I tried multiple times to change the code but…
Stetco Oana
  • 101
  • 1
  • 1
  • 11
0
votes
1 answer

String concatenation for row.field from CSV

I am trying to dynamically create the name of a field in a CSV that I am parsing using FOREACH. I am trying this: // From Load CSV WITH row, ['NAME-A', 'NAME-B'] AS olink_panels FOREACH (panel in olink_panels | MERGE (p:Plate …
David Hughes
  • 11
  • 4
0
votes
1 answer

Can i import my primary key in Neo4j with CSV

I'm importing CSV files to Neo4J, but Neo4J doesn't import my primary key. I'm using this: LOAD CSV WITH HEADERS FROM "file:///C:/c/tabela_sujeito.csv" AS row CREATE(:Sujeito{suj_ID:row.id, idade:row.idade, altura:row.altura, peso:row.peso,…
dlmartins
  • 51
  • 9
0
votes
0 answers

How to create an edge in Neo4j between two nodes matching two csv entries in neo4j?

Suppose I have the following table in a csv. elementID | groupID | sequence abc | A | 0 dcv | A | 1 asd | B | 3 ccc | B | 2 abc | B | 4 I have already created the…
roschach
  • 8,390
  • 14
  • 74
  • 124
0
votes
1 answer

load csv and delete \r\n python

I can not load my csv with pandas correctly, I have some matrices and vectors but I get a (\ r \ n) for example i tried this: test = pd.read_csv('test.csv',sep='\t',index_col=0) test.head() and i get this: test['image_gray'][0] '[[0.4297102 …
daniel alejandro Gualterosgual
  • 3
  • 2
0
votes
1 answer

Neo4j Load CSV without Local Admin privileges

I'm trying to evaluate Neo4j-Community-3.2.2 and my IT department installed the product for me in an area where I have no permissions. All I have seem to have is a running Service and the client interface through the browser. I have an immediate…
David Brown
  • 31
  • 1
  • 1
  • 4
0
votes
2 answers

What is not a row in a csv file?

I came upon this code in a tutorial: for row in csv_reader: if not row: continue dataset.append(row) Which I take to mean that if the code encounters something other than a row, just skip and continue. Is that correct?…
spacedustpi
  • 351
  • 5
  • 18
1 2 3 4
5
6