Type Alias FieldInTableProfilingData

type FieldInTableProfilingData = {
    qAverage?: number;
    qAvgStringLen?: number;
    qDataEvenness?: number;
    qDistinctNumericValues?: number;
    qDistinctTextValues?: number;
    qDistinctValues?: number;
    qEmptyStrings?: number;
    qFieldTags?: string[];
    qFirstSorted?: string;
    qFractiles?: number[];
    qFrequencyDistribution?: FrequencyDistributionData;
    qKurtosis?: number;
    qLastSorted?: string;
    qMax?: number;
    qMaxStringLen?: number;
    qMedian?: number;
    qMin?: number;
    qMinStringLen?: number;
    qMostFrequent?: SymbolFrequency[];
    qName?: string;
    qNegValues?: number;
    qNullValues?: number;
    qNumberFormat?: FieldAttributes;
    qNumericValues?: number;
    qPosValues?: number;
    qSkewness?: number;
    qStd?: number;
    qSum?: number;
    qSum2?: number;
    qSumStringLen?: number;
    qTextValues?: number;
    qZeroValues?: number;
}
Index

Properties

qAverage? qAvgStringLen? qDataEvenness? qDistinctNumericValues? qDistinctTextValues? qDistinctValues? qEmptyStrings? qFieldTags? qFirstSorted? qFractiles? qFrequencyDistribution? qKurtosis? qLastSorted? qMax? qMaxStringLen? qMedian? qMin? qMinStringLen? qMostFrequent? qName? qNegValues? qNullValues? qNumberFormat? qNumericValues? qPosValues? qSkewness? qStd? qSum? qSum2? qSumStringLen? qTextValues? qZeroValues?

Properties

qAverage?: number

Average of all numerical values. NaN otherwise.

qAvgStringLen?: number

Average string length of textual values. 0 otherwise.

qDataEvenness?: number

Data evenness aka Shannon's entropy normalized to [0,1]

qDistinctNumericValues?: number

Number of distinct numeric values

qDistinctTextValues?: number

Number of distinct text values

qDistinctValues?: number

Number of distinct values

qEmptyStrings?: number

Number of empty strings

qFieldTags?: string[]

List of tags related to the field.

qFirstSorted?: string

For textual values the first sorted string.

qFractiles?: number[]

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

qFrequencyDistribution?: FrequencyDistributionData

Frequency Distribution for numeric fields.

qKurtosis?: number

Kurtosis of the numerical values. NaN otherwise.

qLastSorted?: string

For textual values the last sorted string.

qMax?: number

Maximum value of numerical values. NaN otherwise.

qMaxStringLen?: number

Maximum string length of textual values. 0 otherwise.

qMedian?: number

Median of all numerical values. NaN otherwise.

qMin?: number

Minimum value of numerical values. NaN otherwise.

qMinStringLen?: number

Minimum string length of textual values. 0 otherwise.

qMostFrequent?: SymbolFrequency[]

Three most frequent values and their frequencies

qName?: string

Name of the field.

qNegValues?: number

Number of negative values

qNullValues?: number

Number of null values

qNumberFormat?: FieldAttributes
qNumericValues?: number

Number of numeric values

qPosValues?: number

Number of positive values

qSkewness?: number

Skewness of the numerical values. NaN otherwise.

qStd?: number

Standard deviation of numerical values. NaN otherwise.

qSum?: number

Sum of all numerical values. NaN otherwise.

qSum2?: number

Squared sum of all numerical values. NaN otherwise.

qSumStringLen?: number

Sum of all characters in strings in the field

qTextValues?: number

Number of textual values

qZeroValues?: number

Number of zero values for numerical values

Settings

Member Visibility

On This Page

Properties