python批量复制粘贴_用python批量复制特定图片

今天一个小运营,要从图片库里,复制一些特定的图片传给平台小二用,大概几百张的样子,用货号手工一个一个查找粘贴太慢了,于是我就帮他做了一个小小的python

先上代码

import pandas as pd

mystore = pd.read_excel(r'C:\Users\HQQ\Desktop\copy图片.xlsx',encoding = 'GBK')

pic = mystore['SKU'].values.tolist()

for i in range(len(pic)):

f_src = open(r"C:\Users\HQQ\Pictures\\"+pic[i]+'.jpg','rb')

content = f_src.read()

f_copy = open(pic[i]+'.jpg','wb')

f_copy.write(content)

f_src.close()

f_copy.close()

接下来是操作gif演示: