Extra blank lines in csv file when directing from stdout

Asked Nov 18 '19 at 08:19

Active Nov 18 '19 at 08:19

Viewed 136 times

When the output of this program is redirected into a csv file there is a blank line between the two lines of output.

The other solution I found on S.O involved changing the way that the output file is opened, but since I'm using stream redirection it doesn't seem to apply.

Could someone kindly suggest how I might be able to eliminate these extra spaces it would be greatly appreciated. Also please note that I am new to python and coding in general.

def output_data(aggregrate_objects):

    header = []
    results = []

    for object in aggregrate_objects:       #generate header
            header.append(object.name)

    for object in aggregrate_objects:       #generate results
            results.append(object.get_result())            


    writer = csv.writer(sys.stdout,dialect='excel',lineterminator=os.linesep)

    writer.writerow(header)        

    writer.writerow(results)

asked Nov 18 '19 at 08:19

Hunter Bursey

Also note I removed the unnecessary loop :) – Hunter Bursey Nov 18 '19 at 08:23
I am thinking this might be the reason , cannot test now but there might be possible solution here https://stackoverflow.com/questions/38074811/what-is-os-linesep-for – nithin Nov 18 '19 at 08:32
can you try `lineterminator='\n'` insteasd – Minato Nov 18 '19 at 08:33
that worked! but now I am curious of what behavior to expect when I run it on a linux machine... would it be the same? Thank you! – Hunter Bursey Nov 18 '19 at 08:37

Extra blank lines in csv file when directing from stdout

0 Answers0