类似vlookup
import pandas as pd
file = pd.read_csv(‘NIN411PF.CSV‘, encoding=‘ANSI‘)
a = pd.DataFrame({‘PNUM95‘:[‘1609724175‘],
‘REFN95‘:[‘899270‘]
})
#按2个条件查询
file1 = pd.merge(file, a, on=[‘PNUM95‘,‘REFN95‘])
file1.to_csv(‘abc.csv‘)
原文：https://www.cnblogs.com/pythonClub/p/10400451.html