Select columns in Table

../../../../../_images/select_table_columns.svg

There are many situations where you may want to throw away some of the columns of a table. Perhaps the amount of data is large and you want to trim it to increase performance, or perhaps some column was just needed as an intermediary step in some analysis.

Whatever the reason, if you want to remove some of the columns of a Table the standard libray offers two types of nodes which provide this functionality. The nodes Select columns in Table and Select columns in Tables will let you select what columns to keep (if complement is disabled) or which columns to throw away (if complement is enabled) in their GUI. The nodes Select columns in Table with Table and Select columns in Tables with Table instead take a second input table with a filter column containing the names of all the columns that should be kept (if complement is disabled) or all the columns that should be thrown away (if complement is enabled). The configuration for the latter nodes also allows you to choose the column that should be used as a filter.

class node_select_table_columns.SelectTableColumns[source]
Inputs:
TableInput
: Table

Table with many column.

Outputs:
TableOutput
: Table

Table with fewer columns.

Configuration:
Remove selected columns

When enabled, the selected columns will be removed. When disabled, the non-selected columns will be removed.

Select columns :

Select the columns which will proceed.

All
: button

Select all listed columns.

Clear
: button

Deselect all listed columns.

Invert
: button

Invert the selection of columns.

Ref. nodes:

Select columns in Table with Table