groupby method with filter functions and conditions-CodePudding

This the data set

f = pd.DataFrame({'Movie': ['name1','name2','name3','name4'],
                  'genre': ['sci-fci', 'action','comedy','action'],
                  'distributor': ['disney', 'disney','parmount','disney'],})

This is what , I did this but got an error

res=f.groupby(['Genre']).filter(["Distributor"]=='Walt Disney Studios Motion Pictures')

I want to group by genre and only have movies launched by disney eg want an output like a table of disney has 1 sci-fic 2 action

CodePudding user response：

This finds the rows with distributer equal to disney and groups the dataframe by genre

f = f[f['distributor'] == 'disney']
res = f.groupby(['genre'])

One line code could be

res = f[f['distributor'] == 'disney'].groupby(['genre'])

CodePudding user response：

f[f['distributor'] == 'disney'].groupby(['genre']).count()