python dataframe 差集_dataframe 差集

>>>data_a={'state':[1,1,2],'pop':['a','b','c']}

>>>data_b={'state':[1,2,3],'pop':['b','c','d']}

>>>a=pd.DataFrame(data_a)

>>>a

popstate

0a1

1b1

2c2

>>>b=pd.DataFrame(data_b)

>>>b

popstate

0b1

1c2

2d3

>>>a = a.append(b)

>>>a = a.append(b)

>>>result = a.drop_duplicates(subset=['pop','state'],keep=False)

>>>result

popstate

0a1

判断 dataframe是否为空：

tmp = readySend_1.append(readySend_2)

tmp = tmp.append(readySend_2)

OverdueData = tmp.drop_duplicates(keep=False)

if not OverdueData.empty:

OverdueData.to_csv('./recommed_need.log', mode='a+', header=False)