import pandas as pd
import os
import shutil
path=(r'F:\选图\武夷山\新建文件夹')
newpath=(r'F:\选图\武夷山\新建文件夹')
f=os.listdir(path)
f.sort(key=lambda x:int(x[:-8]+x[-6]))
print(len(f))
oldnames=[]
for i in range(len(f)):
i=f[i]
oldname=path+'\\'+i
oldnames.append(oldname)
nameslist=[]
for i in f:
name=i[-6]
nameslist.append(name)
print(nameslist)
countlist=[]
for i in range(len(nameslist)-1):
if nameslist[i]>nameslist[i+1] or nameslist[i]==nameslist[i+1]:
countlist.append(nameslist[i])
countlist.append(3)
listpath=(r'F:\选图\武夷山\文件名.xlsx')
data=pd.read_excel(listpath,1)
datalist=data['文件名'].tolist()
print(countlist[:10])
print(oldnames[:10])
for i in countlist:
i=int(i)
print(i)
while i >0:
oldname=oldnames[i-1]
print(oldname)
s=datalist[0]
newname=oldname[:14]+s+'('+str(i)+')'+'.JPG'
print(newname)
os.rename(oldname,newname)
shutil.move(newname,newpath)
oldnames.pop(i-1)
i-=1
datalist.pop(0)
countlist.pop(0)