← Back to roadmap
join: label-based DataFrame join
join(left, right, options?) aligns two DataFrames by their index labels (or a key column).
Unlike the general-purpose merge(), join() defaults to a left join on index
— the idiomatic way to combine DataFrames that already share an index.
Left join (default)
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent
Inner / outer / right join
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent
Overlapping columns — use lsuffix / rsuffix
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent
Join on a column key
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent
joinAll — chain multiple joins
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent
crossJoin — Cartesian product
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent