在python中合并公共列上的两个数据框

import pandas as pd

# 创建两个数据框
df1 = pd.DataFrame({'A': [1, 2, 3], 'B': ['a', 'b', 'c']})
df2 = pd.DataFrame({'A': [2, 3, 4], 'C': ['x', 'y', 'z']})

# 内连接合并
merged_inner = pd.merge(df1, df2, on='A', how='inner')
print(merged_inner)

import pandas as pd

# 创建两个数据框
df1 = pd.DataFrame({'A': [1, 2, 3], 'B': ['a', 'b', 'c']})
df2 = pd.DataFrame({'A': [2, 3, 4], 'C': ['x', 'y', 'z']})

# 左连接合并
merged_left = pd.merge(df1, df2, on='A', how='left')
print(merged_left)

import pandas as pd

# 创建两个数据框
df1 = pd.DataFrame({'A': [1, 2, 3], 'B': ['a', 'b', 'c']})
df2 = pd.DataFrame({'A': [2, 3, 4], 'C': ['x', 'y', 'z']})

# 右连接合并
merged_right = pd.merge(df1, df2, on='A', how='right')
print(merged_right)

import pandas as pd

# 创建两个数据框
df1 = pd.DataFrame({'A': [1, 2, 3], 'B': ['a', 'b', 'c']})
df2 = pd.DataFrame({'A': [2, 3, 4], 'C': ['x', 'y', 'z']})

# 外连接合并
merged_outer = pd.merge(df1, df2, on='A', how='outer')
print(merged_outer)