Posts: 2
Threads: 1
Joined: Feb 2020
Data set screenshot
how can i find the number of movies per genre using the item data
movies that have more than one genre
drop the movie where genre is unknown
Posts: 6
Threads: 0
Joined: Jan 2020
- how can i find the number of movies per genre using the item data - Using .count() per movie dataframe column & you should be able to get number of movies per genre
- movies that have more than one genre - Total the columns of all genere's per movie & if count>1 then it that movie has more than 1 genre
- drop the movie where genre is unknown - select all movie's where df['unknown'] ==1
Posts: 2
Threads: 1
Joined: Feb 2020
Feb-19-2020, 02:36 PM
(This post was last modified: Feb-19-2020, 02:50 PM by sekhar_desiraju.)
hi satya,
thank you for your reply really appriciate, i dont have any programming background so struggling a bit on this
i have used
df=pd.DataFrame({'Genre':['unknown','Action','Adventure','Animation','Childrens','Comedy','Crime','Documentary','Drama','Fantasy','Film-Noir','Horror','Musical','Mystery','Romance','Sci-Fi','Thriller','War','Western']},
index=['movie title'])
df.set_index(["unknown","Action","Adventure","Animation","Childrens","Comedy","Crime","Documentary","Drama","Fantasy","Film-Noir","Horror","Musical","Mystery","Romance","Sci-Fi","Thriller","War","Western"]).count(level="movie title")
but its not working am doing any thing wrong
those columns of genre if they are as rows corresponding to movie name probably would have been easy one hot coding changed the rows to columns i dont know how to put that columns to rows again
Oh sorry .. my bad .. didnt know it was suppose to be done like that..
corrected
df=pd.DataFrame({'Genre': ['unknown','Action','Adventure','Animation','Childrens','Comedy','Crime','Documentary','Drama','Fantasy','Film-Noir','Horror','Musical','Mystery','Romance','Sci-Fi','Thriller','War','Western']},
index=['movie title'])
df.set_index(["unknown","Action","Adventure","Animation","Childrens","Comedy","Crime","Documentary","Drama","Fantasy","Film-Noir","Horror","Musical","Mystery","Romance","Sci-Fi","Thriller","War","Western"]).count(level="movie title")
Posts: 1
Threads: 0
Joined: Oct 2020
(Feb-19-2020, 02:36 PM)sekhar_desiraju Wrote: hi satya,
thank you for your reply really appriciate, i dont have any programming background so struggling a bit on this
i have used
df=pd.DataFrame({'Genre':['unknown','Action','Adventure','Animation','Childrens','Comedy','Crime','Documentary','Drama','Fantasy','Film-Noir','Horror','Musical','Mystery','Romance','Sci-Fi','Thriller','War','Western']},
index=['movie title'])
df.set_index(["unknown","Action","Adventure","Animation","Childrens","Comedy","Crime","Documentary","Drama","Fantasy","Film-Noir","Horror","Musical","Mystery","Romance","Sci-Fi","Thriller","War","Western"]).count(level="movie title")
but its not working am doing any thing wrong
those columns of genre if they are as rows corresponding to movie name probably would have been easy one hot coding changed the rows to columns i dont know how to put that columns to rows again
Oh sorry .. my bad .. didnt know it was suppose to be done like that..
corrected
df=pd.DataFrame({'Genre': ['unknown','Action','Adventure','Animation','Childrens','Comedy','Crime','Documentary','Drama','Fantasy','Film-Noir','Horror','Musical','Mystery','Romance','Sci-Fi','Thriller','War','Western']},
index=['movie title'])
df.set_index(["unknown","Action","Adventure","Animation","Childrens","Comedy","Crime","Documentary","Drama","Fantasy","Film-Noir","Horror","Musical","Mystery","Romance","Sci-Fi","Thriller","War","Western"]).count(level="movie title")
I tried to work with the lines of code to solve the same problem but it is not returning the right solution. Any reason why this is the case?
Posts: 1
Threads: 0
Joined: Nov 2020
Hi There,
Can you please share the code here as well for the question movies that have more than one Genre. My answer is coming zero. Not sure
Looking forward to hear from you!
Thanks!
SHivam
|