Login
Back to bricks list
Introduction Version

Table row aggregator filter

TRANSFORMER
Typing name :  TASK.gws_core.TableRowAggregatorFilter Brick :  gws_core

Filters the table rows based aggregation value

Filter the table rows using comparator on the aggregation of the values of the rows.

For example with this you can keep only the rows with a mean value greater than 0.5.

The returns table is the originial table with the rows filtered (not the aggregated table).

Supported aggregation functions: mean, std, var, min, max, median and sum.

Supported comparators: >, <, >=, <=, ==, !=.

Input

Table
2d excel like table

Output

Table
2d excel like table

Configuration

aggregation_filter

Optional

Filter axis validating a numeric criterion after aggregation

Type : ListMaximum occurrences number : 3

function

Function applied on the rows

Type : stringAllowed values : mean  std  var  min  max  median  sum 

comparator

Comparator

Type : stringAllowed values : =  !=  >=  <=  >  < 

value

Value

Type : float