Combine two tables of data together based on a key
Function:
Join(table = string, join_table = string, how = drop down, left_on = string, right_on = string, new_table_name = string)
Parameters:
Table: Table name on which to perform function
Join table: Table to Join to the original Table
How: Type of join to perform (left, right, inner, outer
Left on: Key (column name) to match from left table
Right on: Key (column name) to match from right table
Examples:
Left: Similar to a SQL left outer join. This will use only keys from left table
Right: Similar to a SQL right outer join. This will use only keys from left table
Outer: Similar to a SQL full outer join. This will use union of keys from both frames
Inner: Similar to a SQL inner join. This will use an intersection of keys from both frames, preserve the order of the left keys.