怎么用python提取特定的字段到excel表格中

Question

提取特定的字段到excel表格中
interface Eth-Trunk2.2999
mtu 9000
description To-[DM-TOR-02]-Eth-Trunk2-210G
ip binding vpn-instance NMS_tenant
ipv6 enable
ip address 192.168.254.1 255.255.255.252
ipv6 address 2001:3001:900:8FF1:201::/127
ipv6 mtu 9000
dot1q termination vid 2999
#
interface Eth-Trunk3
undo portswitch
description TO-[ZCE01-HWNE40EX8A]-Eth-Trunk43-210G
mode lacp-static
lacp timeout fast
#
interface Eth-Trunk3.2950
description TO-[ZCE02-HWNE40EX8A]-Eth-Trunk43.2950
ip binding vpn-instance NMS_tenant
ipv6 enable
ip address 10.20.59.126 255.255.255.252
ipv6 address 2001:3001:900:8FF1:1::500/127
ipv6 mtu 9000
dot1q termination vid 2950

想把上面的数据变成excel表格

Answer 1

import pandas as pd
columns = ['interface', 'mtu', 'description', 'ip binding']     # 配置列名,我这里列名随便写的，按照需要把列名放进列表
data = []
current = {}

with open('test.txt') as f:
    for line in f.readlines():
        # 如果是#开头，说明需要换行
        if line.startswith('#'):
            data.append(current)
            current = {}
        else:
            for column in columns:
                # 同一行的数据转化为字典
                if line.startswith(column):
                    current[column] = line.replace(column, '').replace('\n', '').strip()

#  数据存入excel
df = pd.DataFrame(data)
df.to_excel('result.xlsx', index=False)