Merge Tables

../../../../_images/merge.svg

Merge Tables while matching an Index

Documentation

Auto generated list version of Merge Table.

In this version, the following ports from the original nodes have been changed to lists which the node loops over:

Looped Inputs

Input A, Input B.

Looped Outputs

Output.

For details see the original node.

Definition

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.MergeTables[source]

Related nodes