.. _auto_dataset_group_and_aggregate_by:

*DATASET GROUP AND AGGREGATE BY*
================================

Groups a dataset by a specified column and computes an aggregate (average, min, max, or sum) of a second column within each group. Use this worker to summarize or roll up tabular data by category before downstream analysis or reporting.

When to use
-----------

Classification: **process**.

Tagged: ``aggregate``, ``avg``, ``dataset_transform``, ``group_by``, ``max``, ``min``, ``rollup``, ``sum``.

Inputs
------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20 20 20

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Choose Dataset
     - dataset
     - dataset
     - —
     - 
     - Input tabular dataset to be grouped and aggregated; accepts any d3VIEW dataset object — leave empty only if the dataset is provided dynamically by a preceding worker.
   * - Group By
     - groupby
     - scalar
     - unclassified
     - 
     - Name of the column whose distinct values define the groups (e.g., a category or label column); defaults to 'unclassified' — must be changed to a valid column name in the connected dataset.
   * - Aggregate By
     - aggregateby
     - scalar
     - unclassified
     - 
     - Name of the numeric column whose values will be aggregated within each group (e.g., a measurement or KPI column); defaults to 'unclassified' — must be changed to a valid numeric column name.
   * - Aggregation Type
     - aggregation_type
     - string
     - avg
     - 
     - Aggregation function applied to the target column within each group — choose from 'avg' (mean), 'min', 'max', or 'sum'; defaults to 'avg'.

Outputs
-------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20

   * - Label
     - ID
     - Type
     - Description
   * - dataset_group_and_aggregate_by_output_1
     - dataset_group_and_aggregate_by_output_1
     - dataset
     - Resulting dataset with one row per unique group-by value and a single aggregated column, ready for further processing or visualization.

Disciplines
-----------

- data.dataset.transform
- data.statistics

Runnable example
----------------

A runnable example is registered for this worker. Open the example workflow on the d3VIEW canvas: `/api/workflow/example?id=dataset_group_and_aggregate_by <https://www.d3view.com/api/workflow/example?id=dataset_group_and_aggregate_by>`_

.. raw:: html

   <hr style="margin-top:2em">
   <p style="font-size:11px;color:#888">
   Auto-generated from <code>transformation</code> schema. Worker id: <code>dataset_group_and_aggregate_by</code>. Schema hash: <code>eeebdc47584e</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>