系列一:
需求:实现Excel 中VLOOKUP(xlookup)功能
代码和说明
import pandas as pd
data = pd.read_csv(r'D:\test\s_cplist.csv',encoding='ANSI',low_memory=False)
data1 = pd.read_csv(r'D:\test\cinfoDB.csv',encoding='ANSI',low_memory=False)
data2 = pd.read_csv(r'D:\test\cinfo.csv',encoding='ANSI',low_memory=False)
data01 = pd.merge(data,data1[['pay_sch_no','规格']],how = 'left',left_on = '支付表号',right_on = 'pay_sch_no')
data012 = pd.merge(data01,data2[['PAY_CODE','型','名称']],how = 'left',left_on = '编号',right_on = 'P_CODE')
data012.to_csv('D:\spcinfo.csv',index=False)
说明:
1.引入pandas库
2.读取目标表,用pd.read_csv(),
问题1,r',采用这个是为了防止跳路径,可用可不用