Python XML to csv

Question

I am learning Python right now on version 2.6.4 The first thing I am trying to do is trying to parse only the value of an attribute (orderno) and print those out. Secondly I am trying to parse through the XML and find a value of an attribute like 10238 from attribut "orderno", but print out the whole item as a csv line like "10238,1,Hasselblad 501 CM body,2355" Any pointers on how to do it?

from xml.etree import ElementTree
tree = ElementTree.parse('sample.xml')
root = tree.getroot()

for item in root:
    first = item.find('orderno').text
    print first

Data:

<item> 
<orderno>10238</orderno>
<count>1</count>
<name>Hasselblad 501 CM body</name> 
<price>2355</price>
</item> 
<item> 
<orderno>20032</orderno>
<count>1</count>
<name>Carl Zeiss Planar Lens CB 2.8/80 mm</name>
<price>1233</price>
</item> 
<item>
<orderno>30212</orderno>
<count>1</count>
<name>Roll Film 120 Magazine A12</name>
<price>917</price>
</item>

um, if this is python then it's in serious need of code indentation, current one just confuses me — Zharf
– Zharf, Commented Mar 10, 2017 at 13:37
Your xml didn't change doesn't affect my comment. Regardless, you have no logic to find every item tag. Please try it — OneCricketeer
– OneCricketeer, Commented Mar 10, 2017 at 13:39

Szabolcs · Accepted Answer · 2017-03-10 13:52:15Z

1

You basically need to iterate through all subelements. Here I've iterated through the sub items through list comprehension and joined the list with comma!

from xml.etree import ElementTree
tree = ElementTree.parse('sample.xml')
root = tree.getroot()

for item in root:
    print ','.join([sub_item.text for sub_item in item])

Sample Output:

10238,1,Hasselblad 501 CM body,2355
20032,1,Carl Zeiss Planar Lens CB 2.8/80 mm,1233
30212,1,Roll Film 120 Magazine A12,917

Hope it helps!

edited Mar 10, 2017 at 13:52

Szabolcs

4,11620 silver badges44 bronze badges

answered Mar 10, 2017 at 13:44

Keerthana Prabhakaran

3,8071 gold badge16 silver badges25 bronze badges

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

1 Comment

stefPan Over a year ago

Works perfectly!

Collectives™ on Stack Overflow

Python XML to csv

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related