python实现excel lookup功能

import pandas as pd 
sx_customer_0409=pd.read_excel(r'E:\lusiru\202004\20200402随心降额名单筛选\sx_customer_0409.xlsx')#读取原始数据
fx_variable=pd.read_excel(r'E:\lusiru\202004\20200402随心降额名单筛选\fx_variable.xlsx')#读取分箱列表数据

def lookup(lookup_value,lookup_vector,return_vector):
    """
    与Excel中的lookup函数一样
    """
    return return_vector[lookup_value >= lookup_vector].tolist()[-1]

for i in variable:
    sx_customer[i] = sx_customer[i].apply(lookup,args=(fx_variable[fx_variable['变量']==i]['下限'],fx_variable[fx_variable['变量']==i]['分值']))
 #args给自定义函数第一个参数外的参数赋值。