Vekbox logoVekbox Tools

CSV Group By & Aggregate

CSV input
Group keys
Column
Resolved
city
Aggregations
Column
Operator
Alias (optional)
Column
Operator
Alias (optional)
Column
Operator
Alias (optional)
Aggregated CSV
Options
Parsing
Output

About Group By & Aggregate

Group rows by one or more columns and compute aggregates such as count, countDistinct, sum, avg, min, and max. Use column names when a header exists, or reference columns by index (#1, c2, 3 for 1-based indexing).

Tips

  • Enable Numeric for numeric aggregations to ignore non-numeric values safely.
  • Use aliases to control output column names (e.g., total_sales).
  • Switch output delimiter to generate TSV (\t) or pipe-separated results quickly.