Python读取文件并解析所需数据

Question

嗨，我在看一个文件数据.txt格式如下。你知道吗

Last table change time   : 69 days, 0:17:19 ago
Number of table inserts  : 93
Number of table deletes  : 87
Number of table drops    : 0
Number of table age-outs : 0

Port       Neighbor Device ID             Neighbor Port ID           TTL
Et2/1      CN-Arista2                       Ethernet5/1                120
Et2/2      CN-Arista2                       Ethernet5/2                120
Et2/3      CN-Arista3                       Ethernet5/3                120
Et2/4      CN-Arista                       Ethernet5/4                120
Et64/1     CN-Spine2                      Ethernet64/1               120
Ma1        Arista01.Dmech.rack01             Ethernet1                  120

我需要把它放在下面

Et2/1, CN-Arista2, Ethernet5/1
Et2/2, CN-Arista2, Ethernet5/2
Et2/3, CN-Arista3, Ethernet5/3
Et2/4, CN-Arista, Ethernet5/4
Et64/1, CN-Spine2, Ethernet64/1
Ma1, Arista01.Dmech.rack01, Ethernet1 

Answer 1

试试这个：

fi = open('data.txt')
fo = open('data.csv')
for line in fi:
     L = line.split()
     S = ' '.join(L[5:8]).replace(',','') +', ' + ', '.join(L[14: : 6]) + '\n'
     fo.write(S)
fo.close()
fi.close()