← Back to roadmap
merge_ordered (ordered fill merge)
mergeOrdered is an ordered merge (default outer join) that
sorts the result by the key column(s). It is ideal for time-series and event data where
both DataFrames have partially overlapping key ranges and you want a complete timeline
with optional forward-fill (fill_method: "ffill") to carry values forward.
Basic outer ordered merge
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent
Forward-fill after merge
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent
Inner join variant
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent
Different key column names per side
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent
Group-wise ordered merge (left_by / right_by)
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent
Overlapping non-key columns — suffixes
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent