[Python] Reading and storing XML data in arrays

Sorry if this question is stupid but I can't seem to get my way through it. I have a .xml file which looks like:


<?xml version="1.0" encoding="utf-8"?>
<tags>
<row Id="1" TagName="bayesian" Count="1342" ExcerptPostId="20258" WikiPostId="20257" />
<row Id="2" TagName="prior" Count="168" ExcerptPostId="62158" WikiPostId="62157" />
<row Id="3" TagName="elicitation" Count="6" />
<row Id="4" TagName="normality" Count="191" ExcerptPostId="67815" WikiPostId="67814" />
<row Id="5" TagName="open-source" Count="13" />
<row Id="6" TagName="distributions" Count="1880" ExcerptPostId="8046" WikiPostId="8045" />
<row Id="9" TagName="machine-learning" Count="2564" ExcerptPostId="9066" WikiPostId="9065" />
<row Id="10" TagName="dataset" Count="514" ExcerptPostId="20490" WikiPostId="20489" />
<row Id="11" TagName="sample" Count="219" ExcerptPostId="28276" WikiPostId="28275" />
<row Id="12" TagName="population" Count="120" ExcerptPostId="69287" WikiPostId="69286" />
<row Id="15" TagName="measurement" Count="97" ExcerptPostId="66319" WikiPostId="66318" />
<row Id="16" TagName="scales" Count="157" />


All I need to do is to read this .xml file and store the data in arrays so that I can analyze that. I do the following steps;

import xml.etree.ElementTree as ET
tree = ET.parse('Tags.xml')
root = tree.getroot()

print root
<Element 'tags' at 0x10365d810>
In [37]: root.attrib
Out[37]: {}

root.getchildren
Out[38]: <bound method Element.getchildren of <Element 'tags' at 0x10365d810>>

In [39]: root.getiterator
Out[39]: <bound method Element.getiterator of <Element 'tags' at 0x10365d810>>

In [40]: root.items
Out[40]: <bound method Element.items of <Element 'tags' at 0x10365d810>>

In [41]: root.keys
Out[41]: <bound method Element.keys of <Element 'tags' at 0x10365d810>>


Somehow, I can't find the step to oread the columns. Thanks for help, I am very new with Python and XML Prakash

Continue reading...