FieldInTableProfilingData

Stability index

EXPERIMENTAL.
This API is under development. Do not rely on it. It may change or be removed in future versions.

Properties

Name Description Type
qName

Name of the field.

String
qFieldTags

List of tags related to the field.

Array of Strings
qNumberFormat FieldAttributes
qDistinctValues

Number of distinct values

Integer
qNumericValues

Number of numeric values

Integer
qNullValues

Number of null values

Integer
qTextValues

Number of textual values

Integer
qNegValues

Number of negative values

Integer
qPosValues

Number of positive values

Integer
qZeroValues

Number of zero values for numerical values

Integer
qSum

Sum of all numerical values. NaN otherwise.

Double
qSum2

Squared sum of all numerical values. NaN otherwise.

Double
qAverage

Average of all numerical values. NaN otherwise.

Double
qMedian

Median of all numerical values. NaN otherwise.

Double
qStd

Standard deviation of numerical values. NaN otherwise.

Double
qMin

Minimum value of numerical values. NaN otherwise.

Double
qMax

Maximum value of numerical values. NaN otherwise.

Double
qSkewness

Skewness of the numerical values. NaN otherwise.

Double
qKurtosis

Kurtosis of the numerical values. NaN otherwise.

Double
qFractiles

The .01, .05, .1, .25, .5, .75, .9, .95, .99 fractiles. Array of NaN otherwise.

Array of Doubles
qEmptyStrings

Number of empty strings

Integer
qMaxStringLen

Maximum string length of textual values. 0 otherwise.

Integer
qMinStringLen

Minimum string length of textual values. 0 otherwise.

Integer
qSumStringLen

Sum of all characters in strings in the field

Integer
qAvgStringLen

Average string length of textual values. 0 otherwise.

Double
qFirstSorted

For textual values the first sorted string.

String
qLastSorted

For textual values the last sorted string.

String