Difference between revisions of "Rename files using excel as source template"
Jump to navigation
Jump to search
Line 4: | Line 4: | ||
import shutil | import shutil | ||
os.chdir('C:\\Users\\ | os.chdir('C:\\Users\\one\\Downloads\\test') | ||
data = pd.read_excel(r"rename.xlsx") | data = pd.read_excel(r"rename.xlsx") | ||
orginal = "C:\\Users\\ | orginal = "C:\\Users\\one\\Downloads\\test\\original" | ||
dest = "C:\\Users\\ | dest = "C:\\Users\\one\\Downloads\\test\\img" | ||
old = data['oldname'] | old = data['oldname'] |
Revision as of 17:42, 24 March 2023
import os import pandas as pd import shutil os.chdir('C:\\Users\\one\\Downloads\\test') data = pd.read_excel(r"rename.xlsx") orginal = "C:\\Users\\one\\Downloads\\test\\original" dest = "C:\\Users\\one\\Downloads\\test\\img" old = data['oldname'] new = data['newname'] for (old, new) in zip(old,new): full_file_name = os.path.join(orginal,old) full_file_name_old = os.path.join(dest,old) full_file_name_new = os.path.join(dest,new) shutil.copy(full_file_name,dest) os.rename(full_file_name_old, full_file_name_new) print(full_file_name, full_file_name_new)