Python Forum
Changing Index of 2 List in python - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Changing Index of 2 List in python (/thread-32785.html)



Changing Index of 2 List in python - giddyhead - Mar-05-2021

Hi Everyone,

I have an issue/concern I have two lists column A(albm) and column N(tlt) and below are the code I used to create the lists.
What I am seeking to do is put Column A which NASB and NTSB is and Column N where the tracks are? How can I accomplish this? Thanks
cb = sheet2.cell(row=acaw+1, column=1)
           albm.append(cb.value)
tlt = sheet2.cell(row=acaw+1, column=1)
            tlt =sheet2.cell(row=acaw + 1, column=14)


spreadsheet = [
    Column A   Column N
    ( "NASB", "Track1.mp3" ),
    ( "NASB", "Track2.mp3" ),
    ( "NASB", "Track3.mp3" ),
    ( "NASB", "Track4.mp3" ),
    ( "NASB", "Track5.mp3" ),
    ( "NASB", "Track5.mp3" ),
    ( "NTSB", "Track1.mp3" ),
    ( "NTSB", "Track2.mp3" ),
    ( "NTSB", "Track3.mp3" ),
    ( "NTSB", "Track4.mp3" ),
    ( "NTSB", "Track5.mp3" ),
    ( "NTSB", "Track5.mp3" )