Write to next line python csv

Question

I am working on a project which I figured would need to use something like a CSV document for storing data. But I ran into a problem, I need python to write the variable into the next line every time instead of the first line (this is overwriting the existing data in that column). Could anyone please help me to solve my problem?

Here is my code:

import csv
tag=input('Enter label for the new profile: ')
pwd=input('Type password for the new profile: ')
b=open('database.csv', 'w',)
a=csv.writer(b)
a.writerow([tag,pwd])
b.close()

Thanks in advance.

idjaw · Accepted Answer · 2015-11-08 17:52:58Z

2

You want to use 'append' mode for your write.

Change your 'w' mode in your open 'a'.

Change this:

b=open('database.csv', 'w',)

to this:

b=open('database.csv', 'a',)

Read the documentation here on the different modes

'w' for only writing (an existing file with the same name will be erased), and 'a' opens the file for appending; any data written to the file is automatically added to the end.

answered Nov 8, 2015 at 17:52

idjaw

26.8k10 gold badges68 silver badges84 bronze badges

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

Collectives™ on Stack Overflow

Write to next line python csv

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