Difference between revisions of "Rename files using excel as source template"

From rbachwiki
Jump to navigation Jump to search
Line 44: Line 44:
|house.jpg
|house.jpg
|-
|-
}
|}


==[[#top|Back To Top]] - [[Python|Category]]==
==[[#top|Back To Top]] - [[Python|Category]]==
[[Category:Python]]
[[Category:Python]]

Revision as of 18:49, 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)


<b>oldname	newname
004.jpg	house.jpg
004.jpg	house_1.jpg
005.jpg	bulldog.jpg
005.jpg	dog.jpg
003.jpg	tree.jpg
001.jpg	pizza.jpg
002.jpg	cat.jpg
001.jpg	pizza2.jpg
002.jpg	cat_1.jpg

Oldname Newname
004.jpg house.jpg

Back To Top - Category