XML to table form in Excel

Mappy Show answered on May 8, 2022 Popularity 6/10 Helpfulness 2/10

answer XML to table form in Excel

XML to table form in Excel

Comment

def has_children(e):
    ''' Check if element, e, has children'''
    return(len(list(e)) > 0)

def has_attrib(e):
    ''' Check if element, e, has attributes'''
    return(len(e.attrib)>0)

def get_uniqe_key(mydict, key):
    ''' Generate unique key if already exists in mydict'''
    if key in mydict:
        while key in mydict:
            key = key + '*'

    return(key)

tree = ET.parse('input2.xml')

root = tree.getroot()

# Get first level:
lvl_one = list(root)

myList = [];
for e in lvl_one:

    mydict  = {}
    # Iterate over each node in level one element
    for node in e.iter():

        if (not has_children(node)) & (node.text != None):
            uniqe_key = get_uniqe_key(mydict, node.tag)
            mydict[uniqe_key] = node.text

        if has_attrib(node):
            for key in node.attrib:
                uniqe_key = get_uniqe_key(mydict, key)
                mydict[uniqe_key] = node.attrib[key]

    myList.append(mydict)

print(pd.DataFrame(myList))

Popularity 6/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: excel python xml

Link to this answer
Share Copy Link

Contributed on May 08 2022

Mappy Show

0 Answers Avg Quality 2/10

XML to table form in Excel

Contents

More Related Answers

XML to table form in Excel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.