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

1 vote229 views1 answer
Liste in python
Python
1 vote231 views1 answer
Can you print to multiple output files python
Python
6 votes196 views2 answers
Numpy random int
Python
0 vote201 views1 answer
Read a file and split the words python
Python
1 vote208 views1 answer
Change text color docx-python
Python
0 vote233 views1 answer
Python requests pass auth token
Python
2 votes218 views1 answer
Python subprocess with environment variables
Python
0 vote223 views1 answer
Python next item in list
Python
20 votes202 views5 answers
Python to json
Python
0 vote195 views1 answer
Perceptron multicouche scratch python
Python