hclust.FLTable: Hierarchial Clustering

In Fuzzy-Logix/AdapteR: Converts R syntax to SQL to provide fast analytics using in-database C++ library DB Lytix.

Description

hclust computes hierarchial clustering on FLTable objects.

Usage

## S3 method for class 'FLTable'
hclust(d, method = "average", maxit = 500,
  excludeCols = "", classSpec = list(), whereconditions = "", ...)

Arguments

d	an object of class FLTable, can be wide or deep table
method	character. Allowed methods are "average", "single", "complete", "centroid"
maxit	maximum number of iterations
excludeCols	the comma separated character string of columns to be excluded
classSpec	list describing the categorical dummy variables
whereconditions	takes the where_clause as a string

Value

hclust returns a list and replicates equivalent R output from hclust in stats package.The mapping table can be viewed using object$mapping if input is wide table.

Constraints

Error is thrown if results cannot be fetched. maxit should be more than no.of. observations for algorithm to reach completion. Error is thrown if algorithm does not reach completion or more than one cluster is formed at any step.

If classSpec is not specified, the categorical variables are excluded from analysis by default.

Examples

deeptable  <- FLTable("tblUSArrests", "ObsID","VarID","Num_Val")
hclustobject <- hclust(deeptable,maxit=50)
print(hclustobject)
plot(hclustobject)

Fuzzy-Logix/AdapteR documentation built on May 6, 2019, 5:07 p.m.