Neo4j

pborah88 · 03-17-2020

I have a query that matches a pattern with multiple relationships and node types. Within that pattern one relationship is of variable length and has a property which contains a list of values. How do I collect that list in my query. I'm trying - matc...

pborah88 · 03-13-2020

Say I have a graph (object0)-[:CONNECTS_TO]->(object1)-[:CONNECTS_TO]->(Object2)-..... I want a query that returns- ColumnA ColumnB NumberOfHopsAway *********** ********** *********************** Object0 Object 1 ...

pborah88 · 03-02-2020

I have data in a csv that looks like follows - As you can see it is a complex data structure something along the lines of - { { Object Name: P_ADS_BEX_COMMON.DM_OMNITURE_SITE { PRODUCT: Teradata INTERACTION_TYPE: Select INTERACTOR_USERNAME...

pborah88 · 02-25-2020

I'm using the following script to create nodes and relationships via the neo4j python driver- import pandas as pd from neo4j import GraphDatabase pd.set_option('display.max_colwidth', -1) # neo4j credentials uri= "bolt://localhost:7687" userName= "...

pborah88 · 02-19-2020

I have a graph that looks like this - It's the same type of node interacting with one another. (:DataSet)-[:INTERACTS_WITH*]->(:DataSet) I want to write a query that returns the starting nodes of the longest paths. so far I have - match p=(d:DataSe...

pborah88 · 03-19-2020

Okay nevermind. This worked- match (s:SMA)-[r:ASSOCIATED_WITH]->(d:DataSet)-[r1:LINEAGE*]->(d1:DataSet)<-[r2:ASSOCIATED_WITH]-(s1:SMA) unwind r1 as rel unwind rel.relationKeys as rKeys with s,s1, count(*) as count, rKeys with s,s1,count, collect(rKey...

pborah88 · 03-19-2020

andrew.bowman: MATCH (s:SMA)-[:ASSOCIATED_WITH]->(d:DataSet) MATCH path = (d)-[:LINEAGE*]->(d1:DataSet) MATCH (d1)<-[:ASSOCIATED_WITH]-(s1:SMA) UNWIND relationships(path) as rel WITH s, s1, count(*) as count, collect(distinct(rel.relationKeys)) ...

pborah88 · 02-25-2020

Well that was silly, I obviously have to match first before creating a relationship. #Create relationship - (Parent_Procedure)-[:CALLS_TO]->(Called_Procedure) for index, row in df.iterrows(): cq3 = 'match (p1:Program{programName:"'+row["P...

pborah88 · 02-21-2020

Great. Thank you for pointing that out. So again, just trying to understand how neo4j works.... How come then, it's not going into an infinite loop when the query executes? And how come it comes back with a result that says longest path length = 8?

pborah88 · 02-19-2020

andrew.bowman: match p=(d:DataSet)-[r:INTERACTS_WITH*]->(d1:DataSet) return count(p) as pathCount Okay now it makes sense. 640 nodes on the lefthand side and 779 nodes on the righthand side form 2733 paths. So there are definitely overlaps. Bu...

Neo4j

User Statistics

User Activity

How to collect properties from variable length relationship inside a pattern?

How to count number of hops in a query?

Urgent: How to load complex data strctures from csv such as this one?

Python loading script creates duplicate nodes when creating relationships using 'MERGE'

How to capture intersecting paths?

Re: How to collect properties from variable length relationship inside a pattern?

Re: How to collect properties from variable length relationship inside a pattern?

Re: Python loading script creates duplicate nodes when creating relationships using 'MERGE'

Re: How to capture intersecting paths?

Re: How to capture intersecting paths?