Answers for "how to get data from xml in python"

python read xml

from xml.dom import minidom

# parse an xml file by name
mydoc = minidom.parse('items.xml')

items = mydoc.getElementsByTagName('item')

# one specific item attribute
print('Item #2 attribute:')
print(items[1].attributes['name'].value)

# all item attributes
print('\nAll attributes:')
for elem in items:
    print(elem.attributes['name'].value)

# one specific item's data
print('\nItem #2 data:')
print(items[1].firstChild.data)
print(items[1].childNodes[0].data)

# all items data
print('\nAll item data:')
for elem in items:
    print(elem.firstChild.data)

xml to python list in python

def pasrsexml(dateiname):
    d = []
    try:
        baum = dom.parse(dateiname)
        for eintrag in baum.firstChild.childNodes: 
            if eintrag.nodeName == "tr": 
                schluessel = wert = None
                wert=1
                for knoten in eintrag.childNodes: 
                    if knoten.nodeName == "td": 
                        try:
                            schluessel = knoten.firstChild.data.strip()
                        except Exception:
                           schluessel = " "
                        d.append(schluessel)
    except Exception:
        d.append("ERROR")           
    return d