pandas--merge

最新推荐文章于 2024-09-27 10:11:28 发布

baicheng3370

最新推荐文章于 2024-09-27 10:11:28 发布

阅读量110

点赞数

文章标签： python

原文链接：http://www.cnblogs.com/fatcici2017/p/9938687.html

版权

sr=pd.read_csv('/Users/macui 1 2/Documents/hot_ifx.csv',names=['timestamp','request1','request2','account_id','api_key','idcard','name','source','confidence','compare_platform','image_type'],header=0)

s1=sr[(sr['confidence']<69.315) & (sr['image_type']=='meglive')]

l1=sr[(sr['confidence']>=69.315) & (sr['image_type']=='meglive')&(sr['compare_platform']!='faceid')]

s_l=s1.merge(l1,how='left',on=['api_key','idcard']).dropna()

s2=sr[(sr['confidence']>=69.315) & (sr['source']=='image_ref_chache')]

s3=s_l.merge(s2,how='right',on=['idcard','api_key']).dropna()

s4=s3[s3['request1_y']>s3['request1']]