Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Get index when looping through one column of pandas

Tags:

python

pandas

I have a simple dataframe:

index, a, y 0 , 1, 2 1 , 4, 6 2 , 5, 8

I want to loop through the "a" column, and print out its index for a specific value.

for x in df.a:
    if x == 4:
        print ("Index of that row")

What syntax should I use to obtain the index value when the for loop hits the specific value in the "a" column that I am seeking?

Thank You

like image 792
Jeff Saltfist Avatar asked Dec 07 '22 20:12

Jeff Saltfist


1 Answers

A series is like a dictionary, so you can use the .iteritems method:

for idx, x in df['a'].iteritems():
    if x==4:
        print('Index of that row: {}'.format(idx))
like image 126
ayhan Avatar answered Jan 05 '23 00:01

ayhan