Pandas weighted average groupby

sales.groupby("Manager").apply(lambda x: np.average(x['New_Product_Price'], weights=x['Quantity']))

Source: pbpython.com

Pandas weighted average groupby

(sales["Current_Price"] * sales["Quantity"]).sum() / sales["Quantity"].sum()
(sales["New_Product_Price"] * sales["Quantity"]).sum() / sales["Quantity"].sum()

Source: pbpython.com

Similar codes

2 votes389 views2 answers
Pandas divide one column by another
Python
0 vote335 views1 answer
Python - Drop row if two columns are NaN
Python
4 votes377 views2 answers
How to count non null values in pandas
Python
0 vote345 views1 answer
How to colour letters in python
Python
0 vote311 views2 answers
Df.replace not working
Python
4 votes367 views2 answers
Pandas most frequent value
Python
0 vote335 views1 answer
Nlp = spacy.load('en') error
Python
0 vote322 views1 answer
Align a text python
Python
69 votes338 views6 answers
Python online compiler 3.8
Python
25 votes343 views6 answers
Python online compiler
Python