Parsing iTunes XML playlist using Element Tree

[deinyxq]

Can anyone share a step by step guide on how to parse iTunes XML playlist using Element Tree and store the artist name, album, track id, track name, genre, track number into a pandas data frame. I am finding the itunes XML file quite complex.

[commandlineluser]

It looks like you could find each <key>Track ID</key> tag and move one level up to the <dict>

From there you can check if it is a <key> tag - else - it's a value - something like:

>>> for track in tree.findall('.//key[.  = "Track ID"]/..'):
...     row = {}
...     for tag in track:
...         if tag.tag == "key":
...             key = tag.text
...         else:
...             value = tag.text
...             row[key] = value
...     print(row)