Python - Read text and write into csv. Replace empty columns as a default 'N/A' value-CodePudding

I have a txt file, 'iteration.txt'. I only want to grab the data after 'Section' to be written into csv.
'Section A' has 2 inputs & outputs. 'Section B' has no inputs and outputs, I would like to put 'N/A' at empty columns.

'iteration.txt'

Input-> 000
Output-> 000
Codex153 @ Section_A_Iterating
Input-> 101
Output-> 010
unwanted data
Input-> 320
Output-> 321
unwanted data
Codex173 @ Section_B_Extracting
Codex183 @ Section_C_Iterating
unwanted data
unwanted data
Input->011
Output-> 011

Code I've done:

with open('iteration.csv', 'w') as writer:
    flag = False
    writer.write ('Section,Input,Output' '\n')
    for eachline in open('iteration.txt').readlines():

        if 'Section' in eachline:
            flag = True
            writer.write (eachline.split()[-1] '\n')
            #print (section_list)

        if flag:
            if 'Input' in eachline:
                writer.write (eachline.strip()   '\n')

            if 'Output' in eachline:
                writer.write(eachline.strip()   '\n')

Csv output from code above:

Expected csv data:

Sorry I'm new in this, I'm not too sure how do I put 'N/A' at empty columns, and how to place the data according to it's respective headers. Is there any simple way to do this, preferrably without changing the code above too much? Thanks!

CodePudding user response：

with the function .fillna('N/A') you can fill empty or non existing values.