python pandas rename_使用Pandas重命名文件

我试图用excel工作表和pandas重命名文件，但是我一直收到一个IO错误。在“文件名”列中，我有原始文件名以及“重命名”列中的原始文件名。我知道还有其他方法可以做到这一点，但我不明白为什么下面的方法不起作用。在import os

import pandas as pd

from os.path import join

import shutil

dir = os.path.dirname(__file__)

excelFile = join(dir,'test.xlsx')

output_image_dir = os.path.join(dir,'PREAPPROVAL')

df = pd.read_excel(excelFile, sheetname='rename')

for x,y in zip(df['Filename'].astype('str'),df['rename']):

x = join(output_image_dir,x)

y = join(output_image_dir,y)

shutil.move(x,y)

Traceback (most recent call last):

File "D:\Dropbox\1. Projects\2. Python\2. X1\rename_images.py", line 26, in

shutil.move(x,y)

File "c:\python27\lib\shutil.py", line 302, in move

copy2(src, real_dst)

File "c:\python27\lib\shutil.py", line 130, in copy2

copyfile(src, dst)

File "c:\python27\lib\shutil.py", line 82, in copyfile

with open(src, 'rb') as fsrc:

IOError: [Errno 2] No such file or directory: 'D:\\Dropbox\\1. Projects\\2. Python\\2. X1\\PREAPPROVAL\\VERT.jpg'

[Finished in 0.3s]