I have following table in as df.
Price Stop Max Min
15 15
5
35
85
67 67
75
54
17
75 75
52
75
75 75
53
15 15
58
71
95
45
77 77
65
25
48
15 15
45
in the max column against the value of Stop i want to have max value of Price for a range till next stop figure & same for min value in Min Col.
E.g. against 15 I would need Max & Min from 15 to 67 range. i.e. 85 as max & 5 as min value in respective col.
I can get Min & Max for entire col but not for continuous changing ranges.