How to transform column values into row header using Python?

Question

I need to transform the column values to header in python.

    testdf = {'Student_id':['10001','10001','10001','20001','20001','30001','30001','30001'],
          'Subject':['S1','S2','S3','S1','S2','S1','S2','S3'],
          'Mark':['80','60','70','50','70','90','80','40']
         }
testdf = pd.DataFrame(data=testdf)
testdf

I want to have a table like

When I tried below code

testdf.pivot(index="Student_id",columns="Subject")

I am getting like below:

jezrael · Accepted Answer · 2019-03-12 09:48:13Z

3

Add parameter values to DataFrame.pivot and if necessary data cleaning - DataFrame.rename_axis for remove columns name and DataFrame.reset_index for column from index:

df = (testdf.pivot(index="Student_id",columns="Subject", values='Mark')
            .rename_axis(None, axis=1)
            .reset_index())
print (df)
  Student_id  S1  S2   S3
0      10001  80  60   70
1      20001  50  70  NaN
2      30001  90  80   40

answered Mar 12, 2019 at 9:48

jezrael

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

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

1 Comment

Dev Ananth Over a year ago

Excellent. This is what I am exactly looking for.

Collectives™ on Stack Overflow

How to transform column values into row header using Python?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related