how to sort out files according to excel

Question

I have an Excel file that contains long product tag name like(for now, just working on 3 of them):

1. 4049047000037
2. 4049047000044
3. 4049047118954

and i have a folder on my desktop called "1" containing .jpg files with tag names like:

1. 4049047000037.jpg
2. 4049047000044.jpg
3. 4049047118954.jpg

i want to write a code, if tag name in my excel, i want to copy that .jpg file to an other folder.

import os
import pandas as pd
movdir = ["C:\Users\muhammedcan\Desktop\1"]
basedir = "C:\Users\muhammedcan\Desktop\2"
i=0

#to see what i have in my folder
print os.listdir("C:/Users/muhammedcan/Desktop/1/")

df= pd.read_excel("deneme.xls", sheetname= "sayfa4")
df1= df.columns[1]

listSepalWidth = df[df1]
print listSepalWidth

#to make file name and product tag name same
for i in listSepalWidth:
    i=str(i)+(".jpg")
    print i

can you help me with copying file into an other file if it is exist in my excel?

this is my result so far:

['4049047000037.jpg', '4049047000044.jpg', '4049047000068.jpg', 
'4049047000075.jpg', '4049047000082.jpg', '4049047000105.jpg', 
'4049047118947.jpg', '4049047118954.jpg']

4049047000037.jpg
4049047000044.jpg
4049047118954.jpg
4049047000068.jpg
4049047000075.jpg
4049047000082.jpg
4049047118947.jpg
4049047000105.jpg

I used following code, and I am recieving error.

from shutil import copyfile

copyfile("C:\Users\muhammedcan\Desktop\1", "C:\Users\muhammedcan\Desktop\2")

Error is:

    C:\Python27\python.exe "C:/Users/muhammedcan/Desktop/summer 
    courses/programing/MP4/solution/my_work.py"
    Traceback (most recent call last):
  File "C:/Users/muhammedcan/Desktop/summer courses/programing/MP4/solution/my_work.py", line 3, in <module>
    copyfile("C:\Users\muhammedcan\Desktop\1", 

Process finished with exit code 1

Answer 1

The following should do what you are looking for:

import os
import glob
import pandas as pd
import shutil

source_folder = r"C:\Users\muhammedcan\Desktop\1"
destination_folder = r"C:\Users\muhammedcan\Desktop\2"

available_filenames = [os.path.basename(fn) for fn in glob.glob(os.path.join(source_folder, '*.jpg'))]
df = pd.read_excel("deneme.xls", sheetname="sayfa4")

for tag_name in df.iloc[:,1]:
    filename = "{}.jpg".format(tag_name)

    if filename in available_filenames:
        print "{} - found".format(filename)
        shutil.copyfile(os.path.join(source_folder, filename), os.path.join(destination_folder, filename))
    else:
        print "{} - not found".format(filename)

If first creates a list of .jpg filenames found in the source_folder. It then loads the Excel file into pandas and iterates over the second column. If the tag name is found in the list of available_filenames the shutil.copyfile() function is used to copy the file from 1 to 2. Note os.path.join() is used to safely join parts of a file together.

---

To make it into a function to let you also do 'pdf' you could do:

import os
import glob
import pandas as pd
import shutil

source_folder = r"C:\Users\muhammedcan\Desktop\1"
destination_folder = r"C:\Users\muhammedcan\Desktop\2"

df = pd.read_excel("deneme.xls", sheetname="sayfa4")


def copy_files(source_folder, destination_folder, extension):
    available_filenames = [os.path.basename(fn) for fn in glob.glob(os.path.join(source_folder, '*.{}'.format(extension)))]

    for tag_name in df.iloc[:,1]:
        filename = "{}.{}".format(tag_name, extension)

        if filename in available_filenames:
            print "{} - found".format(filename)
            shutil.copyfile(os.path.join(source_folder, filename), os.path.join(destination_folder, filename))
        else:
            print "{} - not found".format(filename)

copy_files(source_folder, destination_folder, 'jpg')            
copy_files(source_folder, destination_folder, 'pdf')                   

This assumes the same deneme.xls is used for both. If not it could be passed as another argument to the function.