Python copy paster files

Viewed 34

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)
0 Answers
Related