python两个dataframe求差集_Pandas中两个dataframe的交集和差集的示例代码

创建测试数据：

import pandas as pd

import numpy as np

#Create a DataFrame

df1 = {

'Subject':['semester1','semester2','semester3','semester4','semester1',

'semester2','semester3'],

'Score':[62,47,55,74,31,77,85]}

df2 = {

'Subject':['semester1','semester2','semester3','semester4'],

'Score':[90,47,85,74]}

df1 = pd.DataFrame(df1,columns=['Subject','Score'])

df2 = pd.DataFrame(df2,columns=['Subject','Score'])

print(df1)

print(df2)

运行结果：

求两个dataframe的交集

intersected_df = pd.merge(df1, df2, how='inner')

print(intersected_df)