Login
Back to bricks list
Introduction Version

Table column annotator

TASK
Typing name :  TASK.gws_core.TableColumnAnnotator Brick :  gws_core

Annotate table columns according to a metadata table

TableColumnAnnotator

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

  • all the column values of the reference row 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 column 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_row

Optional

Row in the sample table whose data are used as reference for annotation. If empty, it uses the first row.

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_column_names_as_ref

OptionalAdvanced parameter

If checked, the column names of the sample table are used as reference for annotation and the reference row 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