Excel column manipulation

Question

I am trying to find cell named North and take everything below it I know that we can easily locate this using loc and iloc, but in my case it may vary every time my app opens new excel file. I tried using str.contains

Answer 1

Try with iloc and idxmax:

df.iloc[df.eq('North').any(1).idxmax():]