Categories

Besides the functions listed in this page, DolphinDB also provides Higher-Order Functions

Timer Functions

Data Types and Data Forms

Basic Data Types

Literal Data Types

Special Data Types

Temporal Data Types

Vector

Pair

pair

Matrix

matrix

Set

set

Dictionary

dict

Data Type / Data Form Checkers

Conversion Functions

JSON

Excel

convertExcelFormula

Character Encoding / Decoding

Data Type Conversion

cast

String Case Conversion

upper
lower

Rounding

Angle Conversion

Base Conversion

hex

Data Type Conversion with Specified Format

High Bytes / Low Bytes

Encryption

Vector

Vector Operations

Vector Creation

Cut

cut

Deletion

Filtering

conditionalFilter

Accessing Vector

Move

Join

join
join!

Replacement

Vector Computation

Tuple

Set

Matrix

Matrix Creation

Computation

Decomposition

Accessing Matrix

cell
cells

Combination

Rearrangement

Dictionary

Dictionary Creation

String

String Creation

repeat

Accessing String

Concatenation

concat

Padding

lpad
rpad

Trimming / Stripping

Spliting

Counting

Replacement

Database and Table

Cluster

Configuration

Node Management

Data Recovery

Data Rebalancing

Replica Management

Cross-Cluster Asynchronous Replication

Parallel Computing

pnodeRun

Backup / Restore

Table

Row / Column

Creation / Deletion

Saving Table to Disk

Table Update

Accessing Columns

Accessing Rows

Replay

replay

Table Joiners

cj
ej
sej
lj (left join)
lsj (left semi join)
fj (full join)
aj
wj
pwj
pj
inner join

Function View

Partitioning

Data / Plugin Loading

Data Appending

Data Update

Data Deletion

SQL Keywords

Remote Connection

Anomaly Detection

Data Source Operations

Streaming

Stream Table Creation

Stream Table Operations

Stream Table Configuration and Management

Stream Engines

Basic Functions

Sign of a Number

Operators

Square and Square Root

Logarithm

Natural Exponential

Shift Operations

Others

Logical Functions

Basic Logical Operations

Bitwise Operations

Comparison Operations

Trigonometric functions

Cosine

Sine

Tangent

Linear Planning

Statistical Functions

Median

med

Variance

Covariance

Standard Deviation

Quantile

Maximum / Minimum

max
min

Peak / Valley

Average

Correlation

Autocorrelation

acf
autocorr

Sum

Deviation

sem
mad

Kurtosis / Skew

Least Squares Estimation

beta

Mutual Information

mutualInfo

Spearman Rank Correlation Coefficient

spearmanr

Data Manipulation

Winsorizing

Resampling

resample

TA-lib

Copy

copy
asis

Pack/Unpack

pack
unpack

Data Analysis

MapReduce

Data Compression

Machine Learning

Model

Classifier / Network

Least Squares Regression

Get Information

Node Information

Database Information

Streaming Computating Information

Session Information

getSessionMemoryStat

Job Information

SQL Query Information

Transaction Information

Access Control Information

Garbage Collection Information

getRedoLogGCStat

System Information

License

Access Control

Get Access Information

User Management

Creation and Deletion of Users / User Groups

Privileges

Job Management

Operations

Configuration

Get Job Information

Script Management

Session

Variable

Function

Programming Keywrords

Script Execution

Result Printing

print

Module

Memory Cleanup

Plugin

loadPlugin

DevOps

File Reading / Writing / Deletion

Database/Table Management

System Management

Row-Based Functions

Plot

Validation Functions

Boolean Checker

all
any

NULL Value Checker

NaN/Inf Checker

isNanInf

Peak / Valley Checker

Checking If Value Exists in Range

in
between

String Checker

Vector Checker

Time Checker

Conditional Validation

Other Validation Functions

Filling

NULL Value Filling

Value Filling

Sorting / Finding / Grouping

Sorting

Finding

Grouping

Order-Sensitive Functions

deltas ratios ffill move prev next iterate ewmMean ewmVar ewmStd ewmCov ewmCorr prevState