Reset column index of pandas dataframe

Question

Is it possible to reset columns so they becomes first row of DataFrame. For example,

import pandas as pd

df = pd.DataFrame({'a': [1, 2, 3], 'b': [4, 5, 6]})
   a  b
0  1  4
1  2  5
2  3  6

Desired ouput,

df2 = df.reset_column() ???
   0  1
0  a  b
1  1  4
2  2  5
3  3  6

Does this answer your question? Reset column index in Pandas to 0,1,2,3...? — satk0
– satk0, Commented Dec 28, 2022 at 18:54

rafaelc · Accepted Answer · 2018-09-08 18:10:57Z

8

Can also chain reset.index

df.T.reset_index().T.reset_index(drop=True)

    0   1
0   a   b
1   1   4
2   2   5
3   3   6

answered Sep 8, 2018 at 18:10

rafaelc

59.4k15 gold badges64 silver badges87 bronze badges

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

1 Comment

Nikhil VJ Over a year ago

I didn't want to preserve the column headers, so did: df.reset_index(drop=True).T.reset_index(drop=True).T

Zero · Accepted Answer · 2018-09-08 18:07:06Z

7

Use

In [57]: pd.DataFrame(np.vstack([df.columns, df]))
Out[57]:
   0  1
0  a  b
1  1  4
2  2  5
3  3  6

answered Sep 8, 2018 at 18:07

Zero

77.4k22 gold badges153 silver badges153 bronze badges

Comments

score 1 · Accepted Answer · 2018-09-08 18:42:30Z

1

Inserting column names at the first row and resetting the indices.

import pandas as pd

df = pd.DataFrame({'a': [1, 2, 3], 'b': [4, 5, 6]})

df.loc[-1] = df.columns
df.index = df.index + 1
df = df.sort_index()
df.columns = [0,1]
df

    0   1
0   a   b
1   1   4
2   2   5
3   3   6

edited Sep 8, 2018 at 18:42

answered Sep 8, 2018 at 18:09

user8864088

2 Comments

taras Over a year ago

It does overwrite the first row ([1, 4]) with column names.

user8864088 Over a year ago

@taras fixed, look at the updated answer. Thanks for info.

Collectives™ on Stack Overflow

Reset column index of pandas dataframe

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related