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

what if i know the index and i want to print the age

---

Hey,

You can do like this:

dic = {'Name': ["Donna"], 'Age': [23]}
pd.DataFrame(data=dic)

---

if you know the index and you want to get the age then use

print(df.loc[index, 'age'])

---

what if we have to compare it with a user input variable

---

Hi, @Could you please clarify your query about what exactly you want to do?

---

Yes it worked for me!!!

---

Thank you, you were great help.

---

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']

---

find positions of a single value in a dataframe

---

It worked. Thanks

---

Thanks a lot, this helped me to.

---

Now in 2023 the index_values attribute  was changed to index attribute