Difference between revisions of "Rename files using excel as source template"
Jump to navigation
Jump to search
| Line 37: | Line 37: | ||
</pre> | </pre> | ||
{| | {|class="wikitable" style="margin:auto;border:1px solid black;" | ||
|Oldname | |Oldname | ||
|Newname | |Newname | ||
Revision as of 18:50, 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 |