import os
import pandas as pd
data=pd.read_excel(r'C:\Users\Administrator\Desktop\工作簿1.xlsx')#excel表格
files=os.listdir(r'D:\收集整理')#要改的文件夹
#print(data['合并'])
for name in data['课程负责人']:#看看表中有哪些
for file in files:#看看文件夹中有哪些
if name in file:
for mingming in data['合并']:#要命名的文字
if name in mingming:
try:
os.rename(os.path.join(r'D:\收集整理',file),os.path.join(r'D:\收集整理',mingming+'.pdf'))
print('ok')
except:print('错误')