Lipi Reference Lipi

Functions

nz()

Replaces NaN values with zeros (or given value) in a series.

Syntax · 1 of 5

                nz(series int value, series int alt) → series int
              

Arguments

value required series int Value that will replace all ‘na’ values in the source series.
alt series int Series of values to process.

Return Type

series int

Syntax · 2 of 5

                nz(series float value, series float alt) → series float
              

Arguments

value required series float Value that will replace all ‘na’ values in the source series.
alt series float Series of values to process.

Return Type

series float

Syntax · 3 of 5

                nz(series string value, series string alt) → series string
              

Arguments

value required series string Value that will replace all ‘na’ values in the source series.
alt series string Series of values to process.

Return Type

series string

Syntax · 4 of 5

                nz(series bool value, series bool alt) → series bool
              

Arguments

value required series bool Value that will replace all ‘na’ values in the source series.
alt series bool Series of values to process.

Return Type

series bool

Syntax · 5 of 5

                nz(series color value, series color alt) → series color
              

Arguments

value required series color Value that will replace all ‘na’ values in the source series.
alt series color Series of values to process.

Return Type

series color