python实现以下matlab功能absheet1=xlsreadCUsers94665DesktopC附件1xlsx;cdsheet2=xlsreadCUsers94665Desktop工作簿10xlsx;A = cell2tablesheet1 VariableNames 单品编码单品名称分类编码分类名称;B = cell2tablesheet2 VariableNames 销售日期扫码销售

import pandas as pd

sheet1 = pd.read_excel("C:\Users\94665\Desktop\C\附件1.xlsx") sheet2 = pd.read_excel("C:\Users\94665\Desktop\工作簿10.xlsx")

A = pd.DataFrame(sheet1, columns=['单品编码','单品名称','分类编码','分类名称']) B = pd.DataFrame(sheet2, columns=['销售日期','扫码销售时间','单品编码','销量(千克)','销售单价(元/千克)','销售类型','是否打折销售']) A = A.iloc[1:] B = B.iloc[1:]

for i in range(len(B)): for j in range(len(A)): if B.iloc[i, 2] == A.iloc[j, 0]: B.iloc[i, 8:10] = A.iloc[j, 1:4] break