massive_iqr

hana_ml.algorithms.pal.stats.massive_iqr(data, group_key=None, key=None, col=None, multiplier=None, thread_ratio=None)

Massive version of iqr().

This function calls SAP HANA PAL function PAL_MASSIVE_IQRTEST to run inter-quartile range (IQR) test in parallel across multiple independent datasets identified by a group id.

Parameters
dataDataFrame

Input data for IQR test in massive mode.

This DataFrame must be structured as follows:

  • 1st column : GROUP ID, type INT, VARCHAR or NVARCHAR.

  • 2nd column : ID, type INT, VARCHAR or NVARCHAR.

  • 3rd column : raw data, type INTEGER, DOUBLE, or DECIMAL(p,s).

group_keystr, optional

Name of the group id column. If not provided, it defaults to:

  • the first index column of data if data is indexed, otherwise

  • the first column of data.

keystr, optional

Name of the ID column in data.

If not specified, it defaults to:

  • the second index column of data if data has multiple index columns and the first one is used as group_key, otherwise

  • the first non-group_key column of data.

colstr, optional

Name of the raw data column in the dataframe.

If not specified, defaults to the last column of data excluding group_key and key.

multiplierfloat, optional

Same meaning as in iqr().

thread_ratiofloat, optional

Adjusts the percentage of available threads to use, from 0 to 1.

Returns
DataFrames

DataFrame 1 : result output with an additional group id column.

DataFrame 2 : statistics output with an additional group id column.

DataFrame 3 : error message table for massive execution.