Index find position for matching string

Question

Consider following example

index_abcd = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i'] data = ['1', '2', '3', '4', '5', '6', '7', '8', '9'] df = pd.DataFrame(data, index=index_abcd) index_id= df.index

I want to find the position of 'a' in the index "index_id". How do I do that. Trying

index_id.index('a')

does not work (error 'Index' object has no attribute 'index'). Thanks a lot

You could try enumerate(), like [i for i, x in enumerate(index_id) if x == 'a']. But this approach doesn't seem to be optimal if the list gets too big — Chris
– Chris, Commented Dec 8, 2017 at 9:12
you use a class Index, it's no longer a string, there is no index attribute. You should have a look to the class to see if there is another attribute you could use. maybe 'data'. You may try index_id.data.index('a') as data is a 1 dimension array — A.Joly
– A.Joly, Commented Dec 8, 2017 at 9:13

Fou · Accepted Answer · 2017-12-08 09:26:32Z

1

I suggest you to type :

index_id.get_loc("a")

answered Dec 8, 2017 at 9:26

Fou

1611 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Rockbar Over a year ago

Same here: Thanks, works. Unfortunately I can only give one check for good answer. (above)

Fou Over a year ago

Mine is one line code :), I'm kidding, most important is that you get the answer you want !

Bhanuchander Udhayakumar · Accepted Answer · 2017-12-08 09:20:26Z

1

Try this:

index = pd.Index(list(df)) print index.get_loc('a')

answered Dec 8, 2017 at 9:20

Bhanuchander Udhayakumar

1,6761 gold badge17 silver badges31 bronze badges

Comments

U13-Forward · Accepted Answer · 2017-12-08 09:33:59Z

If I understand you correctly, this may be what you want:

print(df.ix['a'].index.tolist())

Output:

[0]

Collectives™ on Stack Overflow

Index find position for matching string

3 Answers 3

2 Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Related