Aggregation

Aggregation is located under Model Studio () in Data Preparation, in the task pane on the left. Use drag-and-drop method to use the algorithm in the canvas. Click the algorithm to view and select different properties for analysis. Refer to Properties of Aggregation.

​

Properties of Aggregation

The available properties of Aggregation are as shown in the figure given below.

The table given below describes different fields present on the properties of Aggregation.

Field	Description	Remark
Run	It allows you to run the node.	-
Explore	It allows you to explore the successfully executed node.	-
Vertical Ellipse	The available options are Run till node Run from node Publish as a model Publish code	-
Task Name	It displays the name of the selected task.	You can click the text field to edit or modify the name of the task as required.
GroupBy	It allows you to select the function for which you want to group the data.	Multiple functions can be selected. You can group by numerical as well as categorical function.
Aggregate Function	It allows you to select the type of data that is to be aggregated.	Multiple functions can be selected. Same data can be grouped according to different statistical measures at the same time. You can aggregate numerical as well as categorical data. Numerical data is aggregated by Sum Mean Mode Minimum Maximum Count Count (Distinct) Standard Deviation Variance Categorical data is aggregated by Minimum Maximum Count Count (Distinct)

Example of Aggregation

The figure given below displays the output of aggregation performed on sample data. The data of the number of deaths (numerical data) in a US county is aggregated by sum, mean, standard deviation, and the maximum value of the number of deaths. The data is grouped by the name of the county and date (both categorical data).

Field	Result
county	It displays the name of the US county whose data corresponding to the number of deaths is aggregated.
deaths_Aggr_0	It displays the aggregate deaths in that county by the sum of deaths on a particular date.
date	It displays the date corresponding to which the data is aggregated.
deaths_Aggr_1	It displays the aggregate deaths in that county by the mean number of deaths on a particular date.
deaths_Aggr_2	It displays the aggregate deaths in that county by the standard deviation of the deaths on a particular date.
deaths_Aggr_3	It displays the aggregate deaths in that county by the maximum value of the number of deaths on a particular date.

• Related Articles

• Aggregation

  Aggregation is located under Model Studio () in Data Preparation, in the task pane on the left. Use drag-and-drop method to use the algorithm in the canvas. Click the algorithm to view and select different properties for analysis. Refer to Properties ...

• Support Aggregations for Categorical/Dimension Columns in Table

  For categorical columns or Dimensions, the aggregation option is available while configuring Table chart. This option is available for getting the aggregated values with Count, Count (Distinct) values for all types of Dimension columns- dataset ...

• Aggregate Line

  The figure given below shows the Add Aggregate Line page. The table given below describes different fields present on Add Aggregate Line page. Section Field Description Remark Line Name It allows you to select a name for the Aggregate Line. · Select ...

• Creating Charts using Widgets

  To create a chart using widgets, follow the steps given below. Open the Dashboard in edit mode. Refer to Editing a Dashboard. The Dashboard is displayed. In the WIDGETS pane, click the widget you want to use. Note: Hover over any widget to see its ...

• Copying Node in Same Workbook

  Rubiscape provides a facility to copy a single node, multiple nodes, or connected nodes in the same workbook using keyboard events (shortcuts). Notes: You can copy the Node (s) in the same workbook or workflow but cannot copy them in another workbook ...