Login
Back to bricks list
Introduction Version

Table column aggregator filter

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

Filters the table columns based aggregation value

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

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

The returns table is the originial table with the columns 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 columns

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

comparator

Comparator

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

value

Value

Type : float