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

Question

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!

score 2 · Accepted Answer · answered Oct 12 '21 at 13:23

2

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

answered Oct 12 '21 at 13:23

Passi

127
1
13

OP isn't using pandas. – BigBen Oct 12 '21 at 15:31
Thanks for the comment. I see, hmm... is there a way to do that without using pandas? – SirCuddles Oct 13 '21 at 01:56
This might work. Repace the empty String wirh "N/A" with the help of regex. https://stackoverflow.com/questions/16720541/python-string-replace-regular-expression – Passi Oct 13 '21 at 06:15
yourstring.replace("", "N/A") should work – Passi Oct 13 '21 at 06:28

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

1 Answers1