how to sum values of column based on other column values in pandas

Asked Jun 04 '18 at 14:49

Active Jun 04 '18 at 14:53

Viewed 37 times

I have a dataframe like this :

ID  State  Qty
1   'UP'    2
1   'UP'    3
1   'AR'    1
2   'KJ'    3
4   'AP'    1
2   'KJ'    4

Here is what i need :

I want to sum the Qty values of multiple rows if both the values of ID and State columns are same for those rows and put them in a single row with the Qty value as sum .

So what I need is this :

ID  State  Qty
1   'UP'    5
1   'AR'    1
2   'KJ'    7
4   'AP'    1

How to do this efficiently ?

asked Jun 04 '18 at 14:49

Natesh bhat

12,274
10
84
125

2

You use a groupby and sum. Just google it. – Anton vBR Jun 04 '18 at 14:51
1

Or this: https://stackoverflow.com/questions/39922986 – Anton vBR Jun 04 '18 at 14:52
should i delete this question if its a duplicate ? – Natesh bhat Jun 04 '18 at 15:08
You can just leave it! – Anton vBR Jun 04 '18 at 15:12
if it doesn't cause me downvotes i guess its ok to leave – Natesh bhat Jun 04 '18 at 15:22

how to sum values of column based on other column values in pandas

0 Answers0