Nov-25-2017, 05:42 PM
#!/usr/bin/python3 import pandas as pd table = pd.DataFrame(data = {'RowID':[1,2,3,4,5,6,7,8,9,10], 'CusID':[1,1,1,1,2,2,3,3,4,4], 'Area':['A','A','A','A','A','A','A','A','B','B'], 'Income':[800,900,1000,900,1000,800,400,400,900,1000],}) criteria = pd.DataFrame(data = {'CusID':[1,2,4], 'Area':['A','A','B'], 'Income':[800,1000,700],}) tableMatched = pd.merge(table, criteria, on=['CusID', 'Area', 'Income'], how='inner') print(tableMatched)
Output: Area CusID Income RowID
0 A 1 800 1
1 A 2 1000 5