Add new column in a csv within a loop with python

Question

I write data from a loop to a csv-file.

Expected outcome: Every iteration should write data in a new column.

Actually, it overwrites the data of the last iteration. How could I add a new column for every iteration?

def keywordsToCsv(filename, single_phrases):

    path = 'keywords/keywords.csv'

    with open(path, 'w', encoding='utf-8') as csvfile:
        filewriter = csv.writer(csvfile, delimiter=',', quotechar='|', quoting=csv.QUOTE_MINIMAL)
        filewriter.writerow([filename])
        for phrase in single_phrases:
            filewriter.writerow([phrase])

blhsing · Accepted Answer · 2019-03-10 16:05:10Z

2

There's no need to write a new column to the CSV file for each iteration. Instead, you can delay writing the columns and keep appending the output columns to a list until the loop finishes, at which point you can write all the columns as one row together.

answered Mar 10, 2019 at 16:05

blhsing

109k9 gold badges88 silver badges132 bronze badges

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

Collectives™ on Stack Overflow

Add new column in a csv within a loop with python

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