How to find index of element in dataframe Python

Question

Hi. I have a pandas dataframe and I want to find the index of a particular entry in it.

  Name Age
0 Mike 23
1 Eric 25
2 Donna 23
3 Will 23

This is the dataframe. I want to find the index of ‘Donna’. How can I do it?

Answer 1

First, use the dataframe to match the value, and then find the index. Try this:

print(df[df[‘Name’]==’Donna’].index.values)

Comments

Thanks Esha, that worked beautifully for me to get the values from a particular cell.

a = df.at[df[df['instrumentToken'] == 53469].index.values[0],'lotSize']