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 votes183 views1 answer
Python recursive function return none
Python
5 votes192 views3 answers
How to extract zip file using python
Python
12 votes183 views6 answers
How to make a list python
Python
1 vote177 views1 answer
How do i print when my bot is ready in discord.py
Python
0 vote187 views1 answer
How to play and stop music python
Python
0 vote157 views1 answer
Python get city name from IP
Python
0 vote181 views1 answer
Codes for infrntial statistics in python
Python
0 vote163 views1 answer
The process of delivery of any desisered data
Python
5 votes176 views3 answers
Get input from user in python
Python
0 vote183 views1 answer
How to set geometry to full screen in pyqt5
Python