i have dataframe, i performed Sum aggregation on revenu column like that:
here is the output
df_1=df_exploded[['release_year','pc_exploded','original_title','revenue']].groupby(['release_year','pc_exploded']).agg({'revenue':['sum'],})
my problem is I'm trying to extract max sum value within each group to be something like: 1960 Alpha Production 32000000 1962 Norma Production 0
i tried differnt methods nothing worked. can you please suggest any solution? Thanks
