Rename files using excel as source template
Revision as of 17:41, 24 March 2023 by Bacchas (talk | contribs) (Created page with "<pre> import os import pandas as pd import shutil os.chdir('C:\\Users\\bacchas\\Downloads\\test') data = pd.read_excel(r"rename.xlsx") orginal = "C:\\Users\\bacchas\\Downloads\\test\\original" dest = "C:\\Users\\bacchas\\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...")
import os
import pandas as pd
import shutil
os.chdir('C:\\Users\\bacchas\\Downloads\\test')
data = pd.read_excel(r"rename.xlsx")
orginal = "C:\\Users\\bacchas\\Downloads\\test\\original"
dest = "C:\\Users\\bacchas\\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)