title: How to read XML file into Pandas Dataframe
body: <p>I have a xml file: 'product.xml' that I want to read using pandas, here is an example of the sample file:</p>
  <pre><code>&lt;?xml version=&quot;1.0&quot;?&gt;
   &lt;Rowset&gt;
    &lt;ROW&gt;
     &lt;Product_ID&gt;32&lt;/Product_ID&gt;
     &lt;Company_ID&gt;2&lt;/Company_ID&gt;
     &lt;User_ID&gt;90&lt;/User_ID&gt;
     &lt;Product_Type&gt;1&lt;/Product_Type&gt;
     &lt;Application_ID&gt;BBC#:1010&lt;/Application_ID&gt;
    &lt;/ROW&gt;
    &lt;ROW&gt;
     &lt;Product_ID&gt;22&lt;/Product_ID&gt;
     &lt;Company_ID&gt;4&lt;/Company_ID&gt;
     &lt;User_ID&gt;190&lt;/User_ID&gt;
     &lt;Product_Type&gt;2&lt;/Product_Type&gt;
     &lt;Application_ID&gt;NBA#:1111&lt;/Application_ID&gt;
    &lt;/ROW&gt;
    &lt;ROW&gt;
     &lt;Product_ID&gt;63&lt;/Product_ID&gt;
     &lt;Company_ID&gt;4&lt;/Company_ID&gt;
     &lt;User_ID&gt;99&lt;/User_ID&gt;
     &lt;Product_Type&gt;1&lt;/Product_Type&gt;
     &lt;Application_ID&gt;BBC#:1212&lt;/Application_ID&gt;
    &lt;/ROW&gt;
    &lt;ROW&gt;
     &lt;Product_ID&gt;22&lt;/Product_ID&gt;
     &lt;Company_ID&gt;2&lt;/Company_ID&gt;
     &lt;User_ID&gt;65&lt;/User_ID&gt;
     &lt;Product_Type&gt;2&lt;/Product_Type&gt;
     &lt;Application_ID&gt;NBA#:2210&lt;/Application_ID&gt;
    &lt;/ROW&gt;
  </code></pre>
  <p>I am trying to generate a 2D Table using pandas like:</p>
  <pre><code>Application ID Product Type  Product ID
  BBC#:1010            1         32
  NBA#:1111            2         22
  BBC#:1212            1         63  
  NBA#:2210            2         22   
  </code></pre>
  <p>so far, I have tried this code:</p>
  <pre><code>import xml.etree.cElementTree as ET
  import pandas as pd
  import pandas_read_xml as pdx
  df = pdx.read_xml('product.xml')
  path='product.xml'
  dfcols = ['Application_ID', 'Product_Type', 'Product_ID']
  root = et.parse(path)
  rows = root.findall('.//ROW')
  #NESTED LIST
  xml_data = [[row.get('Application_ID'), row.get('Product_Type'), row.get('Product_ID')] for row in rows]
  df_xml = pd.DataFrame(xml_data, columns=dfcols)
  
  print(df_xml)
  </code></pre>
  <p>How can I print that type of 2D Table?, please help, Thank you.</p>