如何使用python读取xml文件并以表格格式显示数据

Question

如何读取xml文件并将数据显示为表格格式？

<?xml version="1.0"?>
<issue>
<TABLE-A>
<EMPNO>1</EMPNO>
<ENAME>A</ENAME>
<SAL>100</SAL>
</TABLE-A>
<TABLE-B>
<ADDRESSID>AD1</ADDRESSID>
<STREET>A</STREET>
<PINCODE>11111</PINCODE>
</TABLE-B>
</issue>

Answer 1

如果只是这么简单，我会使用xmltodict和pandas

import xmltodict as xml
import pandas as pd
with open("data.xml", "r") as f:
raw_data = xml.parse(f.read())
data = pd.DataFrame.from_dict(raw_data["issue"])
print(data)

TABLE-A TABLE-B
EMPNO           1     NaN
ENAME           A     NaN
SAL           100     NaN
ADDRESSID     NaN     AD1
STREET        NaN       A
PINCODE       NaN   11111