用于检查条件和输出标签的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(''))更多推荐
发布评论