df.merge only includes rows with matching values in both DataFrames. If you want to include all rows from both DataFrames, use how='outer'.My previous tips on pandas.
df.merge
how='outer'
DuckDB: Simplify DataFrame Analysis with Serverless SQL
Simplifying Dataset Comparison with Datacompy
Fuzzy Joining Tables with Non-Exact Matching Entries