用于检查条件和输出标签的XML，PYTHON(XML to check conditions and ouput tags, PYTHON)

用于检查条件和输出标签的XML，PYTHON(XML to check conditions and ouput tags, PYTHON)

我有一个xml文件，如下所示：

<records> <record> <device_serial_number>PAD203146024</device_serial_number> <device_serial_number_2>203146024</device_serial_number_2> <docsis_mac>6412695EB9BB</docsis_mac> </record> <record> <device_serial_number>PAD206024</device_serial_number> <device_serial_number_2>20324</device_serial_number_2> <docsis_mac>6412BB</docsis_mac> </record> </records>

我在python中使用ETree读取这个xml文件并运行良好，现在我想检查标签是否有以“PAD”开头的文本，如果它已经输出如下：

Expected output <record> <device_serial_number>PAD203146024</device_serial_number> <device_serial_number_2>203146024</device_serial_number_2> <docsis_mac>6412695EB9BB</docsis_mac> </record>

I have a xml file as shown below:

<records> <record> <device_serial_number>PAD203146024</device_serial_number> <device_serial_number_2>203146024</device_serial_number_2> <docsis_mac>6412695EB9BB</docsis_mac> </record> <record> <device_serial_number>PAD206024</device_serial_number> <device_serial_number_2>20324</device_serial_number_2> <docsis_mac>6412BB</docsis_mac> </record> </records>

I read this xml file using ETree in python and works well, now I want to check if tag has text starting with "PAD" if it has then output it as below:

Expected output <record> <device_serial_number>PAD203146024</device_serial_number> <device_serial_number_2>203146024</device_serial_number_2> <docsis_mac>6412695EB9BB</docsis_mac> </record>

最满意答案

import xml.etree.ElementTree as ET recs=[ET.tostring(c) for c in record if c.find('device_serial_number').text[:3]=='PAD'] for rec in recs: print(rec)

其中上面的record是for循环中的record元素，如您的问题所示。 这应该仅在 'device_serial_number'以PAD开头时返回您的记录，如下所示： -

<record> <device_serial_number>PAD203146024</device_serial_number> <device_serial_number_2>203146024</device_serial_number_2> <docsis_mac>6412695EB9BB</docsis_mac> </record> <record> <device_serial_number>PAD206024</device_serial_number> <device_serial_number_2>20324</device_serial_number_2> <docsis_mac>6412BB</docsis_mac> </record>

如果任何记录元素没有device_serial_number作为孩子，那么我将使用以下：

from xml.etree import ElementTree as ET from xml.dom.minidom import parseString tree = ET.parse('C:\\Use\\CO.xml') root = tree.getroot() for record in root.findall('records'): recs=[c for c in t if c.find('device_serial_number')!=None and c.find('device_serial_number').text[:3]=='PAD'] for rec in recs: print(parseString(ET.tostring(rec)).toprettyxml('')) import xml.etree.ElementTree as ET recs=[ET.tostring(c) for c in record if c.find('device_serial_number').text[:3]=='PAD'] for rec in recs: print(rec)

where record above is record element in the for loop as shown in your question. This should return your records only if 'device_serial_number' starts with PAD as below:-

<record> <device_serial_number>PAD203146024</device_serial_number> <device_serial_number_2>203146024</device_serial_number_2> <docsis_mac>6412695EB9BB</docsis_mac> </record> <record> <device_serial_number>PAD206024</device_serial_number> <device_serial_number_2>20324</device_serial_number_2> <docsis_mac>6412BB</docsis_mac> </record>

If any of the record elements do not have device_serial_number as a child then I would use the below:

from xml.etree import ElementTree as ET from xml.dom.minidom import parseString tree = ET.parse('C:\\Use\\CO.xml') root = tree.getroot() for record in root.findall('records'): recs=[c for c in t if c.find('device_serial_number')!=None and c.find('device_serial_number').text[:3]=='PAD'] for rec in recs: print(parseString(ET.tostring(rec)).toprettyxml(''))