python - Using pandas apply to pass in both a row and the entire dataframe with it

Question

This question already has an answer here: question from:https://stackoverflow.com/questions/65599920/using-pandas-apply-to-pass-in-both-a-row-and-the-entire-dataframe-with-it

Answer 1

First, group by Family and then transform amount and then you can directly divide Amount by the new column.

df['Total_Fam'] = df.groupby('Family')['Amount'].transform(np.sum)
df['Id_Percent'] = df['Amount']/df['Total_Fam']
df