Merge Tables¶
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