How to find the index of a particular value in a dataframe

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!!!