统计数通设备NTP server

'''

python

import re
import pandas as pd
import os
data = []
final_data=[]
current = {}
txt_files = []
i=1
for root, dirs, files in os.walk(os.getcwd()):
    for file in files:
        if file.endswith(".txt"):
            if len(file)>20:
                txt_files.append(os.path.join(root, file))
for file_name in txt_files:
    current = {}
    i=1
    with open(file_name, 'r') as file:
        if "NE40E" in file_name or "NE8000" in file_name:
            for line in file.readlines():
                if line.startswith("sysname "):
                    current["设备名称"]=re.findall(r"sysname (\S+)",line)[0]
                if line.startswith("ntp-service ipv6 source-interface "):
                    current["接口"]=re.findall(r"ntp-service ipv6 source-interface (.*) vpn-instance \S+",line)[0]
                    current["接口vpn"]=re.findall(r"ntp-service ipv6 source-interface \S+ vpn-instance (\S+)",line)[0]
                elif line.startswith("ntp-service unicast-server ipv6 "):
                    current["Server%d" %i]=re.findall(r"ntp-service unicast-server ipv6 (\S+) vpn-instance \S+",line)[0]
                    current["Server_vpn%d" %i]=re.findall(r"ntp-service unicast-server ipv6 \S+ vpn-instance (\S+)",line)[0]
                    i=i+1
                elif line.startswith("rsa peer-public-key "):
                    break
        else:
            for line in file.readlines():
                if line.startswith("sysname "):
                    current["设备名称"]=re.findall(r"sysname (\S+)",line)[0]
                if line.startswith("ntp ipv6 source-interface "):
                    current["接口"]=re.findall(r"ntp ipv6 source-interface (.*) vpn-instance \S+",line)[0]
                    current["接口vpn"]=re.findall(r"ntp ipv6 source-interface \S+ vpn-instance (\S+)",line)[0]
                elif line.startswith("ntp unicast-server ipv6 "):
                    current["Server%d" %i]=re.findall(r"ntp unicast-server ipv6 (\S+) vpn-instance \S+",line)[0]
                    current["Server_vpn%d" %i]=re.findall(r"ntp unicast-server ipv6 \S+ vpn-instance (\S+)",line)[0]
                    i=i+1
                elif line.startswith("rsa peer-public-key "):
                    break
                elif line.startswith("vlan batch "):
                    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)
'''