Reshape the dataframe in python

Question

I have a Music dataset. Where two columns ('Music_id' and 'Tag_name' ) are there. Sample data:

Music_id       Tag_name
  1004         Base Guitar
  1004         Guitar
  2004         Base guitar
  1005         Keyboard
  1003         Keyboard
  1004         Keyboard

I want to reshape this dataframe where all tag_name should become the column name, so that every row should have unique Music_id.

I read about the concept of stratification and merging but not sure how to apply in this situation. Any help?

wwnde · Accepted Answer · 2020-05-14 22:06:27Z

2

Question not clear. Maybe give us what you expect output to be

I guess you need this?

pd.crosstab(df.Music_id, df.Tag_name, dropna=False)

answered May 14, 2020 at 22:06

wwnde

26.7k6 gold badges22 silver badges38 bronze badges

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

Collectives™ on Stack Overflow

Reshape the dataframe in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related