The most efficient way to get integer key index in pandas

Question

How can I get the integer key location for the pandas index as quickly as possible?

for example, given pd.DataFrame(data=np.asarray([[1,2,3],[4,5,6],[7,8,9]]), index=['alice', 'bob', 'charlie'])

what is the fastest way to go from "bob" to 1

Answer 1

Use get_loc , this was done for this purpose!

 df.index.get_loc('bob') 

Answer 2

Not sure if this is the fastest, but you can use index.get_loc :

 df = pd.DataFrame(data=np.asarray([[1,2,3],[4,5,6],[7,8,9]]), index=['alice', 'bob', 'charlie']) print(df.index.get_loc("bob")) 1