搜索
搜索

Python XML 元素树过滤

pablo808 发表于 Dev
19
pablo808

我是 python 和 XML 的新手，所以很抱歉。

在我查询的 XML 文件中，“组”类别之一称为“接入点”。 

 <group id="1">Access Points</group>

我怎样才能过滤它，并且只将它输出到屏幕上？

for i in tree.iter('ap'):
id=i.attrib

if i.find('group')!=None:
    group=i.find('group').text
else: group=" "   

if i.find('lan_ip')!=None:
    ip=i.find('lan_ip').text
else: ip=" "    

if i.find('lan_mac')!=None:
    mac=i.find('lan_mac').text
else: mac=" "

if i.find('model')!=None:
    model=i.find('model').text
else: model=" "

if i.find('name')!=None:
    name=i.find('name').text
else: name=" "

if i.find('operating_mode')!=None:
    op_mode=i.find('operating_mode').text
else: op_mode=" "

print "\n"+"*"*30
print "#### Details of AP :{}".format(id).ljust(30)
print "*"*30
print "#### Group       :{}".format(group).ljust(30)
print "#### AP Name       :{}".format(name).ljust(30)
print "#### MAC Address   :{}".format(mac).ljust(30)
print "#### IP Address    :{}".format(ip).ljust(30)
print "#### Model         :{}".format(model).ljust(30)
print "#### Operating Mode:{}".format(op_mode).ljust(30)
print "*" * 30

测试数据

<?xml version="1.0" encoding="UTF-8"?>
<amp:amp_ap_list xmlns:amp="http://www.airwave.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1" xsi:schemaLocation="http://www.airwave.com amp_ap_list.xsd">
   <ap id="79">
      <altitude>0</altitude>
      <device_category>fat_ap</device_category>
      <client_count>1</client_count>
      <firmware>3.2.0</firmware>
      <fqdn />
      <group id="1">Access Points</group>
      <is_up>true</is_up>
      <is_remote_ap>true</is_remote_ap>
      <remote_outer_ip>10.1.1.1</remote_outer_ip>
      <remote_lan_ip>20.20.20.20</remote_lan_ip>
      <lan_ip>10.51.1.191</lan_ip>
      <lan_mac>00:20:A6:55:E6:E1</lan_mac>
      <last_contacted>1350379063</last_contacted>
      <last_reboot>1343644897</last_reboot>
      <mfgr>Proxim</mfgr>
      <model id="44">AP-700</model>
      <monitor_only>true</monitor_only>
      <name>ORiNOCO-AP-700-55-e6-e1</name>
      <operating_mode>ap</operating_mode>
      <planned_maintenance_mode>false</planned_maintenance_mode>
      <radio index="1">
         <antenna />
         <antenna_gain />
         <channel>1</channel>
         <display_channel>1</display_channel>
         <display_enabled>false</display_enabled>
         <display_transmit_power>22.5 dBm</display_transmit_power>
         <enabled>true</enabled>
         <operational_mode>g</operational_mode>
         <radio_interface>1</radio_interface>
         <radio_mac>00:20:A6:55:E6:E0</radio_mac>
         <radio_type>g</radio_type>
         <transmit_power>100%</transmit_power>
      </radio>
      <reboot_count>2</reboot_count>
      <serial_number>04UT43570051</serial_number>
      <snmp_uptime>0</snmp_uptime>
      <ssid>proxim_test</ssid>
      <syscontact />
      <syslocation />
      <upstream_device_id>3648</upstream_device_id>
      <upstream_port_index>16</upstream_port_index>
   </ap>
   <ap id="3648">
      <controller_id>9</controller_id>
      <device_category>thin_ap</device_category>
      <firmware>4.0.155.0</firmware>
      <group id="1">Access Points</group>
      <is_up>true</is_up>
      <lan_ip>10.51.1.16</lan_ip>
      <lan_mac>00:0B:85:62:64:70</lan_mac>
      <mfgr>Cisco</mfgr>
      <model id="94">Aironet 1030 LWAPP</model>
      <monitor_only>true</monitor_only>
      <name>aironet-1030-5</name>
      <operating_mode>ap</operating_mode>
      <planned_maintenance_mode>false</planned_maintenance_mode>
      <radio index="1">
         <antenna>Enabled</antenna>
         <antenna_gain>15</antenna_gain>
         <antenna_type>internal</antenna_type>
         <channel>1</channel>
         <display_channel>1</display_channel>
         <display_enabled>false</display_enabled>
         <enabled>true</enabled>
         <operational_mode>g</operational_mode>
         <radio_interface>1</radio_interface>
         <radio_mac>00:0B:85:62:64:70</radio_mac>
         <radio_role>ap</radio_role>
         <radio_type>g</radio_type>
         <transmit_power>7 dBm</transmit_power>
      </radio>
      <radio index="2">
         <antenna>Side B</antenna>
         <antenna_gain />
         <antenna_type>external</antenna_type>
         <channel>56</channel>
         <display_channel>56</display_channel>
         <display_enabled>true</display_enabled>
         <enabled>true</enabled>
         <operational_mode>a</operational_mode>
         <radio_interface>2</radio_interface>
         <radio_mac>00:0B:85:62:64:70</radio_mac>
         <radio_role>ap</radio_role>
         <radio_type>abg</radio_type>
         <transmit_power>5 dBm</transmit_power>
      </radio>
      <syscontact>dev team</syscontact>
      <syscontact>Second shelf from bottom</syscontact>
      <upstream_device_id />
      <upstream_port_index />
   </ap>
   <ap id="2418">
      <device_category>controller</device_category>
      <firmware>6.1.1.1</firmware>
      <group id="1">Access Points</group>
      <is_up>true</is_up>
      <lan_ip>10.51.3.119</lan_ip>
      <lan_mac>00:0B:86:61:16:5C</lan_mac>
      <mfgr>Aruba</mfgr>
      <model id="226">3200</model>
      <monitor_only>true</monitor_only>
      <name>Aruba3200-119</name>
      <operating_mode>ap</operating_mode>
      <planned_maintenance_mode>false</planned_maintenance_mode>
      <serial_number>AC0000479</serial_number>
      <syscontact>qa team</syscontact>
      <syslocation>Viewonly</syslocation>
      <upstream_device_id />
      <upstream_port_index />
   </ap>
   <ap id="1437">
      <device_category>switch</device_category>
      <firmware>12.2(25)SEE4</firmware>
      <group id="1">Access Points</group>
      <is_up>true</is_up>
      <lan_ip>10.51.0.26</lan_ip>
      <lan_mac>00:18:18:9E:C9:40</lan_mac>
      <mfgr>Cisco</mfgr>
      <model id="319">Catalyst 3560-24PS-S</model>
      <monitor_only>true</monitor_only>
      <name>switch7</name>
      <operating_mode>ap</operating_mode>
      <planned_maintenance_mode>false</planned_maintenance_mode>
      <serial_number>CAT10205436</serial_number>
      <syscontact />
      <syslocation>server room</syslocation>
      <upstream_device_id />
      <upstream_port_index />
   </ap>
