how to parse XML with multiple child elements to array in python

Question

im trying to read xml file to array or list the xml file has multiple child elements :

<Items>
<Company CompanyName="company name">
    <Category CategoryName="main category name" />
    <Category CategoryName="sub category name">
        <Product MAKAT="SKU">
            <Name>name</Name>
            <Price>XXX</Price>
            <IsInStock>Yes</IsInStock>
            <URL>url</URL>
        </Product>
    </Category>
    </Category>
</Company>

i have tried to do this :

tree = ET.parse(xmlFile)
root = tree.getroot()
products=[]
for item in tree.findall('Company'):
    print(item.attrib)
for subitem in tree.findall('CategoryName'):
    print(subitem.attrib)

but i cant reach to all the elements.

i want to reach to all child elements, and insert them into one array . what is the best way to do it in python ?

MJimitater · Accepted Answer · 2019-09-20 19:29:11Z

1

You can iterate through all children by using the method iter(), like this:

for elem in root.iter():
    print(elem.tag)

If you want to store the elements in array products, you can do this with numpy: be sure to use np.array([elem]) in order to make np.append() work.

answered Sep 20, 2019 at 19:29

MJimitater

9395 gold badges15 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dvir Yadae Over a year ago

thank you . but i can add the products to the array only with numpy

Collectives™ on Stack Overflow

how to parse XML with multiple child elements to array in python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related