Oct-28-2020, 12:00 AM
(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?