</amp:amp_ap_list>
巴尔德曼

以下

import xml.etree.ElementTree as ET

xml = '''<?xml version="1.0" encoding="UTF-8"?>
<amp:amp_ap_list xmlns:amp="http://www.airwave.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1" xsi:schemaLocation="http://www.airwave.com amp_ap_list.xsd">
   <ap id="79">
      <altitude>0</altitude>
      <device_category>fat_ap</device_category>
      <client_count>1</client_count>
      <firmware>3.2.0</firmware>
      <fqdn />
      <group id="1">Access Points</group>
      <is_up>true</is_up>
      <is_remote_ap>true</is_remote_ap>
      <remote_outer_ip>10.1.1.1</remote_outer_ip>
      <remote_lan_ip>20.20.20.20</remote_lan_ip>
      <lan_ip>10.51.1.191</lan_ip>
      <lan_mac>00:20:A6:55:E6:E1</lan_mac>
      <last_contacted>1350379063</last_contacted>
      <last_reboot>1343644897</last_reboot>
      <mfgr>Proxim</mfgr>
      <model id="44">AP-700</model>
      <monitor_only>true</monitor_only>
      <name>ORiNOCO-AP-700-55-e6-e1</name>
      <operating_mode>ap</operating_mode>
      <planned_maintenance_mode>false</planned_maintenance_mode>
      <radio index="1">
         <antenna />
         <antenna_gain />
         <channel>1</channel>
         <display_channel>1</display_channel>
         <display_enabled>false</display_enabled>
         <display_transmit_power>22.5 dBm</display_transmit_power>
         <enabled>true</enabled>
         <operational_mode>g</operational_mode>
         <radio_interface>1</radio_interface>
         <radio_mac>00:20:A6:55:E6:E0</radio_mac>
         <radio_type>g</radio_type>
         <transmit_power>100%</transmit_power>
      </radio>
      <reboot_count>2</reboot_count>
      <serial_number>04UT43570051</serial_number>
      <snmp_uptime>0</snmp_uptime>
      <ssid>proxim_test</ssid>
      <syscontact />
      <syslocation />
      <upstream_device_id>3648</upstream_device_id>
      <upstream_port_index>16</upstream_port_index>
   </ap>
   <ap id="3648">
      <controller_id>9</controller_id>
      <device_category>thin_ap</device_category>
      <firmware>4.0.155.0</firmware>
      <group id="1">Access Points</group>
      <is_up>true</is_up>
      <lan_ip>10.51.1.16</lan_ip>
      <lan_mac>00:0B:85:62:64:70</lan_mac>
      <mfgr>Cisco</mfgr>
      <model id="94">Aironet 1030 LWAPP</model>
      <monitor_only>true</monitor_only>
      <name>aironet-1030-5</name>
      <operating_mode>ap</operating_mode>
      <planned_maintenance_mode>false</planned_maintenance_mode>
      <radio index="1">
         <antenna>Enabled</antenna>
         <antenna_gain>15</antenna_gain>
         <antenna_type>internal</antenna_type>
         <channel>1</channel>
         <display_channel>1</display_channel>
         <display_enabled>false</display_enabled>
         <enabled>true</enabled>
         <operational_mode>g</operational_mode>
         <radio_interface>1</radio_interface>
         <radio_mac>00:0B:85:62:64:70</radio_mac>
         <radio_role>ap</radio_role>
         <radio_type>g</radio_type>
         <transmit_power>7 dBm</transmit_power>
      </radio>
      <radio index="2">
         <antenna>Side B</antenna>
         <antenna_gain />
         <antenna_type>external</antenna_type>
         <channel>56</channel>
         <display_channel>56</display_channel>
         <display_enabled>true</display_enabled>
         <enabled>true</enabled>
         <operational_mode>a</operational_mode>
         <radio_interface>2</radio_interface>
         <radio_mac>00:0B:85:62:64:70</radio_mac>
         <radio_role>ap</radio_role>
         <radio_type>abg</radio_type>
         <transmit_power>5 dBm</transmit_power>
      </radio>
      <syscontact>dev team</syscontact>
      <syscontact>Second shelf from bottom</syscontact>
      <upstream_device_id />
      <upstream_port_index />
   </ap>
   <ap id="2418">
      <device_category>controller</device_category>
      <firmware>6.1.1.1</firmware>
      <group id="1">Access Points</group>
      <is_up>true</is_up>
      <lan_ip>10.51.3.119</lan_ip>
      <lan_mac>00:0B:86:61:16:5C</lan_mac>
      <mfgr>Aruba</mfgr>
      <model id="226">3200</model>
      <monitor_only>true</monitor_only>
      <name>Aruba3200-119</name>
      <operating_mode>ap</operating_mode>
      <planned_maintenance_mode>false</planned_maintenance_mode>
      <serial_number>AC0000479</serial_number>
      <syscontact>qa team</syscontact>
      <syslocation>Viewonly</syslocation>
      <upstream_device_id />
      <upstream_port_index />
   </ap>
   <ap id="1437">
      <device_category>switch</device_category>
      <firmware>12.2(25)SEE4</firmware>
      <group id="1">Access Points</group>
      <is_up>true</is_up>
      <lan_ip>10.51.0.26</lan_ip>
      <lan_mac>00:18:18:9E:C9:40</lan_mac>
      <mfgr>Cisco</mfgr>
      <model id="319">Catalyst 3560-24PS-S</model>
      <monitor_only>true</monitor_only>
      <name>switch7</name>
      <operating_mode>ap</operating_mode>
      <planned_maintenance_mode>false</planned_maintenance_mode>
      <serial_number>CAT10205436</serial_number>
      <syscontact />
      <syslocation>server room</syslocation>
      <upstream_device_id />
      <upstream_port_index />
   </ap>
     <ap id="143347">
      <device_category>switch</device_category>
      <firmware>12.2(25)SEE4</firmware>
      <group id="1">Other Group Name</group>
      <is_up>true</is_up>
      <lan_ip>10.51.0.26</lan_ip>
      <lan_mac>00:18:18:9E:C9:40</lan_mac>
      <mfgr>Cisco</mfgr>
      <model id="319">Catalyst 3560-24PS-S</model>
      <monitor_only>true</monitor_only>
      <name>switch7</name>
      <operating_mode>ap</operating_mode>
      <planned_maintenance_mode>false</planned_maintenance_mode>
      <serial_number>CAT10205436</serial_number>
      <syscontact />
      <syslocation>server room</syslocation>
      <upstream_device_id />
      <upstream_port_index />
   </ap>
</amp:amp_ap_list>'''

