5.7
Column Data Statistics
Column data statistics can be used to find out basic statistical information about your column values without moving the data somewhere else like Excel. They are calculated for each column and are different for each column data type group: Numerical, Textual, Binary, Temporal, Other.

All columns include total, null, non-null and distinct row counts, top 40 most and least frequent values.

Numerical columns also include min, max, median, average and standard deviation of column values.
Textual columns also include min and max of column text values; min, max, median and average text lengths; min, max, median and average of word counts (split on whitespace only).
Binary columns also include min, max, median, and average of column data lengths, and min and max of column values.
Temporal columns also include min and max of column value.
Other columns also include min and max of column value.

All columns from each data type group mentioned above can be shown or hidden in the data statistics control for better visibility.

The UI uses visual cues to better represent statistical information like median, average or most/least frequent values.
© Mladen Prajdić 2007 - 2021           VAT ID: SI45538972