I am trying to copy and paste an specific files, using an ID as key to find each file. However, I encountered this error:
FileNotFoundError: [Errno 2] No such file or directory: 'S:/Risk/Folder/DailyLetters//210996712201.pdf'
I put a for loop to go ID by ID to find all the files and copy into the new path.
import pandas as pd
import shutil
NewFilePath=r'C:\Users\GWEBB\Desktop\\'
NewFile='cases.xlsx' #AQUI CAMBIO
NewFilePath =NewFilePath.replace('\\', '/')
File= pd.read_excel(f'{NewFilePath}{NewFile}', sheet_name="Sheet1")
File=File[['ID']]
File['ID']= File['ID'].astype(str)
for i, row in File.iterrows():
case_number=File['ID'].loc[i]
original = r'S:\Risk\Folder\DailyLetters\\{0}.pdf'.format(case_number)
original =original.replace('\\', '/')
target = r'C:\Users\GWEBB\Desktop\Cases\{0}.pdf'.format(case_number)
target =target.replace('\\', '/')
shutil.copyfile(original, target)