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 replace

TRANSFORMER

Typing name : TASK.gws_core.TableReplace

Brick : gws_core v

Parent :

Transformer v.0.5.15

Replace values in a table with other values

You can provided multiple values to replace. It also supports regex. If multiple values are provided, there are replaced sequentially, so the second replace can rewrite the first replace. The table's tags are kept.

For each configuration, if Is regex is checked, the search value is considerer as a regex and there is no modification to it. Otherwise the search value is converted (see Convertion). The replace value is always converted.

Convertion

The params values supports 2 special values:

NaN: convert to NaN
None: convert to None

If the value is someting else, the system tries to convert it to a number. If this is convertible to a number the system will use the number, otherwise the value is kept as is.

Input

Table

2d excel like table

Output

Table

2d excel like table

Configuration

replace_values

Type : List

Maximum occurrences number : -1

search_value

Optional

Value to search for. Use 'NaN' for NaN and 'None' for None

Type : string

replace_value

Optional

Use 'NaN' for NaN and 'None' for None

Type : string

is_regex

Optional

If true, the search value is interpreted as a regex

Type : bool