Arrays in the Factory

Arrays are functions which perform operations on the whole column, and not on the single values in each cell.

Rulex Platform formula

Function

Formula

Description

enum

enum(group)

Enumerates the rows in a dataset, in ascending order, optionally grouped by a selected attribute.

fillDown

fillDown(column, group, fillall)

Returns a copy of the specified column, filling all the missing values with the last valid value, optionally grouped by selected attributes.

If there are rows which remain empty, as they do not have a previous valid value, a fillUp operation can then be performed, using the next valid value.

fillLinear

fillLinear(column, group)

Fills any missing values for a specified attribute with a value, based on the other values present in the attribute, using a linear interpolation method.

The linear interpolation links two adjacent values with a straight line, graphically: this means that the gap is filled with values with equal distance one to the other.

fillUp

fillLinear(column, group)

Returns a copy of the selected column, filling all the missing values with the next valid value, optionally grouped by selected attributes.

If there are rows which remain empty, as they do not have a next valid value, a fillDown operation can then be performed, using the previous valid value.

integer

integer(column)

Returns the values of the specified attribute, cast to the integer data type.

len

len(column)

Returns the number of values present in the attribute, including missing values.

matchHeaders

matchHeaders(column)

Returns the value in the corresponding row for the selected column.

nominal

nominal(column)

Returns the values of the specified attribute cast to the nominal data type.

perm

perm(column)

Returns the values of a selected attribute in a random order.

rank

rank(column, usemissing)

Returns the values of a column in ascending alphabetic order. By default missing values are considered in the ranking.

shift

shift(column, shift, group, cyclic)

Returns the attribute column shifted by the shift value. The shift can be performed according to the groups defined in the group parameter.

Parameters in bold are mandatory.