piRSquared piRSquared - 4 months ago 16
Python Question

locate the numeric position of a non numeric index value

Consider the series

s
below:

s = pd.Series(np.arange(18, 0, -3), list('ABCDEF'))
s

A 18
B 15
C 12
D 9
E 6
F 3
dtype: int32


I want to get the numeric position of
'D'


This will do it, but I think we can all agree this is gross:

s.reset_index().index.to_series()[s.reset_index().iloc[:, 0] == 'D'].iloc[0]

Answer

You can use Index.get_loc:

print(s.index.get_loc('D'))
3
Comments