@Override public Number getValue(final String parameter) { return _columnStatisticsCrosstab .where(BooleanAnalyzer.DIMENSION_MEASURE, BooleanAnalyzer.MEASURE_NULL_COUNT) .where(BooleanAnalyzer.DIMENSION_COLUMN, parameter).safeGet(0); }
@Override public Number getValue(final String parameter) { return _columnStatisticsCrosstab .where(BooleanAnalyzer.DIMENSION_MEASURE, BooleanAnalyzer.MEASURE_TRUE_COUNT) .where(BooleanAnalyzer.DIMENSION_COLUMN, parameter).safeGet(0); }
@Metric(StringAnalyzer.MEASURE_MAX_WHITE_SPACES) public int getMaxWhitespaces(final InputColumn<?> col) { return (Integer) getCrosstab().where(StringAnalyzer.DIMENSION_COLUMN, col.getName()) .where(StringAnalyzer.DIMENSION_MEASURES, StringAnalyzer.MEASURE_MAX_WHITE_SPACES).get(); }
@Metric(StringAnalyzer.MEASURE_MAX_WORDS) public int getMaxWords(final InputColumn<?> col) { return (Integer) getCrosstab().where(StringAnalyzer.DIMENSION_COLUMN, col.getName()) .where(StringAnalyzer.DIMENSION_MEASURES, StringAnalyzer.MEASURE_MAX_WORDS).get(); }
@Metric(StringAnalyzer.MEASURE_MIN_WORDS) public int getMinWords(final InputColumn<?> col) { return (Integer) getCrosstab().where(StringAnalyzer.DIMENSION_COLUMN, col.getName()) .where(StringAnalyzer.DIMENSION_MEASURES, StringAnalyzer.MEASURE_MIN_WORDS).get(); }
@Metric(StringAnalyzer.MEASURE_TOTAL_CHAR_COUNT) public int getTotalCharCount(final InputColumn<?> col) { return (Integer) getCrosstab().where(StringAnalyzer.DIMENSION_COLUMN, col.getName()) .where(StringAnalyzer.DIMENSION_MEASURES, StringAnalyzer.MEASURE_TOTAL_CHAR_COUNT).get(); }
@Metric(StringAnalyzer.MEASURE_UPPERCASE_CHARS) public int getUpperCaseChars(final InputColumn<?> col) { return (Integer) getCrosstab().where(StringAnalyzer.DIMENSION_COLUMN, col.getName()) .where(StringAnalyzer.DIMENSION_MEASURES, StringAnalyzer.MEASURE_UPPERCASE_CHARS).get(); }
@Metric(order = 4, value = NumberAnalyzer.MEASURE_LOWEST_VALUE) public Number getLowestValue(final InputColumn<?> col) { return (Number) getCrosstab().where(NumberAnalyzer.DIMENSION_COLUMN, col.getName()) .where(NumberAnalyzer.DIMENSION_MEASURE, NumberAnalyzer.MEASURE_LOWEST_VALUE).safeGet(null); }
@Metric(order = 20, value = NumberAnalyzer.MEASURE_MEDIAN) public Number getMedian(final InputColumn<?> col) { return (Number) getCrosstab().where(NumberAnalyzer.DIMENSION_COLUMN, col.getName()) .where(NumberAnalyzer.DIMENSION_MEASURE, NumberAnalyzer.MEASURE_MEDIAN).safeGet(null); }
@Metric(order = 23, value = NumberAnalyzer.MEASURE_KURTOSIS) public Number getKurtosis(final InputColumn<?> col) { return (Number) getCrosstab().where(NumberAnalyzer.DIMENSION_COLUMN, col.getName()) .where(NumberAnalyzer.DIMENSION_MEASURE, NumberAnalyzer.MEASURE_KURTOSIS).safeGet(null); }
@Metric(StringAnalyzer.MEASURE_AVG_WHITE_SPACES) public double getAvgWhitespaces(final InputColumn<?> col) { return (Double) getCrosstab().where(StringAnalyzer.DIMENSION_COLUMN, col.getName()) .where(StringAnalyzer.DIMENSION_MEASURES, StringAnalyzer.MEASURE_AVG_WHITE_SPACES).get(); }
@Metric(StringAnalyzer.MEASURE_ENTIRELY_UPPERCASE_COUNT) public int getEntirelyUpperCaseCount(final InputColumn<?> col) { return (Integer) getCrosstab().where(StringAnalyzer.DIMENSION_COLUMN, col.getName()) .where(StringAnalyzer.DIMENSION_MEASURES, StringAnalyzer.MEASURE_ENTIRELY_UPPERCASE_COUNT).get(); }
@Metric(StringAnalyzer.MEASURE_MIN_WHITE_SPACES) public int getMinWhitespaces(final InputColumn<?> col) { return (Integer) getCrosstab().where(StringAnalyzer.DIMENSION_COLUMN, col.getName()) .where(StringAnalyzer.DIMENSION_MEASURES, StringAnalyzer.MEASURE_MIN_WHITE_SPACES).get(); }
@Metric(order = 2, value = NumberAnalyzer.MEASURE_NULL_COUNT) public Number getNullCount(final InputColumn<?> col) { return (Number) getCrosstab().where(NumberAnalyzer.DIMENSION_COLUMN, col.getName()) .where(NumberAnalyzer.DIMENSION_MEASURE, NumberAnalyzer.MEASURE_NULL_COUNT).get(); }
@Metric(order = 3, value = NumberAnalyzer.MEASURE_HIGHEST_VALUE) public Number getHighestValue(final InputColumn<?> col) { return (Number) getCrosstab().where(NumberAnalyzer.DIMENSION_COLUMN, col.getName()) .where(NumberAnalyzer.DIMENSION_MEASURE, NumberAnalyzer.MEASURE_HIGHEST_VALUE).safeGet(null); }
@Metric(order = 6, value = NumberAnalyzer.MEASURE_MEAN) public Number getMean(final InputColumn<?> col) { return (Number) getCrosstab().where(NumberAnalyzer.DIMENSION_COLUMN, col.getName()) .where(NumberAnalyzer.DIMENSION_MEASURE, NumberAnalyzer.MEASURE_MEAN).safeGet(null); }
@Metric(order = 9, value = DateAndTimeAnalyzer.MEASURE_SKEWNESS) public Number getSkewness(final InputColumn<?> col) { return (Number) getCrosstab().where(DateAndTimeAnalyzer.DIMENSION_COLUMN, col.getName()) .where(DateAndTimeAnalyzer.DIMENSION_MEASURE, DateAndTimeAnalyzer.MEASURE_SKEWNESS).safeGet(null); } }
@Metric(order = 4, value = DateAndTimeAnalyzer.MEASURE_MEAN) @Description("The mean value for the given column. The value is measured in number of days since 1970-01-01.") public Number getMean(final InputColumn<?> col) { final String s = (String) getCrosstab().where(DateAndTimeAnalyzer.DIMENSION_COLUMN, col.getName()) .where(DateAndTimeAnalyzer.DIMENSION_MEASURE, DateAndTimeAnalyzer.MEASURE_MEAN).safeGet(null); return convertToDaysSinceEpoch(s); }
@Metric(order = 6, value = DateAndTimeAnalyzer.MEASURE_PERCENTILE25) @Description( "The 25th percentile value for the given column. The value is measured in number of days since 1970-01-01.") public Number getPercentile25(final InputColumn<?> col) { final String s = (String) getCrosstab().where(DateAndTimeAnalyzer.DIMENSION_COLUMN, col.getName()) .where(DateAndTimeAnalyzer.DIMENSION_MEASURE, DateAndTimeAnalyzer.MEASURE_PERCENTILE25).safeGet(null); return convertToDaysSinceEpoch(s); }
@Metric(order = 5, value = DateAndTimeAnalyzer.MEASURE_MEDIAN) @Description("The median value for the given column. The value is measured in number of days since 1970-01-01.") public Number getMedian(final InputColumn<?> col) { final String s = (String) getCrosstab().where(DateAndTimeAnalyzer.DIMENSION_COLUMN, col.getName()) .where(DateAndTimeAnalyzer.DIMENSION_MEASURE, DateAndTimeAnalyzer.MEASURE_MEDIAN).safeGet(null); return convertToDaysSinceEpoch(s); }