4 ms·
I misspoke, you need to use .groupby/.transform to add a new filtering column: (sales .assign(country_median=lambda df_: ( df_.groupby("cou
by __mharrison__ 21d ago
I misspoke, you need to use .groupby/.transform to add a new filtering column:
(sales
.assign(country_median=lambda df_: (
df_.groupby("country")["amount"].transform("median")
))
.query("amount <= country_median * 10")
.assign(net=pd.col('amount') - pd.col('discount'))
.groupby("country", as_index=False)
.agg(total=("net", "sum"))
)
- latent-person 21d agoYes, so basically equivalent to the code I showed in the blog.