Groupby Summarizer
Group CSV rows by a key column and aggregate values (sum, mean, count, min, max).
About this tool
Choose a key column and a value column, pick an aggregation, and get one row per group. It is the SQL GROUP BY in one step: total revenue per region, average score per class, count of orders per customer.
How to use
How it works
Rows are bucketed by the key column and the chosen function is applied to the value column of each bucket. Groups appear in order of first appearance. The result column is named like sum_revenue. Only one key and one value column are used per run.
Worked example
Revenue per region
- Input
- Group key: region Value: revenue Aggregation: sum (sales table with 7 rows)
- Output
- North: 280 South: 260 East: 75
- Walkthrough
- North has revenue 100 + 80 + 100 = 280, South 70 + 190 = 260 and East 30 + 45 = 75.
Limitations
- One key column and one value column per run.
- A column name that does not exist stops with a Column not found error.
- Output is JSON rather than a CSV download.
Questions
How do I group by a column in a CSV?
Which aggregations are available?
Can I group by two columns?
Does column name case matter?
Features
- Sum, mean, count, min, max
- Order of first appearance
- Runs in your browser
Related resources
Guides and videos from around the web—opens on YouTube or the publisher’s site.
Mean, Variance and Standard Deviation
StatQuest with Josh Starmer
Spread metrics when analyzing pasted datasets.
Watch on YouTubeMachine Learning for Everybody
freeCodeCamp.org
Data prep context before ML-oriented helpers.
Watch on YouTube
- Data Index
Math is Fun
Stats explainers when summarizing columns.
- Fetch API
MDN
How browsers pull remote data into local tools.