pandas实现表连接

import pandas as pd

change_data = pd.read_excel("待修改.xlsx")
data = pd.read_excel("源文件.xlsx")
data["列名"] = data["列名"].drop_duplicates()

new_data = change_data.merge(data, how="left", on="列名")

new_data.to_excel("new_data.xlsx", index=False)