How to Use Right Merge in Pandas for DataFrames

Use pandas.merge() with the parameter how='right' to perform a right merge. This keeps all rows from the right DataFrame and adds matching rows from the left DataFrame, filling with NaN where no match exists.

Syntax

The right merge syntax in pandas is:

• pandas.merge(left, right, how='right', on=None, left_on=None, right_on=None)
• left: The left DataFrame to merge.
• right: The right DataFrame to merge.
• how='right': Specifies a right merge to keep all rows from the right DataFrame.
• on: Column name(s) to join on. Must be present in both DataFrames.
• left_on and right_on: Specify columns to join on if they have different names.

python

import pandas as pd

merged_df = pd.merge(left_df, right_df, how='right', on='key')

Example

This example shows how to merge two DataFrames using a right merge. It keeps all rows from the right DataFrame and adds matching rows from the left DataFrame.

python

import pandas as pd

# Left DataFrame
left_df = pd.DataFrame({
    'key': ['A', 'B', 'C'],
    'left_val': [1, 2, 3]
})

# Right DataFrame
right_df = pd.DataFrame({
    'key': ['B', 'C', 'D'],
    'right_val': [4, 5, 6]
})

# Right merge
merged_df = pd.merge(left_df, right_df, how='right', on='key')
print(merged_df)

Output

  key  left_val  right_val
0   B       2.0          4
1   C       3.0          5
2   D       NaN          6

Common Pitfalls

Common mistakes when using right merge include:

• Not specifying the on parameter correctly, causing unexpected merges.
• Confusing how='right' with how='left' or how='inner'.
• Missing values appear as NaN when no match is found in the left DataFrame.

Always check your keys and understand which DataFrame's rows you want to keep.

python

import pandas as pd

# Wrong: missing 'on' parameter leads to Cartesian product
try:
    pd.merge(left_df, right_df, how='right')
except Exception as e:
    print(f'Error: {e}')

# Correct: specify 'on' parameter
correct_merge = pd.merge(left_df, right_df, how='right', on='key')
print(correct_merge)

Output

Error: No common columns to perform merge on. Merge options: left_on=None, right_on=None, left_index=False, right_index=False
  key  left_val  right_val
0   B       2.0          4
1   C       3.0          5
2   D       NaN          6

Quick Reference

Parameter	Description
left	Left DataFrame to merge
right	Right DataFrame to merge
how='right'	Keep all rows from right DataFrame, add matching from left
on	Column(s) to join on present in both DataFrames
left_on	Column(s) from left DataFrame to join on (if different names)
right_on	Column(s) from right DataFrame to join on (if different names)

Key Takeaways

Use pd.merge() with how='right' to keep all rows from the right DataFrame.

Specify the 'on' parameter to define the join key columns.

Rows in the right DataFrame without matches in the left will have NaN values.

Not specifying 'on' can cause errors or unexpected merges.

Right merge is useful when the right DataFrame's data must be fully preserved.