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

0 vote197 views1 answer
Print numpy version
Python
3 votes194 views1 answer
Input array of string in python
Python
8 votes185 views3 answers
Python gzip file
Python
1 vote243 views1 answer
Image delete in django from the folder
Python Django
0 vote228 views1 answer
Split list in 3 part
Python
1 vote199 views1 answer
Seaborn jointplot regression
Python
0 vote189 views1 answer
Import NoSuchKey in boto3
Python
3 votes192 views1 answer
Matplotlib y axis log scale
Python
2 votes203 views1 answer
Graph implementation in python
Python
0 vote244 views1 answer
Create fixtures django
Python