Back to bricks list

Research documentation

Getting Started

Developer guide

Release

CLI

Technical Documentation

Resources

Tasks

Conda env agent

Create a sugar type of food

Create folder from files

Create json dict

Create lab note

Create note resource

Decompress file

Download an scenario

Download resource from a S3 bucket

Download resource from external source

Extract column tags to new row

Extract column values to row tags

Extract row tags to new column

Extract row values to column tags

Folder exporter

Fs node extractor

Generate lab note from note resource

Histogram Plotly

JSON Dict exporter

JSON Dict importer

Mamba env agent

Merge note resources

R conda env agent

R mamba env agent

Resource exporter

Resource importer

Resource picker

Resource set exporter

Resource stacker

Scatterplot Plotly

Select note template

Smart interactive plot generator

Smart json transformer

Smart multi tables transformer

Smart plot generator

Smart table transformer

Streamlit agent

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 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 unfolder

Table row tags deleter

Table row tags selector

Table rows deleter

Table rows selector

Table transposer

The travel of `Astro`

Unzip and load resource

Update note resource

Upload resource to S3

Violinplot Plotly

[Support] Update process typing name

[Support] Update resource typing name

Protocols

Other Classes

Table replace

TRANSFORMER

Typing name : TASK.gws_core.TableReplace

Brick : gws_core

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