Icon

06_​Basic_​Examples_​for_​Using_​the_​GroupBy_​Node

Basic Examples for using the GroupBy Node

This workflow shows the many aggregation options that the GroupBy node offers.
We start from customer data, group on Gender or more features, and run a few different aggregation methods on a few different features.

Basic Aggregations Group on one feature (Gender) Aggregations - count - percent Note These aggregations are feature independent. Basic Aggregations Group on one feature (Gender) Aggregations - unique count - missing value count - mode Note For numerical features as well as nominal Basic Aggregations Group on one feature (Gender) Aggregations - concatenate - unique concatenate - unique concatenate with count Note Also for numerical features, but output is String Statistical Aggregations Group on one feature (Gender) Aggregations - mean - sum - Std. deviation - Kurtosis - Min/Max vs First/Last Special Data Type (e.g Date) Aggregations Group on one feature (Gender) Aggregations - Date range - Mean Date - Minimum & Maximum Note - Special operations for most data types This workflow shows the many aggregation options offered by the GroupBy node.For more information see the workflow metadata. Find it here: View -> Description Customer Datacount, percentmean, sum, std dev.,Kurtosis- Concatenate- Unique concatenate- Unique concatenatew/ countMin/MaxvsFirst/LastDatesunique count,missing val count,mode Table Reader GroupBy GroupBy GroupBy GroupBy GroupBy GroupBy Basic Aggregations Group on one feature (Gender) Aggregations - count - percent Note These aggregations are feature independent. Basic Aggregations Group on one feature (Gender) Aggregations - unique count - missing value count - mode Note For numerical features as well as nominal Basic Aggregations Group on one feature (Gender) Aggregations - concatenate - unique concatenate - unique concatenate with count Note Also for numerical features, but output is String Statistical Aggregations Group on one feature (Gender) Aggregations - mean - sum - Std. deviation - Kurtosis - Min/Max vs First/Last Special Data Type (e.g Date) Aggregations Group on one feature (Gender) Aggregations - Date range - Mean Date - Minimum & Maximum Note - Special operations for most data types This workflow shows the many aggregation options offered by the GroupBy node.For more information see the workflow metadata. Find it here: View -> Description Customer Datacount, percentmean, sum, std dev.,Kurtosis- Concatenate- Unique concatenate- Unique concatenatew/ countMin/MaxvsFirst/LastDatesunique count,missing val count,mode Table Reader GroupBy GroupBy GroupBy GroupBy GroupBy GroupBy

Nodes

Extensions

Links