pandas - How to convert Cisco Switch SVI configuration to Excel in python

Question

I have a text file with thousands of Cisco switch SVI configuration that I want to convert to excel. How do I achieve this with python? I want each SVI information to be in separate rows.

Text file format:

interface Vlan2
 ip vrf forwarding CustomerA
 ip address 192.168.1.1 255.255.255.0
!
interface Vlan3
 ip vrf forwarding CustomerB
 ip address 192.168.2.1 255.255.255.0
!
interface Vlan4
 ip vrf forwarding CustomerC
 ip address 192.168.3.1 255.255.255.0
!
interface Vlan5
 ip vrf forwarding CustomerD
 ip address 192.168.4.1 255.255.255.0

Answer 1

等待大神答复