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

3 votes336 views1 answer
Hwo much does mano house cost in python
Python
5 votes313 views4 answers
Prime numbers from 1 to 100 in python
Python
0 vote346 views1 answer
Displace items in array python
Python
2 votes279 views1 answer
Close chrome selenium python
Python
0 vote331 views1 answer
How to set text in QComboBox pyqt5
Python
4 votes300 views1 answer
How to add condition if null value in django orm
Python
0 vote351 views1 answer
Negative number factor python
Python
71 votes285 views10 answers
Sus sus sus
Python
0 vote331 views1 answer
Sqlite3 python parameterized query insert into
Python
0 vote335 views1 answer
Odoo - add one2many field programmatically
Python