比较两个pandas数据框列的元素，并基于第三列创建新列

import pandas as pd

# 创建示例数据框
df1 = pd.DataFrame({'A': [1, 2, 3, 4],
                    'B': [5, 6, 7, 8],
                    'C': [9, 10, 11, 12]})

df2 = pd.DataFrame({'A': [1, 2, 3, 4],
                    'B': [9, 6, 7, 8],
                    'C': [13, 14, 15, 16]})

# 比较两个数据框的列A和列B的元素，并基于列C创建新列
df1['new_column'] = df1['A'] == df2['B']
df1['new_column'] = df1['new_column'].astype(int)

# 打印结果
print(df1)

   A  B   C  new_column
0  1  5   9           0
1  2  6  10           1
2  3  7  11           0
3  4  8  12           0