两个数据帧之间的Pandas条件匹配循环

import pandas as pd

# 创建两个数据帧
df1 = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6]})
df2 = pd.DataFrame({'A': [1, 2, 4], 'B': [4, 5, 7]})

# 遍历df1的每一行
for index, row in df1.iterrows():
    # 获取当前行的值
    a = row['A']
    b = row['B']
    
    # 在df2中查找匹配条件的行
    match_rows = df2[(df2['A'] == a) & (df2['B'] == b)]
    
    # 如果有匹配的行，则进行相应操作
    if not match_rows.empty:
        # 进行操作，例如修改值或者删除行
        df1.at[index, 'A'] = match_rows.iloc[0]['A']
        df1.at[index, 'B'] = match_rows.iloc[0]['B']

# 打印结果
print(df1)