Adam Cowley adam-cowley
adam-cowley
/ toy.cypher
Created
March 9, 2023 16:26
Cypher Indexes and Constraints - Using Indexes in Neo4j - Creating Single Property Indexes
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| PROFILE MATCH (m:Movie) | |
| WHERE m.title STARTS WITH "Toy" | |
| RETURN m.title |
adam-cowley
/ percentage-change.cypher
Created
April 20, 2023 12:29
Next-level Cypher aggregations using WITH, COLLECT and UNWIND!
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| MATCH (u:User)-[:HAS_ENROLMENT]->(e:CompletedEnrolment) | |
| WHERE e.completedAt >= datetime('2021-01-01') | |
| WITH | |
| e.completedAt.year +'-'+ e.completedAt.quarter AS quarter, | |
| count(*) AS count | |
| WITH collect({quarter: quarter, count: count}) AS all | |
| UNWIND range(0, size(all)-1) AS idx |
adam-cowley
/ gist:df0ec9f7e207672cbfd0f501208d59fb
Created
March 27, 2025 08:53
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # reading CSV | |
| import pandas as pd | |
| csv = pd.read_csv('cluster.csv') | |
| # connect with driver | |
| from neo4j import GraphDatabase | |
| driver = GraphDatabase.driver( | |
| "neo4j+s://id.databases.neo4j.io", | |
| ("neo4j", "password") | |
| ) |
OlderNewer