How to write to CSV using csv package in python line by line

Question

I want to write data to a csv file row by row :

Please find the code below:

with open('a.csv',mode='w') as csv_file:
    fieldnames=['colA','colB','colC']
    writer=csv.DictWriter(csv_file,fieldnames=fieldnames)
    writer.write_row({'colA':data1,'colB':data2,'colC':data3})

The above code is inside a loop in which the data changes each time and i need to write to csv file in every loop. With this code my csv file is having only 1 line with the latest data. How do i modify the code to get multiple lines?

Ouroborus · Accepted Answer · 2019-08-16 06:33:32Z

1

You're recreating the file and reinitializing the csv on each iteration. Instead, move the initialization outside the loop so that it only happens once.

with open('a.csv',mode='w') as csv_file:
    fieldnames=['colA','colB','colC']
    writer=csv.DictWriter(csv_file,fieldnames=fieldnames)
    for line in lines: # This is where your `for` loop should be relative to `with`
        writer.write_row({'colA':data1,'colB':data2,'colC':data3})

answered Aug 16, 2019 at 6:33

Ouroborus

17k8 gold badges42 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

How to write to CSV using csv package in python line by line

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