Using findfirst with for multiple values and columns in a Dataframe?

Since it seems a bit related, take a look here Fastest way to fetch an index where we designed alternatives to searchsortedlast it might give you more ideas

1 Like