Parsing nested XML in Python?

Question

I have the following goodreads response:

<GoodreadsResponse>
   <Request>
   </Request>
   <book>
    <popular_shelves>
        <shelf name="test" other="1"/>
        <shelf name="test2" other="2"/>
    </popular_shelves/>
   </book>
</GoodreadsResponse>

I want to retrieve the popular_shelves 2nd shelf item. (index 1).

Attempt 1:

from xml.etree import ElementTree as ET

  root = ET.parse(urllib.urlopen(baseEndpoint+bookName)).getroot()
  for atype in root.findall('book/popular_shelves'):
    print(atype.get('shelf'))

Attempt 2:

  genre = root.find('book').findall('popular_shelves')[0].findall('shelf')
  print genre[0].text

What did you get with those attempts?

Jongware
– Jongware

2018-11-25 19:29:49 +00:00
Commented Nov 25, 2018 at 19:29 — Jongware
– Jongware, Commented Nov 25, 2018 at 19:29

singleton · Accepted Answer · 2018-11-25 21:18:43Z

1

This is how I got the 2nd shelf item from popular_shelves:

import xml.etree.ElementTree as ET

payload = '''
<GoodreadsResponse>
   <Request>
   </Request>
   <book>
    <popular_shelves>
        <shelf name="test" other="1"/>
        <shelf name="test2" other="2"/>
    </popular_shelves>
   </book>
</GoodreadsResponse>
'''

root = ET.fromstring(payload)
shelves = root.findall("./book/popular_shelves/shelf") # this will get you the list of shelves
print shelves[1].get('name') # fetching the name of 2nd shelf item

So, we can load all shelf items under ./book/popular_shelves into a list. And, then use the list index to access 1st, 2nd, etc. shelf items.

answered Nov 25, 2018 at 21:18

singleton

1116 bronze badges

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

Comments

panda912 · Accepted Answer · 2018-12-03 09:46:28Z

0

you can try module untangle, it simple and easy to work with, for example:

In [95]: from untangle import parse

In [96]: payload = '''
    ...: <GoodreadsResponse>
    ...:    <Request>
    ...:    </Request>
    ...:    <book>
    ...:     <popular_shelves>
    ...:         <shelf name="test" other="1"/>
    ...:         <shelf name="test2" other="2"/>
    ...:     </popular_shelves>
    ...:    </book>
    ...: </GoodreadsResponse>
    ...: '''

In [97]: obj = parse(payload)

In [98]: shelf1 = obj.GoodreadsResponse.book.popular_shelves.shelf[1]

In [99]: vars(shelf1)
Out[99]:
{'_attributes': {u'name': u'test2', u'other': u'2'},
 '_name': u'shelf',
 'cdata': '',
 'children': [],
 'is_root': False}

answered Dec 3, 2018 at 9:46

panda912

4165 silver badges7 bronze badges

Collectives™ on Stack Overflow

Parsing nested XML in Python?

Attempt 1:

Attempt 2:

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Attempt 1:

Attempt 2:

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related