python读取xml文件并转换为csv文件

Question

我正在尝试将xml文件转换为csv文件。如何读取和解析xml文件并转换成csv？有没有把xml转换成csv的包。在

<services>
    <service>
        <ServiceID>1</ServiceID>
        <ServiceName>eVoting Booth</ServiceName>
    </service>
    <service>
        <ServiceID>2</ServiceID>
        <ServiceName>Justice of the Peace</ServiceName>
    </service>
    <service>
        <ServiceID>3</ServiceID>
        <ServiceName>Library</ServiceName>
    </service>
        <service>
        <ServiceID>4</ServiceID>
        <ServiceName>Customer Service</ServiceName>
    </service>
    <service>
        <ServiceID>5</ServiceID>
        <ServiceName>Migrant Service</ServiceName>
    </service>
</services>

我想要的结果是

^{pr2}$

Answer 1

类似这样的方法可以奏效：

from lxml import etree
import pandas as pd

tree = etree.parse("input.xml")

df = pd.DataFrame({
    "ServiceID" : tree.xpath('/services/service/ServiceID/text()'),
    "ServiceName" : tree.xpath('/services/service/ServiceName/text()')
})

df.to_csv("output.csv", sep="|", index = None)

这就产生了

^{pr2}$