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

20 votes254 views2 answers
How to print all rows in pandas
Python
5 votes247 views3 answers
How to generate list in python
Python
0 vote262 views1 answer
How to pick everything after a character in python
Python
4 votes240 views1 answer
How to read a file into array in python
Python
21 votes260 views6 answers
Set to List
Python
1 vote257 views1 answer
Discord.py on command error
Python
0 vote267 views1 answer
Sort folders content by name python
Python
71 votes267 views4 answers
Saving a pandas dataframe as a csv
Python
2 votes257 views1 answer
Change false to true python
Python
1 vote247 views1 answer
Python multiplication array
Python