Groupby Summarizer

Group CSV rows by a key column and aggregate values (sum, mean, count, min, max).

FreeNo accountOn your device

Runs in your browser. How to verify

Loading tool…

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

1
Step 1
Paste the CSV or drop a file.
2
Step 2
Enter the group key column and the value column (names are not case-sensitive).
3
Step 3
Pick sum, mean, count, min or max and press Process.

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?
Enter the key column, the value column and an aggregation, then press Process.
Which aggregations are available?
sum, mean, count, min and max.
Can I group by two columns?
Not in one run. Use the pivot table builder to cross two columns.
Does column name case matter?
No, matching ignores case.

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 YouTube
  • Machine 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.