csv file ouput that with a single row space

Question

I write a list of tuples to a csv file. Specifically the input would look something like this:

newList = [
    ('02-02-2018','18:06:06'),
    ('01-04-2018','15:08:03'),
    ('23-05-2018','07:10:15'),
]

This is what I've tried:

with open('newCSV.csv','w') as newFile:
    writer = csv.writer(newFile)
    writer.writerow(['date','time'])
    writer.writerows(newList)
newFile.close()

The output file like this :

    date        time
 1  02-02-2018  18:06:06
 2
 3  01-04-2018  15:08:03
 4
 5  23-05-2018  07:10:15

why the output file have blank rows between the rows? can someone help me?

My output file is perfectly fine, how do you open it to display that output ? — Born Tbe Wasted, Apr 05 '19 at 11:37
What is your Python's version? (And your `newFile.close()` is useless as you're using a context manager) — mistiru, Apr 05 '19 at 11:46

Sumant Hegde · Accepted Answer · 2019-04-05T11:54:30.570

1

while opening the file specify what need to be printed for the new line

with open('newCSV.csv','w', newline='') as newFile:

edited Apr 05 '19 at 11:54

answered Apr 05 '19 at 11:43

Sumant Hegde

61
3

csv file ouput that with a single row space

1 Answers1