Difference between revisions of "Rename files using excel as source template"
Jump to navigation
Jump to search
| (10 intermediate revisions by the same user not shown) | |||
| 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'] | ||
| Line 23: | Line 23: | ||
</pre> | </pre> | ||
'''Excel Spreadsheet''' | |||
{|class="wikitable" style="padding:5px;border:1px solid black;" | |||
!oldname | |||
!newname | |||
|- | |||
|004.jpg | |||
|house.jpg | |||
|- | |||
|- | |||
|001.jpg | |||
|cat.jpg | |||
|- | |||
|- | |||
|002.jpg | |||
|mouse.jpg | |||
|- | |||
|- | |||
|003.jpg | |||
|hosue.jpg | |||
|- | |||
|} | |||
==[[#top|Back To Top]] - [[Python|Category]]== | ==[[#top|Back To Top]] - [[Python|Category]]== | ||
[[Category:Python]] | [[Category:Python]] | ||
Latest revision as of 19:21, 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)
Excel Spreadsheet
| oldname | newname |
|---|---|
| 004.jpg | house.jpg |
| 001.jpg | cat.jpg |
| 002.jpg | mouse.jpg |
| 003.jpg | hosue.jpg |