import pandas
def read_excel():
data1 = pandas.read_excel(r'C:\Users\HP\Desktop\4.xlsx') #待合并表1
print(data1)
data2 = pandas.read_excel(r'C:\Users\HP\Desktop\labels.xlsx')#待合并表2
print(data2)
data3 = pandas.merge(data1, data2, on = 'label', right_index = True, how = 'right')#on选择合并字段关键字,how选择合并方式
print(data3)
data3.to_excel(r'C:\Users\HP\Desktop\5.xlsx',index=False)
read_excel()
合并两个表的数据
最新推荐文章于 2022-10-27 17:27:24 发布