Python/Pandas:比较两个数据帧中的多个列，如果未找到匹配，则删除行

import pandas as pd

# 加载数据帧df1和df2
df1 = pd.DataFrame({'A': [1, 2, 3],
                    'B': [4, 5, 6],
                    'C': [7, 8, 9]})

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

# 按照列'A'和列'B'进行合并
merged_df = pd.merge(df1, df2, on=['A', 'B'], how='inner')

# 找到未匹配的行的索引
unmatched_rows = df1.index.difference(merged_df.index)

# 删除未匹配的行
df1 = df1.drop(unmatched_rows)

print(df1)

import pandas as pd

# 加载数据帧df1和df2
df1 = pd.DataFrame({'A': [1, 2, 3],
                    'B': [4, 5, 6],
                    'C': [7, 8, 9]})

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

# 按照列'A'和列'B'进行合并
merged_df = pd.merge(df1, df2, on=['A', 'B'], how='inner')

# 找到未匹配的行的索引
unmatched_rows = df1.index.difference(merged_df.index)

# 删除未匹配的行
df1 = df1.drop(unmatched_rows)

print(df1)