python - Parse spesific information from several .txt file into single file excel/csv

Question

I have several .txt files that i want to parse into single csv files or .txt files if not possible.

I have input data structure like this one.

A:Router1# /show router ospf interface 

===============================================================================
OSPFv2 (0) all interfaces
===============================================================================
If Name               Area Id         Designated Rtr  Bkup Desig Rtr  Adm  Oper
-------------------------------------------------------------------------------
system                0.0.0.0         124.195.96.10   0.0.0.0         Up   DR
to_Router2        0.0.0.0         0.0.0.0         0.0.0.0         Up   PToP
to-Router3            0.0.0.0         0.0.0.0         0.0.0.0         Up   Down
to_Router4            0.0.0.0         0.0.0.0         0.0.0.0         Up   PToP
to-Router5            0.0.0.0         0.0.0.0         0.0.0.0         Up   Down
to_Router6            0.0.0.0         0.0.0.0         0.0.0.0         Up   Down
-------------------------------------------------------------------------------
No. of OSPF Interfaces: 6
===============================================================================
* indicates that the corresponding row element may have been truncated.
A:Router1# /show router ospf 2 interface 
MINOR: CLI OSPFv2 instance 2 in VR-ID 1, not configured.
A:Router1# /show router ospf 3 interface 
MINOR: CLI OSPFv2 instance 3 in VR-ID 1, not configured.
A:Router1# /show router ospf 4 interface 
MINOR: CLI OSPFv2 instance 4 in VR-ID 1, not configured.
A:Router1# /show router ospf 17 interface 

===============================================================================
OSPFv2 (17) all interfaces
===============================================================================
If Name               Area Id         Designated Rtr  Bkup Desig Rtr  Adm  Oper
-------------------------------------------------------------------------------
to_Router8 0.0.0.17        0.0.0.0         0.0.0.0         Up   PToP
to_Router9   0.0.0.17        0.0.0.0         0.0.0.0         Up   Down
-------------------------------------------------------------------------------
No. of OSPF Interfaces: 2
===============================================================================
A:Router1#

I need to parse into expected following output

Source	Target	Area Id	Designated Rtr	Bkup Desig	Adm	Oper
Router1	system	0.0.0.0	124.195.96.10	0.0.0.0	Up	DR
Router1	to_Router2	0.0.0.0	0.0.0.0	0.0.0.0	Up	PToP
Router1	to-Router3	0.0.0.0	0.0.0.0	0.0.0.0	Up	Down
Router1	to_Router4	0.0.0.0	0.0.0.0	0.0.0.0	Up	PToP
Router1	to-Router5	0.0.0.0	0.0.0.0	0.0.0.0	Up	Down
Router1	to_Router6	0.0.0.0	0.0.0.0	0.0.0.0	Up	Down
Router1	to_Router8	0.0.0.17	0.0.0.0	0.0.0.0	Up	PToP
Router1	to_Router9	0.0.0.17	0.0.0.0	0.0.0.0	Up	Down

Answer 1

等待大神答复