Python\ csv.writer deletes previous data instead of adding new to the file

Question

I'm a beginner with python so you can think that am i asking a stupid question, but i really can't understand why mine function is removing previous data in csvfile instead of adding new in to this file. That's how it looks like:

def writein():
    with open('employee data.csv', 'w') as employeeData:
        writeby = csv.writer(employeeData, delimiter = ',')
        writeNEN = input('Add name of new emp: \n')
        writeNESN = input('Add surname of new emp: \n')
        writeNEP = input('Add position of new emp: \n')
        writeNEBD = input('Add date of birth of new emp: \n')
        writeby.writerow([writeNEN, writeNESN, writeNEP, writeNEBD])

Have you guys any idea how to make program adding new data instead of replacing it?

burgerhex · Accepted Answer · 2018-09-20 05:30:53Z

3

When you open a file in write-mode (i.e. open('file.txt', 'w')), the contents are cleared before things are added. The fix to your problem would be to open the csv file in append-mode:

def writein():
    with open('employee data.csv', 'a') as employeeData:
                             #      ^
                             # a for append

answered Sep 20, 2018 at 5:30

burgerhex

1,0481 gold badge10 silver badges24 bronze badges

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

2 Comments

ArtFiNCH Over a year ago

Thanks, for a strange reason there is nothing about append here: docs.python.org/3.7/library/csv.html

burgerhex Over a year ago

I think you'll find this link useful.

Arihant · Accepted Answer · 2018-09-20 05:32:31Z

0

Use the below code with open('employee data.csv', 'a')

parameter 'a' instructs to append.

answered Sep 20, 2018 at 5:32

Arihant

7455 silver badges14 bronze badges

Collectives™ on Stack Overflow

Python\ csv.writer deletes previous data instead of adding new to the file

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related