Quickest way to find lowest value in dataframe from current row column value
For each row in the dataframe below, want to populate minlow and lowdate. minlow should find the lowest ‘low’ column in the future and then set minlow and lowdate. I have plenty of code examples using .loc/.iloc but these are slow as the dataframe is over 4Million records. Trying to find the most performant method.