Neo4j APOC Extended Labs
Docs
Neo4j DBMS
  • Getting Started
  • Operations
  • Migration and Upgrade
  • Status Codes
  • Java Reference
  • Kerberos Add-on
  • Change Data Capture (CDC)
Neo4j Aura
  • Neo4j Aura
  • Neo4j AuraDB
  • Neo4j AuraDS
Neo4j Tools
  • Neo4j Bloom
  • Neo4j Browser
  • Neo4j Data Importer
  • Neo4j Desktop
  • Neo4j Ops Manager
Neo4j Graph Data Science
  • Neo4j Graph Data Science Library
Cypher Query Language
  • Cypher
  • Cypher Cheat Sheet
  • APOC Library
Create applications
  • Python Driver
  • Go Driver
  • Java Driver
  • JavaScript Driver
  • .Net Driver
  • Neo4j GraphQL Library
  • HTTP API
  • OGM Library
  • Spring Data Neo4j
  • Neo4j Connector for Apache Spark
  • Neo4j Connector for Apache Kafka
Labs
arrows.app
  • Details
  • arrows.app
APOC Extended
  • Documentation
  • Developer Guide
Halin
ETL Tool
  • Details
  • Documentation
Neo4j Migrations
  • Details
  • Documentation
Neo4j Plugin For Liquibase
  • Details
  • Documentation
Neosemantics
  • Getting Started
  • Documentation
Neo4j Helm
  • Details
  • Documentation
NeoDash
  • Details
  • Documentation
neomodel
  • Details
  • Documentation
Get Help
GraphAcademy
  • Free, Self Paced Training
  • Certification
