xxxxxxxxxx
import pandas as pd
df = pd.read_xml("filename.xml")
xxxxxxxxxx
import pandas as pd
import xml.etree.ElementTree as et
xtree = et.parse("students.xml")
xroot = xtree.getroot()
df_cols = ["name", "email", "grade", "age"]
rows = []
for node in xroot:
s_name = node.attrib.get("name")
s_mail = node.find("email").text # if node is not None else None
s_grade = node.find("grade").text # if node is not None else None
s_age = node.find("age").text # if node is not None else None
rows.append({"name": s_name, "email": s_mail,
"grade": s_grade, "age": s_age})
out_df = pd.DataFrame(rows, columns = df_cols)
xxxxxxxxxx
path = 'AttributesXMLPandas.xml'
dfcols = ['ID', 'Text', 'CreationDate']
root = et.parse(path)
rows = root.findall('.//row')
# NESTED LIST
xml_data = [[row.get('Id'), row.get('Text'), row.get('CreationDate')]
for row in rows]
df_xml = pd.DataFrame(xml_data, columns=dfcols)
print(df_xml)
# ID Text CreationDate
# 0 1 (...) 2011-08-30T21:15:28.063
# 1 2 (...) 2011-08-30T21:24:56.573
# 2 3 (...) None