Format a dataframe using Python pandas

Question

I have a pandas dataframe that has a format like this

Date       Grade    Student
1/1/2015    0.15    Brian
1/1/2015    0.05    Steve
1/1/2015    0.02    Connor
1/2/2015    0.14    Brian
1/2/2015    0.05    Steve

.....

Is it possible to reformat the dataframe in such a way in that it now looks like this?

Date      Brian   Steve   Connor
1/1/2015   0.15    0.05    0.02
1/2/2015   0.14    0.05     -

I am quite familiar with Pandas and aggregating columns together but am unsure how to go about compressing them in this particular way, any help woiuld be great.

Fabio Lamanna · Accepted Answer · 2016-02-18 16:42:11Z

1

You can use pivot_table:

a = df.pivot_table(index='Date', columns='Student', values='Grade')

This returns:

Out[5]: 
Student   Brian  Connor  Steve
Date                          
1/1/2015   0.15    0.02   0.05
1/2/2015   0.14     NaN   0.05

answered Feb 18, 2016 at 16:42

Fabio Lamanna

21.7k24 gold badges95 silver badges126 bronze badges

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

1 Comment

GreenGodot Over a year ago

lol, I was just about to answer this myself as I had found a perfect example on my ext Google search. You are absolutely correct though. Many thanks.

Alexander · Accepted Answer · 2016-02-18 16:57:56Z

1

In this simple case you can just use pivot.

>>> df.pivot('Date', 'Student', 'Grade')
Student   Brian  Connor  Steve
Date                          
1/1/2015   0.15    0.02   0.05
1/2/2015   0.14     NaN   0.05

answered Feb 18, 2016 at 16:57

Alexander

111k32 gold badges212 silver badges208 bronze badges

Collectives™ on Stack Overflow

Format a dataframe using Python pandas

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related