Parsing Xml with element tree in Python, same tag name

Question

I'm using python to parse a XML file but I have a problem. I'm sure there is a way to solve it but I'm new on python and parsing xml...

So here a example of xml :

<TeamData Ref = "1">
    <Goal></Goal>
    <Goal></Goal>
    <Goal></Goal>
    <Goal></Goal>
</TeamData>
<TeamData Ref = "2">
    <Goal></Goal>
    <Goal></Goal>
    <Goal></Goal>
    <Goal></Goal>
</TeamData>

I want to store my element goal in two part in function of the team ref... How would I do that ? Because I tried :

for iterators in child.iter("TeamData"):
                something_to_store(iterators.tag)

But I have the list of all the 8 goals without difference in function of the teamdata ref !

sundar nataraj · Accepted Answer · 2014-09-08 09:59:44Z

1

a.xml

<?xml version="1.0"?>
<data>

<TeamData Ref = "1">
    <Goal>a</Goal>
    <Goal>b</Goal>
    <Goal>c</Goal>
    <Goal>d</Goal>
</TeamData>

<TeamData Ref = "2">
    <Goal>e</Goal>
    <Goal>f</Goal>
    <Goal>g</Goal>
    <Goal>h</Goal>
</TeamData>
    </data>

for each teamdata you need to iterate again to get Goals. so create dictonary with ref name as key and goals as values

import xml.etree.ElementTree as ET
tree = ET.parse('a.xml')
root = tree.getroot()
print root
dic={}
for i in root.iter('TeamData'):
    dic[i.attrib['Ref']]=[j.text for j in i]
print dic
#output {'1': ['a', 'b', 'c', 'd'], '2': ['e', 'f', 'g', 'h']}

answered Sep 8, 2014 at 9:59

sundar nataraj

8,7102 gold badges36 silver badges48 bronze badges

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

1 Comment

Karyo Over a year ago

what if there is a subelement between <Goal>e</Goal> and <Goal>f</Goal>? This parser seems to cannot extract text in a subelement. Please, how to also extract text from a subelement.

Collectives™ on Stack Overflow

Parsing Xml with element tree in Python, same tag name

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