xlsx_aggregate
Group rows in a local .xlsx file by specified columns, then compute aggregations like sum, mean, count, or distinct count per group. Returns a markdown table of grouped results.
Instructions
pandas-style df.groupby([cols]).agg({col: func}) on a LOCAL .xlsx file. funcs: sum / mean / min / max / count / count_distinct. Type-aware: numeric aggregations skip non-numeric values cleanly instead of pandas' silent NaN promotion.
USE WHEN: the user asks "what's the total / average / count of X by Y?" on a LOCAL .xlsx file. Returns one row per group with the requested aggregations as a markdown table.
DO NOT USE WHEN: the user wants to see individual rows (use xlsx_filter). Or for a 2D pivot (use xlsx_pivot).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| aggs | Yes | ||
| file_b64 | Yes | ||
| group_by | Yes | ||
| options | No |