append entries in csv in a for loop by using dataframe.to_csv

Question

I am using the below code in a for loop, the problem is whenever a new loop starts, a new csv is formed that means deleting the previous entries. I want that the entries get appended. I can do it using csv write but would be nice to know using pandas.

prediction.to_csv("tmp.csv" , sep='\t', encoding='utf-8', doublequote=False, index=False)

Patrick Artner · Accepted Answer · 2018-03-10 21:59:32Z

2

As with most file operations you can tell them which way you want to open the file with:

Doku: to_csv

Just use the append mode:

prediction.to_csv("tmp.csv" , sep='\t', encoding='utf-8', \
    doublequote=False, index=False, mode="a")

You might also want to include a

useHeader = True

before your loop and modify your command to:

prediction.to_csv("tmp.csv" , sep='\t', encoding='utf-8', \
    doublequote=False, index=False, mode="a", header = useHeader)
useHeader = False

so you only get one header on top of the file.

answered Mar 10, 2018 at 21:59

Patrick Artner

51.9k10 gold badges50 silver badges79 bronze badges

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

1 Comment

user9471916 Over a year ago

Thanks a lot for the help. :)

Collectives™ on Stack Overflow

append entries in csv in a for loop by using dataframe.to_csv

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