csv writing alternate whitespace in lines within a loop python

Question

I have a code for generating a csv file shown below.

import csv

csvData = [["HAI", "Hello"]]
while(1):
    with open('test.csv', 'a') as csvFile:
        writer = csv.writer(csvFile, delimiter=',', quoting=csv.QUOTE_ALL)
        writer.writerows(csvData)
    csvFile.close()

When i run this code it will generate a csv file like this

1."HAI","Hello"

3."HAI","Hello"

That is it will generate on alternative lines,that is first write takes palce on line 1 ,second write takes on line 3.I want to write it on line 2. Anybody please help me.

You can try using the approach specified in my answer below. I tested it with your minimal working example, and it produced the correct output for me. — dennlinger
– dennlinger, Commented Jun 19, 2018 at 6:13

dennlinger · Accepted Answer · 2018-06-19 06:12:12Z

2

If you look at the documentation for CSV formatting parameters, you will see that there is the argument lineterminator, which defaults to \r\n.

You can get your desired output by simply passing a regular \n like so:

writer = csv.writer(csvFile, delimiter=",", quoting=csv.QUOTE_ALL, lineterminator="\n")

answered Jun 19, 2018 at 6:12

dennlinger

11.7k2 gold badges47 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

csv writing alternate whitespace in lines within a loop python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related