How to make column header and row header same in a pandas dataframe

Question

I currently have a dataframe that looks like this:

       A       B       C
0   0.6875  0.1923  0.2300
1   0.3887  0.1923  0.5300
2   0.6061  0.2576  0.2474

I'm looking for a way to and make the first column the same as the header row, so the new dataframe would look like this:

       A       B       C
A   0.6875  0.1923  0.2300
B   0.3887  0.1923  0.5300
C   0.6061  0.2576  0.2474

Can anyone please help me regarding this?

df.index = df.columns.. ?

Henry Yik
– Henry Yik

2020-09-08 14:04:28 +00:00
Commented Sep 8, 2020 at 14:04 — Henry Yik
– Henry Yik, Commented Sep 8, 2020 at 14:04

NYC Coder · Accepted Answer · 2020-09-08 14:06:41Z

2

This should do it:

df.set_index(df.columns, inplace=True)
print(df)

        A       B       C
A  0.6875  0.1923  0.2300
B  0.3887  0.1923  0.5300
C  0.6061  0.2576  0.2474

answered Sep 8, 2020 at 14:06

NYC Coder

7,6443 gold badges14 silver badges25 bronze badges

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

2 Comments

Pratik Dutta Over a year ago

Thanks @NYC Coder

NYC Coder Over a year ago

You can mark this as the answer if it worked for you.

Collectives™ on Stack Overflow

How to make column header and row header same in a pandas dataframe

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related