Login
Back to bricks list
Introduction Version

Table row annotator

TASK
Typing name :  TASK.gws_core.TableRowAnnotator Brick :  gws_core v

Annotate table rows according to a metadata table

TableRowAnnotator

Annotate the rows of a sample_table using information from a metadata_table.

  • all the row values of the reference column of the sample_table are matched against the ids of the metadata_table.
  • if an id matches against a reference value of the sample_table, the corresponding row of the sample_table is taggeg with the metadata given by the id.

Input

Sample table
Table to annotate
Metadata table
Table containing the metadata

Output

Table
2d excel like table

Configuration

reference_column

Optional

Column in the sample table whose values are used for annotation. If empty, it uses the first column.

Type : string

metadata_ref_column

Optional

Column in the metadata table whose values are used for annotation. If empty, it uses the first column.

Type : string

use_table_row_names_as_ref

OptionalAdvanced parameter

If checked, the row names of the sample table are used as reference for annotation and the reference column param is ignored.

Type : bool

use_metadata_row_names_as_ref

OptionalAdvanced parameter

If checked, the row names of the metadata table are used as reference for annotation and the metadata reference column param is ignored.

Type : bool