Filter rows in Table¶
Filter column using Tables.
Documentation¶
Filter the rows of Value Table, outputting a subset as Filtered Table.
Filtering takes place by applying a conditional Operator for every row element in the Value column, to that element and the full Reference column: outputting any row where the condition is satisfied.
These predefined operators can be used:
In
Satisfied for any row in Value Table where the element from the Value column exists on any row of the Reference column.
Not in
Satisfied for any row where In can be applied and is not satisfied.
The Operator can also be defined as a lambda function in the configuration GUI. It will be called once for each element in the Value column with the full Reference column available under the name ref. The lambda function should return True or False.
See https://docs.python.org/3/tutorial/controlflow.html#lambda-expressions for a description of lambda functions. Have a look at the Table API to see all the available methods and attributes.
Warning
The labels of this node has changed. The columns Reference, Value used to be called C0, C1 respectively. This can be good to keep in mind if you are used to the old names.
Definition¶
Input ports¶
- port0 table
Reference Table
- port1 table
Value Table
Output ports¶
- port0 table
Filtered Table
Configuration¶
- Reference (c0_column)
Select reference column from the Reference Table.
- Value (c1_column)
Select value column from the Value Table.
- Operator (filter_functions)
Predefined conditional operator.
- Custom filter (predicate_function)
Conditional operator defined as a lambda function
- Use custom filter function (use_custom_predicate)
Use custom filter instead of predefined operator.
Examples¶
Implementation¶
- class node_table_filter.ColumnFilterNode[source]