# Summarize & Group

![](https://lh7-us.googleusercontent.com/0Dl4npXW3Xu_Nd5UsJkk-xU0kRNG77uaMAwOctrOH8Y4vmnoeU1W29fCSxHxTBLdZPqkALZf1K6-9jXvsec-IGNM3dGfYlKv5f40f5MXqyJJySXOuw9BmTdx_T1T89cLObB6kXTVF6_kthviLxrRv4Y)

\
Summarize & Group is perhaps Datawisp’s most powerful block, giving the ability to count rows, make groups, calculate summary statistics, and much more. By default, no groups or calculations are selected, so Summarize & Group simply counts the number of rows coming into the block.

![](https://lh7-us.googleusercontent.com/NuSjES_QgGP7k6dI4mLL6EYjTmRZoBMBlGvA-YoNtUltSEi5o6Yf3JfmC_D6QHGtAZhnwOwqfz_PMKyyQrWsyTWLz_XS9R7CP9Nbz4_1IMLr-j21_uFz5v4EMf0hpzCyPRdHWbPta3M2eEAv53aDkm0)

Group Data By allows the selection of subgroups. Similar to a SQL Group By statement, any number of columns can be selected and, by default, the counts in those subgroup combinations will be generated. With a single group selected (ex. Primary Fur Color) the count column now shows the number of rows (squirrels) of each Primary Fur Color. Note that the sum of each of these groups would be equal to the original 3,032 above.&#x20;

![](https://lh7-us.googleusercontent.com/WxubFrb27GYOpc1BJBujZOdsZYhprs8xPG3PEvgaN7Y1sLG4wDpEYUFiNbtfUeJX4YW6-BAow8Ug4ZYbSo8LGV5sXIsGVwmmy-5dcUoPWFIuldqPV4UOAWibnljUFy0RBFs3TCtHn739g-w9B2b5EbM)<br>

When multiple groups are selected, this further breaks down the groups as seen below.

![](https://lh7-us.googleusercontent.com/96-aBhSLL9WKYPkyiIBwQpB4zO5lz1NUM9RoMGt_YWLOxftGAaU-Apk_BJfYkfLTtFXUn-LU1lPC1uptNOZWZL_KozBnufwq9-3jHxUncF5Tad1YxHcx77jVALF6aV5utOwkptsL0ULvT9rc6eAz_dI)

\
To add a Value to calculate in addition to just count, additional columns can be chosen here as well. Min, max, sum, and avg of numeric features can be calculated for each group selected. Used together, these summary statistics can summarize large datasets by consolidating them into a few meaningful rows.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.datawisp.io/analyzing-data/datawisp-blocks/summarize-and-group.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
