XML To DataFrame

Overview:

The read_xml() function of the pandas module reads data in XML format from a file or from a string and creates a DataFrame object with the contents of the XML.
 

Example:

# Example Python program that reads an xml file
# and populates the contents into a pandas
# DataFrame
import pandas
import xml.etree.ElementTree as ET

# XML file path
xmlFilePath = "./AlkaliMetal.xml"

# Read XML into a pandas DataFrame
df = pandas.read_xml(xmlFilePath)

# Print the DataFrame contents
print("XML as DataFrame:")
print(df)

Contents of the input XML file:

<?xml version='1.0' encoding='utf-8'?>
<Elements>
<Element>
    <Name>Lithium</Name>
    <Symbol>Li</Symbol>
    <ElectronCount>3</ElectronCount>
    <Group>Alkali Metal</Group>
</Element>    
<Element>
    <Name>Sodium</Name>
    <Symbol>Na</Symbol>
    <ElectronCount>11</ElectronCount>
    <Group>Alkali Metal</Group>
</Element>    
<Element>
    <Name>Potassium</Name>
    <Symbol>Ka</Symbol>
    <ElectronCount>19</ElectronCount>
    <Group>Alkali Metal</Group>
</Element>    
<Element>
    <Name>Rubidium</Name>
    <Symbol>Rb</Symbol>
    <ElectronCount>37</ElectronCount>
    <Group>Alkali Metal</Group>
</Element>    
<Element>
    <Name>Cesium</Name>
    <Symbol>Cs</Symbol>
    <ElectronCount>55</ElectronCount>
    <Group>Alkali Metal</Group>
</Element>    
<Element>
    <Name>Francium</Name>
    <Symbol>Fr</Symbol>
    <ElectronCount>87</ElectronCount>
    <Group>Alkali Metal</Group>
</Element>    
</Elements>

Output:

XML as DataFrame:

        Name Symbol  ElectronCount         Group

0    Lithium     Li              3  Alkali Metal

1     Sodium     Na             11  Alkali Metal

2  Potassium     Ka             19  Alkali Metal

3   Rubidium     Rb             37  Alkali Metal

4     Cesium     Cs             55  Alkali Metal

5   Francium     Fr             87  Alkali Metal

 


Copyright 2022 © pythontic.com