Using Python, Get Partial Sum of DF column based on a condition from another sorted column

Question

I need to find out total invoice value for each supplier and create a new dataframe with unique supplier names as follows.

Please post the data in a minimally reproducible example. https://stackoverflow.com/help/minimal-reproducible-example. Also, show the code you have tried. — Paul Brennan, Dec 22 '20 at 15:19

score 0 · Answer 1 · answered Dec 22 '20 at 15:29

0

Try this:

sum_by_supplier = (df.groupby('Supplier Name')['Invoice Value'].sum()).reset_index()

answered Dec 22 '20 at 15:29

sophocles

1 Answers1