Initializing playground…
← 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

TypeScript
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent

Forward-fill after merge

TypeScript
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent

Inner join variant

TypeScript
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent

Different key column names per side

TypeScript
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent

Group-wise ordered merge (left_by / right_by)

TypeScript
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent

Overlapping non-key columns — suffixes

TypeScript
Click ▶ Run to execute
Ctrl+Enter to run · Tab to indent