import pandas as pd
table1 = r'C:\Users\Administrator\Desktop\result2.xls'
data1 = pd.read_excel(table1, sheet_name = 2)
df1 = pd.DataFrame(data1.iloc[:,[0,1,2,3,4,5]], columns=['company','city','strategy','fund_name','manager_name','fund_id'])
table2 = r'C:\Users\Administrator\Desktop\工作总表2.xlsx'
data2 = pd.read_excel(table2, sheet_name = 0,header=None)
df2 = pd.DataFrame(data2.iloc[:,[1,2,3,4,5,6]][1:])
df2.columns = ['company','city','strategy','fund_name','manager_name','fund_id']
# 取交集
data_new = pd.merge(df1, df2, on='fund_name')
list = data_new['fund_name'].tolist()
# 取不含交集部分
a = df1[~(df1['fund_name'].isin(list))]#C:\Users\Administrator\Desktop\result2.xls
b= df2[~(df2['fund_name'].isin(list))]#C:\Users\Administrator\Desktop\工作总表2.xlsx
# 生成结果
a.to_csv('result_a.csv', encoding="utf_8_sig")
b.to_csv('result_b.csv', encoding="utf_8_sig")