读取NE40E接口信息

'''

python

import re
import pandas as pd
data = []
final_data=[]
current = {}
 
with open('test.txt') as f:
    for line in f.readlines():
        # 如果是#开头，说明需要换行
        if line.startswith('interface'):
            data.append(current)
            current = {}
        if line.startswith("interface"):
            current["接口"]=re.findall(r"interface (.*)",line)[0] 
        elif line.startswith(' mtu'):
            current["MTU"]=re.findall(r"mtu (\d+)",line)[0] 
        elif line.startswith(" ip binding"):
            current["VPN"]=re.findall(r" ip binding vpn-instance (.*)",line)[0]
        if line.startswith(" ip address "):
            current["IPv4地址"]=re.findall(r" ip address (.*)",line)[0] 
        if line.startswith(" ipv6 address "):
            current["IPv6地址"]=re.findall(r" ipv6 address (.*)",line)[0]
        elif line.startswith(' description '):
            current["描述"]=re.findall(r" description (.*)",line)[0] 
        elif line.startswith("interface NULL0"):
            break
data.append(current)
final_data=filter(None,data)
#print(list(final_data))
#print(data)
#  数据存入excel
df = pd.DataFrame(data)
df.to_excel('result.xlsx', index=False)
'''