Moving files to Folders

[giddyhead]

Hello everyone, I am trying move files based upon a the names in the spreadsheet. The files in the folder also has the same name. What I want to do is to move the files to specific folders for example:

Column N1:Filename, N2:Outro.mp3, N3:Intro.mp3, N4:piano.mp3, etc
The folder where the Files are have the same names: Outro.mp3, N3:Intro.mp3, N4:piano.mp3, etc

In Column A in the same spreadsheet they are two albums Instrumental and Vocals.

Lastly in the root folders of Instrumental and Vocals are folders of combined values of 3 columns for example 1 - HGH - Tonic(Script), 2 - LOW - Legat(Pause), etc. How can the code below be modified to search for the songs in the folder as well as the excel document and separate them by albums and into the subfolders 1 - HGH - Tonic(Script), 2 - LOW - Legat(Pause) which are also folders from combined values in the same spreadsheet? Thanks

for root, dirs, files, in os.walk('C:\\Users\\mrdrj\\Desktop\\NASB - Copy\\'): # Location of Songs
        for name in files: # List of Songs in Folder
            for songnmz in sngnms: #List of Corrected Songs in Excel
                if name.find(songnmz) and albmz == 'NTt':
                    print(name)

[Larz60+]

Please show:

1. A sample spreadsheet, just one row
   
2. Source folder file name (that match spreadsheet sample)
   
3. Corrected file folder filename (that match spreadsheet sample)
   
4. new file name for above
   

[giddyhead]

I have tried to drag and drop the spreadsheet with only the first row and with the file names however it keeps asking to download. Is there another way I can add it to the forum?

[giddyhead]

Update: The following is the link Excel Document to the excel document. On the 2nd Tab it has the root folder and the subfolders as well. Thanks

[giddyhead]

Update: The following is the link Excel Document to the excel document. On the 2nd Tab it has the root folder and the subfolders as well. Thanks

Update statement: I am have the following for loops and what I am attempting to accomplish is to compare the files in the folder with the files names in the excel document and to see if they are one of two albums(OT or NT). If they are for example OT they will be moved to the OT subdirector ->Subfolders:->1 - GEN - Genesis, 2 - EXO - Exodus, etc and the same if NT ->Subfolders:->1 - MAT - Matthew, 2 - MRK - Mark, etc

for root, dirs, files, in os.walk('C:\\Users\\mrdrj\\Desktop\\Stephen Johnston\\NASB - Copy\\'): # Location of Songs
    for name in files: # List of Songs in Folder
        for songnmz in sngnms: #List of Corrected Songs in Excel
            for albmz in albm:
                if name.find(songnmz):# and songnmz albmz == 'Nasb Audio Bible Old Testament':
                    if songnmz == name and albmz == 'Nasb Audio Bible Old Testament':
                        print('name', name)
                    #os.shutil
                else:
                    print('Not Old Testament')
                    #os.shutil

When I run the above code I the Not Old Testament is what comes comes up. How can this code be fixed? Thanks.

[deanhystad]

What does .find() return?

[Larz60+]

Is there another way I can add it to the forum?

If you click on New reply, at the bottom of the page you will see New Attachment.
click on browse, find the file and then open.
Next click Add attachment, then insert into post

[giddyhead]

What does .find() return?

When I use print('List of Names', name) under the name.find(songnmz) it produces multiple instances of the same files for example, file 1(several times) then goes to next file 2(several times), etc.

[giddyhead]

Is there another way I can add it to the forum?

If you click on New reply, at the bottom of the page you will see New Attachment.
click on browse, find the file and then open.
Next click Add attachment, then insert into post

Thanks for the information. When I click on New reply it resets to the quick reply option.

[Larz60+]

you should be able to attach after 5 posts see rules here: https://python-forum.io/misc.php?action=help&hid=31
perhaps you are not scrolling down far enough on the New Reply page (attach is at bottom).
Works for me, but my account is different. Please try again