# Add more properties if you wish
INTERESTING_PROPERTIES = {'lan_ip', 'lan_mac', 'name'}

root = ET.fromstring(xml)
ap_access_points = [element for element in root.findall('.//ap') if element.find('./group').text == 'Access Points']
for ap in ap_access_points:
    print('ap: {}'.format(ap.attrib['id']))
    for child in list(ap):
        if child.tag in INTERESTING_PROPERTIES:
            print('\t{} --> {}'.format(child.tag, child.text))

输出

ap: 79
    lan_ip --> 10.51.1.191
    lan_mac --> 00:20:A6:55:E6:E1
    name --> ORiNOCO-AP-700-55-e6-e1
ap: 3648
    lan_ip --> 10.51.1.16
    lan_mac --> 00:0B:85:62:64:70
    name --> aironet-1030-5
ap: 2418
    lan_ip --> 10.51.3.119
    lan_mac --> 00:0B:86:61:16:5C
    name --> Aruba3200-119
ap: 1437
    lan_ip --> 10.51.0.26
    lan_mac --> 00:18:18:9E:C9:40
    name --> switch7

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。

编辑于
0

我来说两句

0 条评论
登录 后参与评论

相关文章

为什么python中的元素树在XML中添加额外的新行和空格

将具有相同标签的多个子元素添加到带有Python / Elementtree的XML树中

