How to append to csv file without creating multiple copies of headers into rows?

Question

I am trying to write Dataframe to csv :

for i in range 10:
    consolidated_df.to_csv(output_file_path + '/' +   dest_csv,mode='a',index=False)

This is creating adding headers as new rows for every iteration

col1 col2 col3
a     b     c
col1 col2  col3
d    e      f
col  col2   col3
g    h      i

if i use header=none in df.to_csv , then the csv doesnt have any headers at all

all i need is this

col1 col2 col3
a     b     c
d    e      f
g    h      i

Rakesh · Accepted Answer · 2020-08-12 14:34:03Z

1

One approach is to check if index is 0 then add header else set header to None

Ex:

for i in range(10):
    if i == 0:
        consolidated_df.to_csv(output_file_path + '/' +  dest_csv,mode='a',index=False)
    else:
        consolidated_df.to_csv(output_file_path + '/' +  dest_csv,mode='a',index=False, header=None)

answered Aug 12, 2020 at 14:34

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

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

Collectives™ on Stack Overflow

How to append to csv file without creating multiple copies of headers into rows?

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