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

5 votes133 views2 answers
Check if something is nan python
Python
14 votes103 views2 answers
Tkinter clear canvas
Python
0 vote151 views1 answer
Filter outside queryset in list django
Python
6 votes176 views1 answer
Print url selenium python
Python
0 vote135 views1 answer
Access field values of form django
Python
0 vote181 views1 answer
How to round an array in python
Python
2 votes148 views1 answer
How to update pandas
Python
5 votes145 views2 answers
Selenium driver wait python
Python
0 vote142 views1 answer
Pytest suppress errors
Python
-1 vote149 views1 answer
Binascii.Error: Incorrect padding in python django
Python