I have a csv file containing 720,000 rows with and 10 columns, the columns that are relevant to the problem are ['timestamp_utc', 'looted_by__name', 'item_id', 'quantity']
This File is logs of items people loot of the ground in a game , the problem is that sometimes the loot logger of the ground bugs and types in the person looting the same item twice in two different rows (those two rows could be separated by up to 5 rows) with a slight difference in the 'timestamp_utc' Column other wise ['looted_by__name', 'item_id', 'quantity'] are the same
and example of this would be: