Merge Table

../../../../../_images/merge.svg
Input ports:
Input A:

table

Input A

Input B:

table

Input B

Output ports:
Output:

table

Output

Configuration:
Index column (index)
Column with indices to match
Join operation (operation)
Column with y values.
Merge two tables or two lists of tables (database style) using these nodes:

Internally uses pandas.DataFrame.merge for More information see that documentation.

Essentially, this node calls:

pandas.merge(
    input_a, input_b, how=join_operation,
    on=index_column)

Values for Join Operation are:

  • Union, similar to SQL full outer join
  • Intersection, similar to SQL inner join
  • Index from A, similar to SQL left outer join
  • Index from B, similar to SQL right outer join
class node_merge_tables.MergeTable

Example flows