Transpose Pandas dataframe and change column header

Question

this question is a duplicate, in a sense I want exactly this.

So, basically I have following df:

Time | A | B|

1    |10 | 20|
2    |15 | 25|

I want:

Name | 1 | 2|

A    |10 | 15|
B    |20 | 25|

So, first I tried the accepted solution from the question: df = df.set_index('Time').T.rename_axis('Name').rename_axis(None, 1), but it gives me rename_axis() takes from 1 to 2 positional arguments but 3 were given. If I try only df.set_index('Time').T.rename_axis('Name'), the df becomes:

Time | 1 | 2|

Name
A    |10 | 15|
B    |20 | 25|

Even so if I print the name of first column with df.columns[0], I get 1 and neither Time nor Name. I want the first column to be Name.

How can I transpose my df in such a way? Hopefully,the question is clear!

Thanks

jezrael · Accepted Answer · 2019-11-13 13:51:02Z

2

You have to specify axis=1 instead 1 (I think function in last version was changed) and add DataFrame.reset_index for convert index to column:

df = df.set_index('Time').T.rename_axis('Name').rename_axis(None, axis=1).reset_index()
print (df)
  Name   1   2
0    A  10  15
1    B  20  25

Or in last pandas version use parameters index and columns:

df = df.set_index('Time').T.rename_axis(index='Name', columns=None).reset_index()

edited Nov 13, 2019 at 13:51

answered Nov 13, 2019 at 13:49

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

2 Comments

BlueMango Over a year ago

Hey, yes it works but it still says the name of the first column is 1. I want to be able to do df['Name’] of a sort.

jezrael Over a year ago

@BlueMango - Added to solution.

Collectives™ on Stack Overflow

Transpose Pandas dataframe and change column header

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related