IDAX.EMDISC - Discretization bins of minimal entropy

Use this stored procedure to calculate the limits for discretization bins of minimal entropy on numeric columns that minimize the entropy of the target column of the input table. Each bin contains the approximate equal number of data records.

Authorization

The privileges held by the authorization ID of the statement must include the IDAX_USER role.

Syntax

IDAX.EMDISC(in parameter_string varchar(32672))

Parameter descriptions

parameter_string

Mandatory one-string parameter that contains pairs of <parameter>=<value> entries that are separated by a comma.

Data type: VARCHAR(32672)

The following list shows the parameter values:

intable: Mandatory.; The name of the input table.; Data type: VARCHAR(ANY)
outtable: Mandatory.; The name of the output table where the limit for the discretization bins is to be stored.; The colname column references the name of the columns of the input table columns.; The break column a bin limit for this column.; Data type: VARCHAR(ANY)
incolumn: Mandatory.; The columns of the input table that are separated by a semi-colon (;).; Data type: VARCHAR(ANY)
target: Optional.; The column of the input table that contains a class label.; Default: 10; Data type: INTEGER

Returned information

INTEGER the number of columns for which the limits for the discretization bins are calculated.

Example

call IDAX.EMDISC('intable=SAMPLES.CUSTOMER_CHURN, outtable=CUSTOMER_CHURN_BINS, incolumn=AVG_SPENT_RETAIN_PM;ANNUAL_REVENUE_MIL, target=CENSOR');
select COLNAME, BREAK from CUSTOMER_CHURN_BINS;