i am trying to load data from many of xmls with etree.ElementTree.

My data looks like this.

<mydata>
<Record>
<Field name="ParaA">2927695</Field>
<Field name="Index"/>
<Field name="ParaB">D:pathdata</Field>
<Field name="ParaC">116.4</Field>
<Field name="ParaD">1583.4</Field>
<Field name="ParaBE">12.0</Field>
<Row>
<Field name="Para1">1</Field>
<Field name="Para2">D5A</Field>
<Field name="Para3">1586.0</Field>
</Row>
<Row>
<Field name="Para1">2</Field>
<Field name="Para2">D4A</Field>
<Field name="Para3">118.0</Field>
<Field name="Para4">12.0</Field>
</Row>
</Record>
</mydata>

The number of row is dynamic. I want do get a df with
ParaA | Para1 | Para2

Already read the documentation but was not able to solve it. I think the problem is that row is under record.

Hope someone can help.