Research documentation

Getting Started

Developer guide

Tutorials

Release

Technical Documentation

Resources

Tasks

Base env shell task

Conda env live task

Conda env shell

Create a sugar type of food

Dataset exporter

Dataset importer

Download resource from a S3 bucket

Download resource from external source

Encoded table exporter

Encoded table importer

EncodingTable exporter

EncodingTable importer

Fs node extractor

JSON Dict exporter

JSON Dict importer

Mamba env live task

MetadataTable exporter

MetadataTable importer

Pip env live task

Python live task

R conda env live task

R mamba env live task

Resource exporter

Resource importer

Resource picker

Resource set exporter

Resource stacker

Smart interactive plot generator

Smart json transformer

Smart plot generator

Smart table transformer

Table aggregator

Table aggregator filter

Table annotator

Table column aggregator

Table column aggregator filter

Table column annotator

Table column concat

Table column data numeric filter

Table column data text filter

Table column operation mass

Table column operations

Table column scaler

Table column tag aggregator

Table column tag extractor

Table column tag unfolder

Table column tags deleter

Table column tags selector

Table columns deleter

Table columns selector

Table row aggregator

Table row aggregator filter

Table row annotator

Table row concat

Table row data numeric filter

Table row data text filter

Table row scaler

Table row tag aggregator

Table row tag extractor

Table row tag unfolder

Table row tags deleter

Table row tags selector

Table rows deleter

Table rows selector

Table to dataset converter

Table transposer

The travel of `Astro`

Uncompress file

Upload resource to S3

Protocols

Table column data numeric filter

TRANSFORMER

Typing name : TASK.gws_core.TableColumnDataNumericFilter

Brick : gws_core v

Parent :

Transformer v.0.5.15

Filters the table columns based on values of one or multiple rows with numeric comparator

For earch filters, the system will keep the columns where the value in the row provided by the parameter Row name validated condition (the comparator with the value parameter).The result table will have the same number of rows as the input table.

The Row name supports pattern. This means that multiple rows can be used in the filter. In this case all the values in the provided rows must validate the condition. You can set the value * in the Row name which mean that all the values in the column must validate the condition.

Supported operators : =, !=, >=, <=, > and <

If you need to apply filters on text values, you can use the Table column data numeric filter task.

Input

Table

2d excel like table

Output

Table

2d excel like table

Configuration

numeric_filter

Type : List

Maximum occurrences number : 9

row_name_regex

Optional

The name of the rows along which the filter is applied (regexp pattern); Use '*' for all the rows

Type : string

comparator

Comparator

Type : string

Allowed values : = != >= <= > <

value

Value

Type : float