DATASET GET MEAN SD BY GROUP¶
Computes the mean and sample standard deviation of one or more numeric target columns, grouped by one or more categorical/grouping (input) columns. Use this worker whenever you need a summary statistics table broken down by group — equivalent to a SQL GROUP BY with AVG and STDDEV aggregates.
When to use¶
Tagged: aggregation, descriptive_stats, groupby, mean, standard_deviation, summary_statistics.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Dataset | dataset | dataset | — | ✓ | Tabular input dataset to be aggregated; must be an array-of-row-objects where each row contains all referenced input and target columns. |
| Input Columns | input_columns | text | — | One or more columns whose combined values define each group (i.e., the GROUP BY keys); accepts text or numeric columns, multi-select, auto-populated from the connected dataset — leave empty to treat the entire dataset as a single group. | |
| Target Columns | target_columns | text | — | One or more numeric columns for which mean and sample standard deviation are computed per group; each target column produces two output fields: ‘<col>’ (mean) and ‘<col>_sd’ (sample std dev). |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| Output Summary | dataset | dataset | Summary table where each row represents one unique group (defined by the input columns), with additional columns for the mean and sample standard deviation of every target column (e.g., ‘value’ → ‘value’ and ‘value_sd’). |
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_get_mean_sd_by_group
Auto-generated from platform schema. Worker id: dataset_get_mean_sd_by_group. Schema hash: 9b4e0929f1e9. Hand-curated docs in workerexamples/ override this page when present.