Adding new row in a CSV Python

Question

I am adding a new row to a specific CSV that already exist, but for unknown reason the new row is being added along with the last row and not in a new one.

So, it's showing in CSV as:

11-07-2016,38361,9076,14487,292,741614-07-2016,38417,9767,15832,301,7416

When should be showing as:

11-07-2016,38361,9076,14487,292,7416
14-07-2016,38417,9767,15832,301,7416

My code is:

import time
import csv


today = (time.strftime("%d-%m-%Y"))
newRow = """%s,%s,%s,%s,%s,%s""" % (today, yes, ok, war, leg, noag)
fd = open('data.csv','a')
fd.write(newRow)
fd.close()

Any idea why this is happening? Thanks a lot.

Eugene Yarmash · Accepted Answer · 2016-07-14 14:32:25Z

2

It looks like the file doesn't have a newline at the end. Try adding one before appending the new line:

newRow = "\n%s,%s,%s,%s,%s,%s\n" % (today, yes, ok, war, leg, noag)
with open("data.csv", "a") as f:
    f.write(newRow)

answered Jul 14, 2016 at 14:32

Eugene Yarmash

152k44 gold badges346 silver badges391 bronze badges

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

6 Comments

Ohad Eytan Over a year ago

You solved his specific problem, but did this help him understand what went wrong?

Gonzalo Over a year ago

actually I think I understood, adding the\n it forced the newRow to be in a new row, right? Thank you.

Ohad Eytan Over a year ago

@Gonzalo that's right if you use the file as a text file. But if you want to use it as a csv file with the csv module you don't need to add the \n manualy.

Gonzalo Over a year ago

but now the file has a empty row between each line.. it happens everytime i run the code.. so somehing must be wrong.

Ohad Eytan Over a year ago

@Gonzalo that because you add \n at the beginning and at the end of the newRow.

|

Ohad Eytan · Accepted Answer · 2016-07-14 14:49:12Z

0

Right now you are not using the csv module, just the regular write as for text file.

To treat the file as a csv change:

fd.write(newRow)

to:

csv_writer = csv.writer(fd)
csv_writer.writerow(newRow)

If you want to edit the file as a text file you should add the "new line charecter" manualy, so:

fd.write('\n' + newRow)

will work (in that case the import csv is redundant)

edited Jul 14, 2016 at 14:49

answered Jul 14, 2016 at 14:37

Ohad Eytan

8,5341 gold badge24 silver badges32 bronze badges

Comments

Wboy · Accepted Answer · 2016-07-14 14:59:01Z

0

import time
import csv


today = (time.strftime("%d-%m-%Y"))
newRow = """%s,%s,%s,%s,%s,%s""" % (today, yes, ok, war, leg, noag)
with open('data.csv','a',newline='') as fd:
    writer = csv.writer(fd)
    writer.writerow(newRow)

It's writerow instead of write, it'll automatically add a new line. and newline = '' prevents your skip a line.

edited Jul 14, 2016 at 14:59

answered Jul 14, 2016 at 14:32

Wboy

2,5722 gold badges27 silver badges51 bronze badges

Collectives™ on Stack Overflow

Adding new row in a CSV Python

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related