Generate new dataframe with values in old dataframe as new features in python

Question

I have a old data frame like:

Name  Courses      Attendence   Day
Mike    Math           1        Monday
Mike    Math           1        Tuesday
Mike    Physcis        2        Monday
Mike    Chemisty       1        Monday
John    Math           2        Tuesday
John    Physics        1        Tuesday
John    Physics        1        Tursday

And want to create a new dataframe:

Name  Math  Physics  Chemisry
Mike  2        2       1
John  2        2       0

Is there any efficient way to do it?

Thanks!

Kartik · Accepted Answer · 2015-11-05 20:25:05Z

1

Use pd.pivot_table()

pivoted = pd.pivot_table(data=df, columns='Courses', index='Name',
                         aggfunc='sum', fill_value=0)

Let me know if you run into problems.

answered Nov 5, 2015 at 20:25

Kartik

8,73345 silver badges78 bronze badges

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

3 Comments

Robin1988 Over a year ago

Thanks for your help!!

Kartik Over a year ago

If it works, can you mark the answer? The check mark beside the question on the left side. Also, take your time to go through the SO guide and help. Welcome to SO!

Pierre L Over a year ago

The R equivalent reshape2::dcast(df, Name ~ Courses, value.var='Attendence', sum)

Collectives™ on Stack Overflow

Generate new dataframe with values in old dataframe as new features in python

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related