aggregate_sheet
Group and aggregate Excel sheet data by chosen columns, applying aggregation functions such as sum or average to summarize values.
Instructions
Group and aggregate sheet data with pandas (e.g. sum sales by region).
Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. group_by: Column names to group by (taken from the header row). agg: Mapping of column name to aggregation function, e.g. {"amount": "sum"}. cell_range: Optional A1-style range to read before aggregating. has_header: Whether the first row of the range holds column names.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| agg | Yes | ||
| path | No | ||
| sheet | Yes | ||
| group_by | Yes | ||
| cell_range | No | ||
| has_header | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||