Aggregators
An aggregator defines how a column reduces multiple values to a single number. Aggregators are used in Frequency Tables (Shift+F), Pivot Tables (Shift+W), and the Describe Sheet (Shift+I). You can also compute an aggregate instantly in the status bar without opening any sheet.
Learning Focus
Use + <aggregator> to set a column's aggregator before opening a Frequency or Pivot table. Use z+ <aggregator> for instant results right in the status bar.
Set an Aggregator
+ <aggregator> set aggregator for current column
z+ <aggregator> set aggregator AND show result instantly in status bar
g+ <aggregator> set aggregator for selected columns (in Columns Sheet)
Examples:
# Set salary aggregator to mean
# Move to 'salary' column (cast to float first: %)
+ mean
# Now open Frequency Table on 'department'
# Move to 'department' column
Shift+F
# → shows mean salary per department
Instant Status Bar Calculation (z+)
Use z+ as a quick calculator — no sheet needed.
# Move to 'salary' column
z+ sum
# Status bar shows: sum: 390000
z+ mean
# Status bar shows: mean: 78000
z+ max
# Status bar shows: max: 90000
z+ min
# Status bar shows: min: 65000
z+ count
# Status bar shows: count: 5
z+ stdev
# Status bar shows: stdev: 9560.43
The calculation applies to all currently visible rows. If rows are selected, it applies only to the selection.
Aggregator Reference
| Aggregator | Description | Compatible Types |
|---|---|---|
sum | Sum of all values | int, float, currency |
mean | Arithmetic mean | int, float, currency |
median | Median value | int, float, currency |
min | Minimum value | int, float, date, str |
max | Maximum value | int, float, date, str |
count | Count of non-null values | Any |
stdev | Standard deviation | int, float |
distinct | Set of distinct values | Any |
list | All values as a Python list | Any |
most_common | Most frequent value | Any |
q3 / q4 / q5 | Quantile bins (tertile/quartile/quintile) | int, float |
Bulk Set Aggregators (Columns Sheet)
Set aggregators on multiple columns at once:
Shift+C # open Columns Sheet
# Select numeric column rows
| # regex select
# Enter: salary|amount|cost|price
# Set mean aggregator for all selected
g+ mean
q # return to source sheet
See Columns Sheet Operations for details.
Aggregators in Analysis Sheets
- Frequency Table (
Shift+F): shows the aggregator value for each group in the current column - Pivot Table (
Shift+W): shows aggregator values for row × column intersections - Describe Sheet (
Shift+I): profiles each column with multiple aggregators automatically
For detailed workflows, see:
Quick Reference
| Key | Action |
|---|---|
+ <agg> | Set aggregator on current column |
z+ <agg> | Set aggregator and show result in status bar |
g+ <agg> | Set aggregator on selected columns (Columns Sheet) |
What's Next
- Columns Sheet Operations — bulk column metadata management
- Frequency Tables — group and aggregate by column values