# Data Aggregate

## Data Aggregate

### Input Data

|                         | Input                                                                                                                   |
| ----------------------- | ----------------------------------------------------------------------------------------------------------------------- |
| **\*Target Data**       | Input data                                                                                                              |
| **\*Output Name**       | Name of the output after Aggregation                                                                                    |
| **\*Aggregation Items** | <p>Variables you want to summarize. </p><p>Drag the variables from the table and drop them under Aggregation Items.</p> |
| **Grouping Items**      | The variable to group by.                                                                                               |

### Aggregation Items

If you do not put variables under Grouping Items, the output will show the calculated results in one row. There are six options for Aggregator - count, sum, mean, max, min, and stddev.

![\[Task Information of Data Aggregate\]](https://3929524962-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MGaxNdSdRN_L_WNiX4I%2F-MLNg5ZLbpYkZm8ykaU6%2F-MLNgi_lDBLXZkfre2xr%2Fimage.png?alt=media\&token=b5ad5c12-c9bc-43be-b4f3-9f330cff3a8c)

![Result of Aggregation](https://3929524962-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MGaxNdSdRN_L_WNiX4I%2F-MIFspQH8KiEe0NWTWAG%2F-MIFy23t3ARINNRKNAXQ%2Fimage.png?alt=media\&token=146fbd6c-1992-44e3-a97b-3e2a7d06bd51)

### Grouping Items

If you put a variable under Grouping Items, the program splits the data into groups by the variable. The result will show the grouping items on the first column and the summarized data on other columns.

## Workflow Example

[R-Flow Task Example Video](https://youtu.be/boi_pqDx2IA) - Data Aggregate

## R Packages

Data Aggregate: [https://cran.r-project.org/web/packages/dplyr/index.html](https://cran.r-project.org/web/packages/dplyr/index.html)

