title: Parsing a nested XML with python
body: <p>I have searched and tried the python library for XML data such as xml.etree.ElementTree and have looked for a similar solution from StackOverflow and other websites. However, I haven't found yet the solution for my case.</p>
  <p>The XML file that I have as shown below:</p>
  <pre><code>&lt;xmlInfo&gt;
    &lt;NodeName Dn=&quot;Santiago_server&quot;/&gt;
    &lt;DataInfo&gt;  
      &lt;Period duration=&quot;60&quot; end=&quot;2020-11-19 18:00:00&quot;/&gt;
      &lt;measT X=&quot;1&quot;&gt;CPU&lt;/measT&gt;
      &lt;measT X=&quot;2&quot;&gt;Memory&lt;/measT&gt;
      &lt;measT X=&quot;3&quot;&gt;Disk&lt;/measT&gt;
      &lt;measV object=&quot;Server#1&quot;&gt;
          &lt;P X=&quot;1&quot;&gt;7&lt;/r&gt;
          &lt;P X=&quot;2&quot;&gt;3&lt;/r&gt;
          &lt;P X=&quot;3&quot;&gt;8&lt;/r&gt;
      &lt;/measV&gt;
      &lt;measV object=&quot;Server#2&quot;&gt;
          &lt;P X=&quot;1&quot;&gt;10&lt;/r&gt;
          &lt;P X=&quot;2&quot;&gt;12&lt;/r&gt;
          &lt;P X=&quot;3&quot;&gt;11&lt;/r&gt;
      &lt;/measV&gt;
    &lt;/DataInfo&gt;
  &lt;/xmlInfo&gt;
  </code></pre>
  <p>The expected result from the above XML file as shown below:</p>
  <pre><code>Date         Time        CPU-Server#1   CPU-Server#2    Memory-Server#1   Memory-Server#2   Disk-Server#1   Disk-Server#2             
  2020-11-19   18:00:00         7            10               3                   12               8                11
  </code></pre>
  <p>Your feedback is really appreciated.</p>
  <p>Thank you</p>