1、根据值在是否在列表中进行切片:
方法一:使用isin方法可以根据DataFrame中的某列的值是否在某个列表中来进行切片(注意:这里不要直接使用in,否则会报错),代码如下:
pf = pd.DataFrame([['74-27-EA-4D-93-BD','act_click','click_news',3],['E0-3F-49-79-C8-97','act_biz','click_hb.seb',199],
['E0-3F-49-79-C8-97', 'msg_view', '1', 4],
['E0-3F-49-79-C8-97', 'msg_view', '2', 36],
['E0-3F-49-79-C8-97', 'msg_view', '3', 2],
['40-8D-5C-98-35-70', 'act_biz', 'click_hb.wet', 7],
['74-27-EA-4D-93-BD', 'act_biz', 'click_hb.wet', 5]],
columns=['MAC','ACT','ACT_POINT','CLICKS'])
print(pf)
lt = ['click_news','click_hb.seb','click_hb.wet']
print(pf.loc[pf['ACT_P