intent: How to subset a data frame using Pandas based on a group criteria?
rewritten_intent: Get data of dataframe `df` where the sum of column 'X' grouped by column 'User' is equal to 0
snippet: df.loc[df.groupby('User')['X'].transform(sum) == 0]