Python遍历两个数据帧并查找相似的列

import pandas as pd
import numpy as np

df1 = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6]})
df2 = pd.DataFrame({'C': [1, 2, 4], 'D': [7, 8, 9]})

similar_columns = []
for col1 in df1.columns:
    for col2 in df2.columns:
        if np.array_equal(df1[col1], df2[col2]):
            similar_columns.append((col1, col2))

for col1, col2 in similar_columns:
    print(f"Similar columns: {col1} in df1, {col2} in df2")