使用python元素树或Minidom进行嵌套XML解析

使用Python和元素树在标签内查找和替换XML数据

在Python的XML树中遍历子孙

Python：从xml文件构建差异路径/树

使用元素树解析XML（Python）

按元素过滤XML

用元素树解析XML

在Python上使用元素树解析Evernote xml：如何查找/删除具有特定标签名称的元素

使用xml.etree.ElementTree搜索XML元素树的属性

Python从XML树中删除重复的元素

python元素树iterparse过滤节点和子节点

使用元素树从python中的文件读取XML数据

从Python中XML树的子元素中提取所有文本

python：处理带有元素树的XML项目数组最好是“合并”

过滤返回的 XML 元素

如何使用 Python 过滤这棵树？

获取从 XML 分解的元素树

使用元素树python3解析XML文件

使用 Python xml.etree.ElementTree 遍历 XML 树的问题

Python XML 元素树解析大文档，返回子集

Python：XML 元素树 findall() 不返回任何内容

在 Python 中替换整个 XML 树

Python 和 XML：如何根据属性值过滤 xml 元素

从 URL python 读取 XML，按子元素过滤 XML 元素

在python中更改xml树的属性

Python元素树解析错误

XML 过滤器元素

TOP 榜单

  1. 1

    UITableView的项目向下滚动后更改颜色，然后快速备份

  2. 2

    Linux的官方Adobe Flash存储库是否已过时？

  3. 3

    用日期数据透视表和日期顺序查询

  4. 4

    应用发明者仅从列表中选择一个随机项一次

  5. 5

    Mac OS X更新后的GRUB 2问题

  6. 6

    验证REST API参数

  7. 7

    Java Eclipse中的错误13，如何解决？

  8. 8

    带有错误“ where”条件的查询如何返回结果？

  9. 9

    ggplot：对齐多个分面图-所有大小不同的分面

  10. 10

    尝试反复更改屏幕上按钮的位置 - kotlin android studio

  11. 11

    如何从视图一次更新多行（ASP.NET - Core）

  12. 12

    计算数据帧中每行的NA

  13. 13

    蓝屏死机没有修复解决方案

  14. 14

    在 Python 2.7 中。如何从文件中读取特定文本并分配给变量

  15. 15

    离子动态工具栏背景色

  16. 16

    VB.net将2条特定行导出到DataGridView

  17. 17

    通过 Git 在运行 Jenkins 作业时获取 ClassNotFoundException

  18. 18

    在Windows 7中无法删除文件（2）

  19. 19

    python中的boto3文件上传

  20. 20

    当我尝试下载 StanfordNLP en 模型时，出现错误

  21. 21

    Node.js中未捕获的异常错误，发生调用

热门标签

归档