import os import pandas as pd df = pd.read_excel("data.xls") id_list = os.listdir("./") for id in id_list: id_p = id[:id.find(".")] id_n = id[id.find("."):] for co in df.values: if str(co[0]) == str(id_p): new_name = co[1]+id_n print(f"开始重命名: {id} -> {new_name}") os.rename(id, new_name) print("重命名结束")