XML to DataFrame | Pythontic.com

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