如何使用python从文件夹中读取xml文件?

I have a an XML file like this:

我有一个这样的XML文件:

xml_='''\
<author type="XXX" language="EN" gender="xx" feature="xx" web="foobar.com">
    <documents count="N">
        <document KEY="e95a9a6c790ecb95e46cf15bee517651" web="www.foo_bar_exmaple.com"><![CDATA[A large text with lots of strings and punctuations symbols [...]
]]>
        </document>
        <document KEY="bc360cfbafc39970587547215162f0db" web="www.foo_bar_exmaple.com"><![CDATA[A large text with lots of strings and punctuations symbols [...]
]]>
        </document>
        <document KEY="19e71144c50a8b9160b3f0955e906fce" web="www.foo_bar_exmaple.com"><![CDATA[A large text with lots of strings and punctuations symbols [...]
]]>
        </document>
        <document KEY="21d4af9021a174f61b884606c74d9e42" web="www.foo_bar_exmaple.com"><![CDATA[A large text with lots of strings and punctuations symbols [...]
]]>
        </document>
        <document KEY="28a45eb2460899763d709ca00ddbb665" web="www.foo_bar_exmaple.com"><![CDATA[A large text with lots of strings and punctuations symbols [...]
]]>
        </document>
        <document KEY="a0c0712a6a351f85d9f5757e9fff8946" web="www.foo_bar_exmaple.com"><![CDATA[A large text with lots of strings and punctuations symbols [...]
]]>
        </document>
        <document KEY="626726ba8d34d15d02b6d043c55fe691" web="www.foo_bar_exmaple.com"><![CDATA[A large text with lots of strings and punctuations symbols [...]
]]>
        </document>
        <document KEY="2cb473e0f102e2e4a40aa3006e412ae4" web="www.foo_bar_exmaple.com"><![CDATA[A large text with lots of strings and punctuations symbols [...] [...]
]]>
        </document>
    </documents>
</author>
'''

Then I placed it into a pandas dataframe like this:

然后我把它放进一个熊猫数据存储器里，就像这样:

import pandas as pd
import xml.etree.ElementTree as ET

def iter_docs(author):
    author_attr = author.attrib
    for doc in author.iterfind('.//document'):
        doc_dict = author_attr.copy()
        doc_dict.update(doc.attrib)
        doc_dict['data'] = doc.text
        yield doc_dict


etree = ET.fromstring(xml_data) #create an ElementTree object 
doc_df = pd.DataFrame(list(iter_docs(etree)))

I would like to just pass the path of the file instead of creating an xml_data string variable, any idea of how to do this?.

我只想传递文件的路径，而不是创建一个xml_data字符串变量，这是怎么做的?

1 个解决方案

#1

From the docs: https://docs.python.org/2/library/xml.etree.elementtree.html#parsing-xml

从文档:https://docs.python.org/2/library/xml.etree.elementtree.html #解析xml

You can do:

你能做什么:

etree = ET.parse(filename)
root = etree.getroot()
doc_df = pd.DataFrame(list(iter_docs(root)))

#1