R语言：如何合并行数更少的DataFrame至已有数据框并补NA

Hey there! Let's break down how to merge your larger DataFrame (df1) with a smaller one, making sure any missing spots get filled with NA. Pandas has a couple of straightforward approaches depending on how you want to align your data.

1. Align by Index (Row Position) #

If you want to match rows based on their index positions (e.g., row 0 of df1 with row 0 of the smaller DataFrame, even without a shared key column), use either join() or concat().

Example Code: #

First, let's create sample DataFrames to test with:

import pandas as pd

# Your larger DataFrame
df1 = pd.DataFrame({
    'Item': ['Apple', 'Banana', 'Cherry', 'Date', 'Elderberry'],
    'Price': [1.2, 0.5, 0.8, 1.5, 2.0]
})

# Smaller DataFrame with only 3 rows (matching some indices of df1)
df2 = pd.DataFrame({
    'Stock': [100, 75, 50]
}, index=[0, 2, 4])

Option A: Use df1.join(df2)

This method is clean for index-based merging:

merged_df = df1.join(df2)

The result will keep all rows from df1, with Stock values filled where indices match, and NA where they don't.

Option B: Use pd.concat()

If you prefer concat, specify axis=1 to merge columns side-by-side:

merged_df = pd.concat([df1, df2], axis=1)

This gives the same index-aligned result as join()—NA fills in for missing matches.

2. Align by a Shared Column (e.g., Primary Key) #

If your DataFrames share a common identifier column (like ID or ItemID), use pd.merge() with a left join to preserve all rows from df1 while merging matching rows from the smaller DataFrame.

Example Code: #

Let's adjust our samples to include a shared key:

# Larger df1 with all items
df1 = pd.DataFrame({
    'ItemID': [1, 2, 3, 4, 5],
    'Item': ['Apple', 'Banana', 'Cherry', 'Date', 'Elderberry'],
    'Price': [1.2, 0.5, 0.8, 1.5, 2.0]
})

# Smaller df2 with only some ItemIDs
df2 = pd.DataFrame({
    'ItemID': [1, 3, 5],
    'Stock': [100, 75, 50]
})

Use pd.merge() with how='left':

merged_df = pd.merge(df1, df2, on='ItemID', how='left')

• on='ItemID': Tells Pandas to match rows using this shared column.
• how='left': Guarantees every row from df1 is kept. If there's no matching row in df2, columns from df2 will auto-fill with NA.

Bonus: Handling Duplicate Column Names #

If both DataFrames have columns with the same name (other than the key), use the suffixes parameter to distinguish them:

merged_df = pd.merge(df1, df2, on='ItemID', how='left', suffixes=('_df1', '_df2'))

Quick Recap #

• Index-based merge: Use df1.join(df2) or pd.concat([df1, df2], axis=1)
• Key-column merge: Use pd.merge(df1, df2, on='your_key', how='left') (this is the go-to for most real-world cases where you have a shared identifier)

内容的提问来源于stack exchange，提问作者Alex Johanssen