aggregation
Grouping rows and computing a value over each group. In Cypher the grouping keys are whatever expressions in the same clause are not aggregated.
Example
One row per person, counting the films each acted in.
cypher
MATCH (p:Person)-[:ACTED_IN]->(m:Movie)
RETURN p.name, count(m) AS filmscount(m) is the aggregate. p.name is the only other expression in the clause, so it is the grouping key. Adding m.year beside it would group by person and year instead, and return a row for each.
Lessons that use this term
The lesson and course links below open in a new tab.
19 lessons use this term. Results are ordered by term density.
Introduction to Graph Databases Workshop3 mentions
- Pipelining with WITHCypherresults after aggregation3 mentions
Intermediate Cypher Queries16 mentions
- Pipelining QueriesPipelining Queriesare calculated as part of the aggregation and then used to return the6 mentions
- Aggregating DataWorking with Cypher Datathis lesson you will learn how aggregation works in a Cypher statement and how to work with properties that contain multiple10 mentions
Get started with Graph Data Science10 mentions
- Understand relationship aggregationEssential projection techniquesWhat relationship aggregation is and why it's useful How aggregation functions work in Cypher projections When to use aggregation8 mentions
- Challenge: Aggregated projection and analysisEssential projection techniquesnodes are present The relationship count is less than it would be without aggregation The projection has a2 mentions
Cypher Aggregations14 mentions
- Calculating Min/Max ValuesAggregating Functionsthe aggregation functions sum() and avg(), the min and max functions evaluate values that could represent mixed2 mentions
- Creating ListsUnderstanding Aggregation in Cyphercreate a list during a query, aggregation7 mentions
- Using Aggregation to CountUnderstanding Aggregation in Cypherthe query must process all patterns in the MATCH clause to complete the aggregation to either return results or perform the next part of the2 mentions
- Averaging ValuesAggregating Functionsreturns the average of all values retrieved during aggregation2 mentions
- Adding ValuesAggregating Functionsreturns the sum of all values retrieved during aggregation1 mention
Building Agents in Neo4j Aura6 mentions
- Add a Text2Cypher toolBuilding an Agentvalues are useful for filtering, and which numeric properties are suitable for aggregation2 mentions
- Using Text2Cypher for ad-hoc queriesBuilding an Agentrelevant labels and relationship types, and which attributes are suitable for aggregation1 mention
- Designing and managing agentsIntroduction to Aura Agentthan 2 different suppliers?" — the filter count, the multi-hop path, and the aggregation all vary with the2 mentions
- Next StepsPublishing Agentslabels, relationships, and which properties are suitable for filtering and aggregation1 mention
Building Dashboards with Neo4j Aura1 mention
- Match visualizations to queriesBuilding your dashboardExperiment with the count(), avg(), and sum() aggregation functions in Cypher to return a single1 mention
Analyze Graph Data with Python1 mention
- From Cypher to Native ProjectionGDS Python Clientlabels and types directly | | gds.graph.cypher.project() | Complex patterns, aggregation, filtering | | run_cypher() + graph.get() | You prefer writing raw Cypher1 mention
Building Neo4j Applications with Spring Data1 mention
- Custom Cypher for ReadCustom Cypher for Read and Write(relationships and nodes) for each unique movie using Cypher's implicit aggregation for each item listed in the1 mention
Neo4j Management, Optimization, and Refactoring Workshop1 mention
- Analyzing Query PerformanceQuery PerformanceEager: Some operators (aggregation, sorting) must process all input before producing1 mention
Graph Data Science in Practice2 mentions
- Louvain Community DetectionCommunity Detection for Fraud2: Aggregation2 mentions