create a new column with adding current values

Asked Feb 25 '18 at 08:39

Active Feb 25 '18 at 09:03

Viewed 22 times

i have a df as: production_unit_id|defective_item|defective_item_count|items_produced_count|items_discarded_count

P108|rock|46|1|315

P108|scissor|47|3|309

P108|rock|27|6|315

P085|scissor|50|8|194

P774|scissor|23|146|21

P774|scissor|5|146|21

i want the output as: production_unit_id|defective_item|defective_item_count|items_produced_count|items_discarded_count

P108|rock|73|7|630

P108|scissor|47|3|309

P085|scissor|50|8|194

P774|scissor|28|292|42

the 'defective_item' column should be grouped and 'defective_item_count' should be added corresponding to the same 'defective_item' .

Please help. Thanks in advance.

edited Feb 25 '18 at 09:03

asked Feb 25 '18 at 08:39

ashish rana

Please format properly. – Mad Physicist Feb 25 '18 at 08:41
Have you tried anything? Can you share your code? – John Zwinck Feb 25 '18 at 08:42
1

Also, SO is not a free coding site. What have *you* tried? – Mad Physicist Feb 25 '18 at 08:42
1

It is dupe `df = df.groupby(['production_unit_id','defective_item']).sum()` :( – jezrael Feb 25 '18 at 08:42
yeah i have tried i also tried to groupby on column but that does not give the desired ouput. Also i have just asked a part of my problem , not the full solution. I think SO is a platform to get help from around the world . @MadPhysicist – ashish rana Feb 25 '18 at 08:49

0 Answers0