How To Perform A Groupby And Transform Count With A Condition In Pandas

I have the following dataframe: # Import pandas library import pandas as pd import numpy as np # data data = [['tom', 10,2,'c',100,'x'], ['tom',16 ,3,'a',100,'x'], ['tom', 22,2,'

Solution 1:

We should do

df['scoregreaterthan1'] = df['Score'].gt(1).groupby(df['Rating']).transform('sum')