get metadata of mp3 files

win_mp3_file_metadata.py

import os
import win32com.client

folder = os.path.abspath(u'.')
folder_exists = os.path.exists(folder)

sh=win32com.client.gencache.EnsureDispatch('Shell.Application',0)    
ns=sh.NameSpace(folder)
    
colnum = 0
columns = []

while True:
    colname=ns.GetDetailsOf(None,colnum)
    if not colname:
        break
    columns.append(colname)
    colnum+=1

print(columns)

relevant_columns = [columns.index(x) for x in [
    'Titel', 'Titelnummer', 'Mitwirkende Interpreten'
]]

print(relevant_columns)

for item in ns.Items():
    print(str(item).split('_'))
    for colnum in relevant_columns:
        colval = ns.GetDetailsOf(item, colnum)
        if colval:
            print('\t', columns[colnum], colval)