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 vote127 views1 answer
Free online converter of c ++ code to Python
Python
2 votes151 views2 answers
Python exception element not found
Python
3 votes142 views5 answers
Remove unnamed 0 column pandas
Python
2 votes133 views8 answers
No
Python
0 vote135 views1 answer
A GDAL API version must be specified. Provide a path to gdal-config using a GDAL_CONFIG environment variable or use a GDAL_VERSION environment variable.
Python
0 vote123 views2 answers
Read excel spark
Python
1 vote214 views1 answer
Add help text in Django model forms
Python Django
0 vote113 views1 answer
Stellargraph python
Python
1 vote122 views1 answer
Print specific part in bold or colours and end.
Python
0 vote144 views1 answer
Error 302 heroku django
Python Django