Deleting multiple entries in betting-odds Data
Hey,
I currently have about 60 .csv files with soccer odds data that I need to "clean". Please see my raw data in the attached file.
What I want to do is to delete all entries that have "IP" in column P. This isnt to hard, and Ive been able to write a code to do so. The next step is more tricky though. My data includes all matched bets on a certain football match. I need to slim this down to one single price. This means that for each "SELECTION" in column I, I either want to delete all multiple entries except the one with the highest value in column L. Or I want to merge all the entries to one row which is a weighted average of the odds at different volumes.
The last approach is the most tricky one, so I would be happy with the first approach, i.e. deleting all multiple entries except the largest one.
Would anyone be able to assist me with writing this code? Ideally it would first delete all entries that has "IP", then delete all multiple entries in column I except the one with the largest value for column L.
I have no idea how to write this code
Reply With Quote