How to add an empty row on top of the header row in a dataframe?

Question

Problem:

Let there be a dataframe with multiple columns,

A  |  B  |  C  | ....
2  |  b  |  c  |
3  |  c  |  b  |
.
.
.

where A, B and C are the headers

Output:

   |     |     |....
A  |  B  |  C  | 
2  |  b  |  c  |
3  |  c  |  b  |
.
.
.

Is there an efficient way to add an empty row over the header row in the dataframe?

I have found a way to add an empty row right after the header row but I am able to find a way to add an empty row over the header row. Any help would be appreciated.

eventually I want to add excel formulas via xlsxwriter in those empty rows — royalewithcheese, Sep 17 '20 at 04:53
i don't need to access the columns because i don't need to make any changes to the dataframe after inserting an empty row.. — royalewithcheese, Sep 17 '20 at 04:56
Can't you write in a row of excel formulas with xlsxwriter, then just append your data to that sheet once you've written those formulas in? — Cameron Riddell, Sep 17 '20 at 04:58

score 0 · Answer 1 · answered Sep 17 '20 at 07:11

0

Did you try after adding - sorting?:

df = df.sort_values(by='B')

answered Sep 17 '20 at 07:11

gtomer

5,643
1
10
21

How to add an empty row on top of the header row in a dataframe?

1 Answers1

Linked