Writing a list to a CSV un Python

Question

I have this code for writing a list to a CSV file, but when I run it, it creates spaces between each of the lines I want to write. To show you, this is my code:

savelst = [[1,2,3,4,5],[1,2,3,4,5]]
with open('file.csv', 'w') as f:
    writer = csv.writer(f, delimiter=',')
    writer.writerows(savelst)

and it gives me this result:

1,2,3,4,5

1,2,3,4,5

So I don't want the space in between.

Strange. I just ran your code using `Python 3.6.1` and I did not get any whitespace between the lines. Which version did you use? — Sheldore, Aug 02 '18 at 12:21
I used python 3.6 as well. But I already solved the problem. — ProgramMeALife, Aug 02 '18 at 17:02

Shashank Verma · Accepted Answer · 2018-08-02T12:40:46.870

3

Change the line where you open the file as:

with open('file.csv', 'w', newline='') as f:

Adding the newline argument as '' will remove the new lines from your output file.

edited Aug 02 '18 at 12:40

answered Aug 02 '18 at 12:19

Shashank Verma

369
1
14

In fact it removes the additional newline. – Serge Ballesta Aug 02 '18 at 12:21
I meant new lines, but I wrote spaces there by mistake. Corrected it now. – Shashank Verma Aug 02 '18 at 12:41

Writing a list to a CSV un Python

1 Answers1