IDAX.ACC - Calculate the classification accuracy

Use this stored procedure to calculate the ratio of correctly classified predictions among the total number of predictions. For the calculation, the predictions that are made when a classification model is applied on data are compared to the real values of this data.

Authorization

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

Syntax

IDAX.ACC(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 that contains the real values.; Data type: VARCHAR(256)
target: Mandatory.; The column of the input table that contains the values that are to be predicted.; Data type: VARCHAR(128)
id: Mandatory.; The column of the input table that identifies a unique instance ID.; Data type: VARCHAR(128)
resulttable: Mandatory.; The name of the input table that contains the predicted values.; Data type: VARCHAR(256)
resulttarget: Optional.; The column of the input table that contains the predicted values.; Default: class; Data type: VARCHAR(128)
resultid: Optional.; The column of the input table that identifies a unique instance ID.; Default: "ID"; Data type: VARCHAR(128)

Returned information

Double the classification accuracy as a result set.

Example

CALL IDAX.SPLIT_DATA('intable=samples.customer_churn,traintable=cust_train,testtable=cust_test,id=cust_id,fraction=0.30');
CALL IDAX.GROW_DECTREE('model=cust_dt, intable=cust_train, id=cust_id, target=censor, incolumn=duration:ignore;censor:nom, minsplit=2');
CALL IDAX.PREDICT_DECTREE('model=cust_dt, intable=cust_test, outtable=cust_dt_out');
call IDAX.ACC('intable=cust_test, id=cust_id, target=censor, resulttable=cust_dt_out');