Community Forum
Discord Chat
Knowledge Base
Neo4j Developer Blog
Neo4j Videos
Get Started Free
Search
Product Version
    • Overview
    • Introduction
    • Installation
      • APOC Core
      • Neo4j Desktop
      • Neo4j Server
      • Docker
    • Usage
    • Built in Help
    • Procedures & Functions
      • apoc.agg
        • apoc.agg.first
        • apoc.agg.graph
        • apoc.agg.last
        • apoc.agg.maxItems
        • apoc.agg.median
        • apoc.agg.minItems
        • apoc.agg.nth
        • apoc.agg.percentiles
        • apoc.agg.product
        • apoc.agg.slice
        • apoc.agg.statistics
      • apoc.algo
        • apoc.algo.aStar
        • apoc.algo.aStarConfig
        • apoc.algo.allSimplePaths
        • apoc.algo.cover
        • apoc.algo.dijkstra
        • apoc.algo.dijkstraWithDefaultWeight
        • apoc.algo.cosineSimilarity
        • apoc.algo.euclideanDistance
        • apoc.algo.euclideanSimilarity
      • apoc.any
        • apoc.any.properties
        • apoc.any.property
      • apoc.atomic
        • apoc.atomic.add
        • apoc.atomic.concat
        • apoc.atomic.insert
        • apoc.atomic.remove
        • apoc.atomic.subtract
        • apoc.atomic.update
      • apoc.bitwise
        • apoc.bitwise.op
      • apoc.bolt
        • apoc.bolt.execute
        • apoc.bolt.load
      • apoc.cluster
        • apoc.cluster.graph
      • apoc.coll
        • apoc.coll.elements
        • apoc.coll.partition
        • apoc.coll.split
        • apoc.coll.zipToRows
        • apoc.coll.avg
        • apoc.coll.combinations
        • apoc.coll.contains
        • apoc.coll.containsAll
        • apoc.coll.containsAllSorted
        • apoc.coll.containsDuplicates
        • apoc.coll.containsSorted
        • apoc.coll.different
        • apoc.coll.disjunction
        • apoc.coll.dropDuplicateNeighbors
        • apoc.coll.duplicates
        • apoc.coll.duplicatesWithCount
        • apoc.coll.fill
        • apoc.coll.flatten
        • apoc.coll.frequencies
        • apoc.coll.frequenciesAsMap
        • apoc.coll.indexOf
        • apoc.coll.insert
        • apoc.coll.insertAll
        • apoc.coll.intersection
        • apoc.coll.isEqualCollection
        • apoc.coll.max
        • apoc.coll.min
        • apoc.coll.occurrences
        • apoc.coll.pairs
        • apoc.coll.pairsMin
        • apoc.coll.partition
        • apoc.coll.randomItem
        • apoc.coll.randomItems
        • apoc.coll.remove
        • apoc.coll.removeAll
        • apoc.coll.reverse
        • apoc.coll.set
        • apoc.coll.shuffle
        • apoc.coll.sort
        • apoc.coll.sortMaps
        • apoc.coll.sortMulti
        • apoc.coll.sortNodes
        • apoc.coll.sortText
        • apoc.coll.subtract
        • apoc.coll.sum
        • apoc.coll.sumLongs
        • apoc.coll.toSet
        • apoc.coll.union
        • apoc.coll.unionAll
        • apoc.coll.zip
      • apoc.config
        • apoc.config.list
        • apoc.config.map
      • apoc.convert
        • apoc.convert.setJsonProperty
        • apoc.convert.toTree
        • apoc.convert.fromJsonList
        • apoc.convert.fromJsonMap
        • apoc.convert.getJsonProperty
        • apoc.convert.getJsonPropertyMap
        • apoc.convert.toBoolean
        • apoc.convert.toBooleanList
        • apoc.convert.toFloat
        • apoc.convert.toIntList
        • apoc.convert.toInteger
        • apoc.convert.toJson
        • apoc.convert.toList
        • apoc.convert.toMap
        • apoc.convert.toNode
        • apoc.convert.toNodeList
        • apoc.convert.toRelationship
        • apoc.convert.toRelationshipList
        • apoc.convert.toSet
        • apoc.convert.toSortedJsonMap
        • apoc.convert.toString
        • apoc.convert.toStringList
      • apoc.couchbase
        • apoc.couchbase.append
        • apoc.couchbase.exists
        • apoc.couchbase.get
        • apoc.couchbase.insert
        • apoc.couchbase.namedParamsQuery
        • apoc.couchbase.posParamsQuery
        • apoc.couchbase.prepend
        • apoc.couchbase.query
        • apoc.couchbase.remove
        • apoc.couchbase.replace
        • apoc.couchbase.upsert
      • apoc.create
        • apoc.create.addLabels
        • apoc.create.node
        • apoc.create.nodes
        • apoc.create.relationship
        • apoc.create.removeLabels
        • apoc.create.removeProperties
        • apoc.create.removeRelProperties
        • apoc.create.setLabels
        • apoc.create.setProperties
        • apoc.create.setProperty
        • apoc.create.setRelProperties
        • apoc.create.setRelProperty
        • apoc.create.uuids
        • apoc.create.vNode
        • apoc.create.vNodes
        • apoc.create.vPattern
        • apoc.create.vPatternFull
        • apoc.create.vRelationship
        • apoc.create.uuid
        • apoc.create.vNode
        • apoc.create.vRelationship
      • apoc.custom
        • apoc.custom.asFunction
        • apoc.custom.asProcedure
        • apoc.custom.declareFunction
        • apoc.custom.declareProcedure
        • apoc.custom.list
        • apoc.custom.removeFunction
        • apoc.custom.removeProcedure
      • apoc.cypher
        • apoc.cypher.doIt
        • apoc.cypher.mapParallel
        • apoc.cypher.mapParallel2
        • apoc.cypher.parallel
        • apoc.cypher.parallel2
        • apoc.cypher.run
        • apoc.cypher.runFile
        • apoc.cypher.runFiles
        • apoc.cypher.runMany
        • apoc.cypher.runSchemaFile
        • apoc.cypher.runSchemaFiles
        • apoc.cypher.runTimeboxed
        • apoc.cypher.runFirstColumn
        • apoc.cypher.runFirstColumnMany
        • apoc.cypher.runFirstColumnSingle
      • apoc.data
        • apoc.data.domain
        • apoc.data.email
        • apoc.data.url
      • apoc.date
        • apoc.date.expire
        • apoc.date.expireIn
        • apoc.date.add
        • apoc.date.convert
        • apoc.date.convertFormat
        • apoc.date.currentTimestamp
        • apoc.date.field
        • apoc.date.fields
        • apoc.date.format
        • apoc.date.fromISO8601
        • apoc.date.parse
        • apoc.date.parseAsZonedDateTime
        • apoc.date.systemTimezone
        • apoc.date.toISO8601
        • apoc.date.toYears
      • apoc.diff
        • apoc.diff.nodes
      • apoc.do
        • apoc.do.case
        • apoc.do.when
      • apoc.es
        • apoc.es.get
        • apoc.es.getRaw
        • apoc.es.post
        • apoc.es.postRaw
        • apoc.es.put
        • apoc.es.query
        • apoc.es.stats
      • apoc.example
        • apoc.example.movies
      • apoc.export
        • apoc.export.cypherAll
        • apoc.export.cypherData
        • apoc.export.cypherGraph
        • apoc.export.cypherQuery
      • apoc.generate
        • apoc.generate.ba
        • apoc.generate.complete
        • apoc.generate.er
        • apoc.generate.simple
        • apoc.generate.ws
      • apoc.gephi
        • apoc.gephi.add
      • apoc.get
        • apoc.get.nodes
        • apoc.get.rels
      • apoc.graph
        • apoc.graph.from
        • apoc.graph.fromCypher
        • apoc.graph.fromDB
        • apoc.graph.fromData
        • apoc.graph.fromDocument
        • apoc.graph.fromPath
        • apoc.graph.fromPaths
        • apoc.graph.validateDocument
      • apoc.hashing
        • apoc.hashing.fingerprint
        • apoc.hashing.fingerprintGraph
        • apoc.hashing.fingerprinting
      • apoc.import
        • apoc.import.csv
        • apoc.import.graphml
        • apoc.import.json
        • apoc.import.xml
      • apoc.json
        • apoc.json.path
      • apoc.label
        • apoc.label.exists
      • apoc.load
        • apoc.load.csv
        • apoc.load.driver
        • apoc.load.html
        • apoc.load.jdbc
        • apoc.load.jdbcParams
        • apoc.load.jdbcUpdate
        • apoc.load.json
        • apoc.load.jsonArray
        • apoc.load.jsonParams
        • apoc.load.ldap
        • apoc.load.xls
        • apoc.load.xml
        • apoc.load.xmlSimple
      • apoc.lock
        • apoc.lock.all
        • apoc.lock.nodes
        • apoc.lock.rels
      • apoc.log
        • apoc.log.debug
        • apoc.log.error
        • apoc.log.info
        • apoc.log.stream
        • apoc.log.warn
      • apoc.map
        • apoc.map.clean
        • apoc.map.flatten
        • apoc.map.fromLists
        • apoc.map.fromNodes
        • apoc.map.fromPairs
        • apoc.map.fromValues
        • apoc.map.get
        • apoc.map.groupBy
        • apoc.map.groupByMulti
        • apoc.map.merge
        • apoc.map.mergeList
        • apoc.map.mget
        • apoc.map.removeKey
        • apoc.map.removeKeys
        • apoc.map.setEntry
        • apoc.map.setKey
        • apoc.map.setLists
        • apoc.map.setPairs
        • apoc.map.setValues
        • apoc.map.sortedProperties
        • apoc.map.submap
        • apoc.map.updateTree
        • apoc.map.values
      • apoc.math
        • apoc.math.regr
        • apoc.math.maxByte
        • apoc.math.maxDouble
        • apoc.math.maxInt
        • apoc.math.maxLong
        • apoc.math.minByte
        • apoc.math.minDouble
        • apoc.math.minInt
        • apoc.math.minLong
        • apoc.math.round
      • apoc.merge
        • apoc.merge.node
        • apoc.merge.relationship
      • apoc.meta
        • apoc.meta.data
        • apoc.meta.graph
        • apoc.meta.graphSample
        • apoc.meta.nodeTypeProperties
        • apoc.meta.relTypeProperties
        • apoc.meta.schema
        • apoc.meta.stats
        • apoc.meta.subGraph
        • apoc.meta.isType
        • apoc.meta.type
        • apoc.meta.typeName
        • apoc.meta.types
      • apoc.metrics
        • apoc.metrics.get
        • apoc.metrics.list
        • apoc.metrics.storage
      • apoc.model
        • apoc.model.jdbc
      • apoc.mongodb
        • apoc.mongodb.count
        • apoc.mongodb.delete
        • apoc.mongodb.find
        • apoc.mongodb.first
        • apoc.mongodb.get
        • apoc.mongodb.insert
        • apoc.mongodb.update
      • apoc.monitor
        • apoc.monitor.ids
        • apoc.monitor.kernel
        • apoc.monitor.store
        • apoc.monitor.tx
      • apoc.neighbors
        • apoc.neighbors.athop
        • apoc.neighbors.byhop
        • apoc.neighbors.tohop
      • apoc.node
        • apoc.node.degree
        • apoc.node.id
        • apoc.node.labels
      • apoc.nodes
        • apoc.nodes.collapse
        • apoc.nodes.delete
        • apoc.nodes.get
        • apoc.nodes.group
        • apoc.nodes.link
        • apoc.nodes.rels
        • apoc.nodes.connected
        • apoc.nodes.isDense
      • apoc.number
        • apoc.number.arabicToRoman
        • apoc.number.format
        • apoc.number.parseFloat
        • apoc.number.parseInt
        • apoc.number.romanToArabic
      • apoc.path
        • apoc.path.expand
        • apoc.path.expandConfig
        • apoc.path.spanningTree
        • apoc.path.subgraphAll
        • apoc.path.subgraphNodes
        • apoc.path.combine
        • apoc.path.create
        • apoc.path.elements
        • apoc.path.slice
      • apoc.periodic
        • apoc.periodic.cancel
        • apoc.periodic.commit
        • apoc.periodic.countdown
        • apoc.periodic.iterate
        • apoc.periodic.list
        • apoc.periodic.repeat
        • apoc.periodic.rock_n_roll
        • apoc.periodic.rock_n_roll_while
        • apoc.periodic.submit
      • apoc.refactor
        • apoc.refactor.categorize
        • apoc.refactor.cloneNodes
        • apoc.refactor.cloneNodesWithRelationships
        • apoc.refactor.cloneSubgraph
        • apoc.refactor.cloneSubgraphFromPaths
        • apoc.refactor.collapseNode
        • apoc.refactor.extractNode
        • apoc.refactor.from
        • apoc.refactor.invert
        • apoc.refactor.mergeNodes
        • apoc.refactor.mergeRelationships
        • apoc.refactor.normalizeAsBoolean
        • apoc.refactor.setType
        • apoc.refactor.to
      • apoc.rel
        • apoc.rel.id
        • apoc.rel.type
      • apoc.schema
        • apoc.schema.assert
        • apoc.schema.nodes
        • apoc.schema.relationships
      • apoc.scoring
        • apoc.scoring.existence
        • apoc.scoring.pareto
      • apoc.search
        • apoc.search.multiSearchReduced
        • apoc.search.node
        • apoc.search.nodeAll
        • apoc.search.nodeAllReduced
        • apoc.search.nodeReduced
      • apoc.spatial
        • apoc.spatial.geocode
        • apoc.spatial.geocodeOnce
        • apoc.spatial.reverseGeocode
        • apoc.spatial.sortByDistance
      • apoc.static
        • apoc.static.get
        • apoc.static.list
        • apoc.static.set
        • apoc.static.get
        • apoc.static.getAll
      • apoc.stats
        • apoc.stats.degrees
      • apoc.systemdb
        • apoc.systemdb.execute
        • apoc.systemdb.graph
      • apoc.temporal
        • apoc.temporal.format
        • apoc.temporal.formatDuration
        • apoc.temporal.toZonedTemporal
      • apoc.text
        • apoc.text.doubleMetaphone
        • apoc.text.phonetic
        • apoc.text.phoneticDelta
        • apoc.text.base64Decode
        • apoc.text.base64Encode
        • apoc.text.base64UrlDecode
        • apoc.text.base64UrlEncode
        • apoc.text.byteCount
        • apoc.text.bytes
        • apoc.text.camelCase
        • apoc.text.capitalize
        • apoc.text.capitalizeAll
        • apoc.text.charAt
        • apoc.text.clean
        • apoc.text.code
        • apoc.text.compareCleaned
        • apoc.text.decapitalize
        • apoc.text.decapitalizeAll
        • apoc.text.distance
        • apoc.text.doubleMetaphone
        • apoc.text.format
        • apoc.text.fuzzyMatch
        • apoc.text.hammingDistance
        • apoc.text.hexCharAt
        • apoc.text.hexValue
        • apoc.text.indexOf
        • apoc.text.indexesOf
        • apoc.text.jaroWinklerDistance
        • apoc.text.join
        • apoc.text.levenshteinDistance
        • apoc.text.levenshteinSimilarity
        • apoc.text.lpad
        • apoc.text.phonetic
        • apoc.text.random
        • apoc.text.regexGroups
        • apoc.text.regreplace
        • apoc.text.repeat
        • apoc.text.replace
        • apoc.text.rpad
        • apoc.text.slug
        • apoc.text.snakeCase
        • apoc.text.sorensenDiceSimilarity
        • apoc.text.split
        • apoc.text.swapCase
        • apoc.text.toCypher
        • apoc.text.toUpperCase
        • apoc.text.upperCamelCase
        • apoc.text.urldecode
        • apoc.text.urlencode
      • apoc.trigger
        • apoc.trigger.add
        • apoc.trigger.list
        • apoc.trigger.pause
        • apoc.trigger.remove
        • apoc.trigger.removeAll
        • apoc.trigger.resume
        • apoc.trigger.nodesByLabel
        • apoc.trigger.propertiesByKey
      • apoc.ttl
        • apoc.ttl.expire
        • apoc.ttl.expireIn
      • apoc.util
        • apoc.util.sleep
        • apoc.util.validate
        • apoc.util.md5
        • apoc.util.sha1
        • apoc.util.sha256
        • apoc.util.sha384
        • apoc.util.sha512
      • apoc.uuid
        • apoc.uuid.install
        • apoc.uuid.list
        • apoc.uuid.remove
        • apoc.uuid.removeAll
      • apoc.warmup
        • apoc.warmup.run
      • apoc.xml
        • apoc.xml.import
        • apoc.xml.parse
    • Configuration Options
    • Import
      • Loading Data from Web-APIs
      • Load JSON
      • Load CSV
      • Import CSV
      • Loading Excel (XLS)
      • Load XML
      • Load HTML
      • Import GraphML
    • Export
      • Export to CSV
      • Export to JSON
      • Export to Cypher Script
      • Export to GraphML
      • Export to Gephi
    • Database Integration
      • Load JDBC (RDBMS)
      • Database Modeling
      • ElasticSearch
      • MongoDB
      • Couchbase
      • Bolt
      • Load LDAP
    • Graph Updates
      • Creating Data
      • Graph Refactorings
        • Categorize
        • Clone nodes
        • Clone subgraph
        • Collapse node to relationship
        • Extract node from relationships
        • Invert relationship
        • Merge Nodes
        • Normalize As Boolean
        • Property value to a label
        • Redirect relationships
        • Rename
        • Set Relationship Types
      • UUIDs
      • Periodic Execution
      • Atomic Property Updates
      • Locking
      • Time To Live (TTL) - Expire Nodes
      • Generating Graphs
      • Deleting Data
    • Data Structures
      • Conversion Functions
      • Map Functions
      • Collection Functions
    • Temporal (Date Time)
      • Temporal Functions
      • Date and Time Conversions
    • Mathematical
      • Math Functions
      • Exact Math
      • Number Format Conversions
      • Bitwise operations
    • Advanced Graph Querying
      • Path Expander Overview
      • Expand paths
      • Expand paths with config
      • Expand to nodes in a subgraph
      • Expand to subgraph
      • Expand a spanning tree
      • Neighbor Functions
      • Path Manipulation
      • Relationship Querying
      • Node Querying
      • Parallel Node Search
    • Comparing Graphs
      • Diff
      • Fingerprinting
    • Cypher Execution
      • Running Cypher fragments
      • Conditional Cypher Execution
      • Timeboxed Cypher statements
      • Run multiple Statements
      • Run Cypher Script Files
      • Custom, Cypher Based Procedures and Functions
      • Parallel Cypher Execution
    • Virtual Nodes & Relationships (Graph Projections)
      • Virtual Nodes/Rels
      • Nodes collapse
      • Virtual Graph
      • Graph Grouping
    • Natural Language Processing (NLP)
      • Google Cloud Platform (GCP)
      • Amazon Web Services (AWS)
      • Microsoft Azure Cognitive Services
    • Background Operations
      • Background Jobs
      • Triggers
    • Database Introspection
      • Meta Graph
      • Config
      • Monitoring
      • SystemDB
    • Operational
      • Cypher init script
      • Warmup
      • Logging
    • Miscellaneous
      • Text Functions
      • Spatial
      • Static Value Storage
      • Utilities
    • Text and Lookup Indexes
      • Schema Information
    • Graph Algorithms
      • Path Finding Procedures
      • Deprecated: Similarity

Is this page helpful?

  • APOC Documentation
  • Mathematical
Edit this Page

Mathematical

For more information on how to use these procedures, see:

  • Math Functions

  • Exact Math

  • Number Format Conversions

  • Bitwise operations

Learn

  • Sandbox
  • Neo4j Community Site
  • Neo4j Developer Blog
  • Neo4j Videos
  • GraphAcademy
  • Neo4j Labs

Social

  • Twitter
  • Meetups
  • Github
  • Stack Overflow
  • Want to Speak?

Contact Us →

  • US: 1-855-636-4532
  • Sweden +46 171 480 113
  • UK: +44 20 3868 3223
  • France: +33 (0) 1 88 46 13 20

© 2023 Neo4j, Inc.
Terms | Privacy | Sitemap

Neo4j®, Neo Technology®, Cypher®, Neo4j® Bloom™ and Neo4j® Aura™ are registered trademarks of Neo4j, Inc. All other marks are owned by their respective companies.