Finding Index position in DataFrame based on label

Question

I have a python Data Frame how can I Find the Index number of any Label.

df.loc['Brazil']

I have the Label but I want to know the index number so I can use the df.iloc[] method.

mozway · Accepted Answer · 2021-08-14 08:32:36Z

Assuming this input:

df = pd.DataFrame({'col': None}, index=['Argentina', 'Brazil', 'Columbia'])

 col Argentina None Brazil None Columbia None

You can use get_loc: df.index.get_loc('Brazil') -> outputs 1

However, this assumes a non duplicated index. If you have:

 col Argentina None Brazil None Columbia None Brazil None

This will output: array([False, True, False, True]).

In this case, you can use the nonzero method of the output numpy array:

>>> df.index.get_loc('Brazil').nonzero()[0] array([1, 3])

Nishad Wadwekar · Accepted Answer · 2021-08-14 08:17:09Z

0

Assuming you meant label as columns, you can do

index = df.columns.get_loc('Brazil')

answered Aug 14, 2021 at 8:17

981 silver badge9 bronze badges

Comments

gtomer · Accepted Answer · 2021-08-14 08:20:30Z

You did not post your dataframe but suppose the column in which you are searching is 'country', then:

df.index[df['country'] == 'Brazil'].to_list()

Will give you back the index of the at which the country is Brazil