Consider a dataframe like
| product | date | value | city | reference |
|---|---|---|---|---|
| y | 21-01-2020 | -16 | Paris | xji |
| x | 25-01-2020 | -16 | Munich | zyc |
| x | 01-05-2020 | 16 | Munich | dkj |
| y | 20-01-2020 | -20 | Paris | jkdl |
| z | 21-01-2020 | 30 | Munich | 212jio |
| t | 05-01-2020 | 2 | Munich | jidi1 |
| y | 21-03-2020 | 20 | Paris | reg1 |
I would like to delete rows that value cancel each other, having something like
| product | date | value | city | reference |
|---|---|---|---|---|
| y | 21-01-2020 | -16 | Paris | xji |
| z | 21-01-2020 | 30 | Munich | 212jio |
| t | 05-01-2020 | 2 | Munich | jidi1 |