aggregate
Count or sum values in a table grouped by specified columns, providing quick aggregation without SQL complexity.
Instructions
Simplified aggregation on a DuckDB table.
Easier than SQL for common count/sum/group-by queries.
Example: aggregate(table="t_abc_0", group_by=["xã"], agg="count")
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| agg | No | count | |
| table | Yes | ||
| filter | No | ||
| group_by | Yes | ||
| agg_column | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||