Export csv with string at first row and header starting at second row

Question

I want to export dataframe with special request.
I want to add string at first row and start exporting dataframe from second row.

# dt
col1  col2
AAA     10
BBB     50

For example, the string I want to add at first row is FIRST.
The csv exported data should looks like:

FIRST
col1,col2
AAA,10
BBB,50

Is it possible to do so?

Serge Ballesta · Accepted Answer · 2021-09-16 14:37:16Z

1

Pandas can export a dataframe as csv to an already open file:

fd = open('file.csv', 'w')
print('FIRST', file=fd)
df.to_csv(fd, index=None)

answered Sep 16, 2021 at 14:37

Serge Ballesta

150k13 gold badges137 silver badges267 bronze badges

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

1 Answer 1