Home
Function References
Reference for all built-in functions
Functions
N
nanInfFill

About DolphinDB
Getting Started
Deployment
Deploy and upgrade DolphinDB on premise or in the cloud
Programming Guide
DolphinDB scripting language and SQL reference
Database
Core features of DolphinDB's distributed architecture, basic database operations, and configuration setup.
Streaming
Publish, subscribe to, and process streaming data
Migration
Import and migrate data from various data sources to DolphinDB databases
Maintenance
Database maintenance and system management
Troubleshooting
Common errors and corresponding solutions
Function References
Reference for all built-in functions
- Categories
- Functions
  - A
  - B
  - C
  - D
  - E
  - F
  - G
  - H
  - I
  - J
  - K
  - L
  - M
  - N
  - O
  - P
  - Q
  - R
  - S
  - T
  - U
  - V
  - W
  - X
  - Y
  - Z
- Themes
- Templates
- Python-DolphinDB Equivalents
API & Connector
API in different languages for users to call DolphinDB from their programs
Plugins
Guidance on the use of plugins and plugin development for multiple application scenarios
Tutorials
Tutorials on database concepts and application scenarios
Release Notes
Release notes and compatibility changes for DolphinDB server, plugins and APIs

nanInfFill

Syntax

nanInfFill(X,Y)

Details

In DolphinDB, NaN and Inf values of floating-point numbers are replaced with null values. Nan and Inf values can arise in the course of data import, or during calculations involving external data sources.

This function replaces the NaN/Inf value in X with the specified Y.

Note:

When X is a dictionary, only dictionary values are replaced.

Parameters

X is a floating-point number of any data form except for set.

Y is a floating-point number.

Returns

An floating point with the same data form as X.

Examples

x = [float(`inf), 2, 3, float(`nan), 5, 6, 7]
nanInfFill (x, 2.2)

x = matrix(1..3, [float(`inf), float(`nan), 1.0])
nanInfFill(x, 1.2)

Related functions: isNanInf, countNanInf