How to append multiple rows to csv file using python

Question

Im trying to append user inputted data to rows , however im having no luck.

Counter is a user defined global variable which i have created elsewhere in the code.

when the data is appended, instead of moving to another line it just rewrites the same line over and over and as a new user of python i have no idea what im doing wrong.

def AppendCsv(): 
    NumberOfNamesToBeAdded()
    with open ('Graph.csv', 'a') as graphFile:
        graphFileWriter=csv.writer(graphFile)
        for x in counter:
             graphFileWriter.writerow([ID, Name,Cost,Date1])

What is ID, Name, Cost and Date1? Do they change on these loops? — Marco
– Marco, Commented Dec 1, 2017 at 21:07
When you say it rewrites the same line over and over, do you mean it overwrites the same line and you end up only appending a single new row to the CSV? Or do you mean that the same row is appended multiple times? — rp372
– rp372, Commented Dec 1, 2017 at 21:11
I mean that the same row is overwritten, so only 1 row ends up being appended — bobdaves69
– bobdaves69, Commented Dec 2, 2017 at 9:38

Bill Bell · Accepted Answer · 2017-12-01 21:54:14Z

1

It depends what's in counter, for one thing. With a range in counter, like this:

import csv

counter = range(3)

with open('Graph.csv', 'a', newline='') as graphFile:
    graphFileWriter = csv.writer(graphFile)
    for x in counter:
        graphFileWriter.writerow([1,2,3])

the result is this:

1,2,3
1,2,3
1,2,3

You might also want to insert , newline='' in the open statement.

answered Dec 1, 2017 at 21:54

Bill Bell

21.7k6 gold badges48 silver badges62 bronze badges

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

2 Comments

bobdaves69 Over a year ago

counter is a string , so if i just change it to counter=range(input('enter the number')) this should work?

Bill Bell Over a year ago

I expect so, yes.

Collectives™ on Stack Overflow

How to append multiple rows to csv file using python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related