Column stats
Opening the stats panel
Section titled “Opening the stats panel”Double-click any column header to open the stats panel for that column.
Alternatively, hold Shift and click a column header.
What’s shown
Section titled “What’s shown”Columnar computes the following statistics for every column:
For all columns
Section titled “For all columns”| Stat | Description |
|---|---|
| Type | Numeric or String — auto-detected based on column contents |
| Count | Total number of rows |
| Unique | Number of distinct values |
| Nulls | Number of empty cells |
| Min | Smallest value (alphabetically for strings, numerically for numbers) |
| Max | Largest value |
| Sample | Up to 5 non-empty values from the column |
For numeric columns only
Section titled “For numeric columns only”| Stat | Description |
|---|---|
| Mean | Arithmetic average |
| Median | Middle value when sorted |
| Std Dev | Standard deviation |
Type detection
Section titled “Type detection”A column is classified as Numeric if more than 80% of its non-empty values parse as a valid decimal number. Otherwise it is classified as String.
This means a column with occasional non-numeric values (like N/A or -) may still be classified as Numeric if the majority of rows contain numbers.
Performance on large files
Section titled “Performance on large files”Stats are computed with a full parallel pass through the file for the selected column. On a 14 GB file this takes a few seconds. The loading overlay shows Computing stats… while this is running.
Closing the panel
Section titled “Closing the panel”Click the ✕ button in the top-right of the stats panel, or press Escape.