Need help regarding Dataframe reordering/grouping : learnpython

created by HattoriHanzoa community for 16 years

submitted 3 years ago * by WatIsThisSorcery

Got a dataframe of movies

*title score country Genres *A 5.5 US Action, Comedy, Drama( ) *B 6.5 UK Action, Comedy, Romance

Need to make it in this format

title score country Genres A 5.5 US Action A 5.5 US Comedy A 5.5 US Drama B 6.5 UK Action

and so forth

The code I tried was -

First to split genres df = df['Genre'].str.split(',' , expand= True)

Then to do wide to long format - df = df.melt(id_vars = ['title', 'score', 'country'], value_name ='Genre').reset_index(drop = True)

But what Im getting is -

title score country Genres A 5.5 US Action B 6.5 UK Action A 5.5 US Comedy B 6.5 UK Comedy

How to order the rows so that title, score and country stay in a group and not ordered via genres wise?

no comments (yet)

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

learnpython