this is my dataframe, now in this some words example, "dispute" is coming twice (it can appear any number of times) , in such situation, i want to keep row with highest abolute value as it is, and lowest one will be 0.00
i.e for one dispute, the score is 0.090 and another dispute word has value -0.124 ,m then keep row with -0.124 as it is, and for other dispute word, 0.090 will change to 0.00
- word can come any number of times. How to achieve this in pandas/ PLease provide solution.
I am not that good with pandas, I am not sure how should I achieve that.