Appending new row to csv in python

Question

I have a csv of the form:

name,age,country john,23,japan mel,27,ireland

When I try to append with the following code:

import csv info=['kirsty','32','germany'] with open('data.csv','a') as file: writer=csv.writer(file) writer.writerow(info) file.close()

I get this on opening the file in notepad:

name,age,country john,23,japan mel,27,irelandkirsty,32,germany

I dont understand why the new entry isn't appending to the next line.

Agreed. So something like writer.writerow("\n") before you write the info — Haris Nadeem
– Haris Nadeem, Commented Apr 13, 2018 at 12:38
I've tried that and the quotes around \n also show up in the new csv. — West
– West, Commented Apr 13, 2018 at 12:45
Are we really discussing how to add a newline to the file now? Just add file.write('\n'). — Aran-Fey
– Aran-Fey, Commented Apr 13, 2018 at 13:32

Maaaaa · Accepted Answer · 2018-04-13 12:41:09Z

1

You can add "\n" before each new line.

answered Apr 13, 2018 at 12:41

3883 silver badges16 bronze badges

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

1 Answer 1