ibmdbR (version 1.34.3)

idaTable: In-Database Cross Tabulation and Table Creation

Description

Function used to build a contingency table of the counts at each combination of factor levels based on the contents of a IDA data frame (ida.data.frame).

Usage

idaTable(idadf,max.entries=1000)

Arguments

idadf

A IDA data frame that contains the input data for the function.

max.entries

The maximum number of entries. If the cross product of all columns exceeds this number, an error will be thrown.

Value

• The idaTable function returns a contingency table, an object of class "table".

Details

idaTable uses the cross-classifying factors to build a contingency table of the counts at each combination of categorical values in all categorical columns of the ida.data.frame passed as input.

Examples

systypes<-ida.data.frame('DB2INST1.SHOWCASE_SYSTYPES')
systypes$unix <- ifelse(systypes$DESCRIPTION!='Windows','T','F')

idaTable(systypes)