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
Numpy array with 2 times each value
Python
40 votes144 views1 answer
Convert string to list python
Python
0 vote127 views1 answer
Convert float with missing values to integer
Python
0 vote149 views1 answer
Unit converter idle python
Python
0 vote143 views1 answer
Required depend filed odoo
Python
1 vote133 views1 answer
Python how to use a variable to trigger an event
Python
0 vote136 views1 answer
Python one line key increment or add
Python
0 vote136 views1 answer
Max sum slice python 5 - autopilot
Python
0 vote146 views1 answer
Raise TypeError('expected ' + str(self.expected_type)) TypeError: expected <class 'openpyxl.styles.colors.Color'>
Python
3 votes151 views1 answer
Draw a single pixel using pygame
Python