Python CSV Overwrite

Question

I'm trying to write this code so that once it ends the previous answers are saved and the code could be run again without the old answers being overwritten. I moved the how, why and scale_of_ten variables into 'with open' section and I had some success with the code being able to work for the amount of times the files was executed, but each time it was executed the old answers were overwritten. How would I write the code so that it saves the old answers while it takes in new answers?

import csv
import datetime
# imports modules

now = datetime.datetime.now()
# define current time when file is executed

how = str(raw_input("How are you doing?"))
why = str(raw_input("Why do you feel that way?"))
scale_of_ten = int(raw_input("On a scale of 1-10. With 10 being happy and 1 being sad. How happy are you?"))
#creates variables for csv file

x = [now.strftime("%Y-%m-%d %H:%M"),how,why,scale_of_ten]
# creates list for variables to be written in

with open ('happy.csv','wb') as f:
    wtr = csv.writer(f)
    wtr.writerow(x)
    wtr.writerow(x)
    f.close()

If you're already using with, no need to close the file again. — aIKid
– aIKid, Commented Dec 21, 2013 at 8:37

falsetru · Accepted Answer · 2013-12-21 08:52:28Z

10

With w mode, open truncates the file. Use a (append) mode.

....

with open ('happy.csv', 'ab') as f:
    #                    ^
    ....

BTW, f.close() is not needed if you use with statement.

edited Dec 21, 2013 at 8:52

answered Dec 21, 2013 at 8:32

falsetru

371k69 gold badges770 silver badges660 bronze badges

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

1 Comment

Robert Birch Over a year ago

So I just get rid f.close() and change 'wb' to 'ab'?

Collectives™ on Stack Overflow

Python CSV Overwrite

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related