Getting the integer index of a Pandas DataFrame row fulfilling a condition?

Use Index.get_loc instead.

Reusing @unutbu’s set up code, you’ll achieve the same results.

>>> import pandas as pd
>>> import numpy as np


>>> df = pd.DataFrame(np.arange(1,7).reshape(2,3),
                  columns = list('abc'),
                  index=pd.Series([2,5], name="b"))
>>> df
   a  b  c
b
2  1  2  3
5  4  5  6
>>> df.index.get_loc(5)
1