Pandas Dataframe:当行包含不同的国家时，合并来自两个全局数据集的列

import pandas as pd

# 创建数据集1的DataFrame对象
data1 = {'Country': ['China', 'USA', 'India'],
         'Data1': [10, 20, 30]}
df1 = pd.DataFrame(data1)

# 创建数据集2的DataFrame对象
data2 = {'Country': ['China', 'USA', 'Japan'],
         'Data2': [40, 50, 60]}
df2 = pd.DataFrame(data2)

merged_df = pd.merge(df1, df2, on='Country', how='outer')

print(merged_df)

  Country  Data1  Data2
0   China     10   40.0
1     USA     20   50.0
2   India     30    NaN
3   Japan    NaN   60.0