pandas series get index from location

Asked Apr 15 '20 at 12:29

Active Apr 15 '20 at 13:11

Viewed 29 times

I have a pandas.Series object s.

s.iloc[5:9] returns the following content:

>>> s.iloc[5:9]
date
2019-01-09    49.6
2019-01-10    79.3
2019-01-11    89.4
2019-01-14    61.7
Name: price, dtype: float64

Is it possible to get the index '2019-01-09' using s and its corresponding position 5?

I mean I want a function like this:

>>> get_index_by_position(s, 5)
'2019-01-09'
>>> get_index_by_position(s, 6)
'2019-01-10'
>>> get_index_by_position(s, 8)
'2019-01-14'

How can I implement get_index_by_position()?

edited Apr 15 '20 at 12:46

asked Apr 15 '20 at 12:29

Brian

1

kindly share a sample data representing ur question – sammywemmy Apr 15 '20 at 12:32
try s.reset_index(), then you can access `2019-01-09` using s and its corresponding position 5. – Rajat Mishra Apr 15 '20 at 12:32
@jezrael I'm using `pandas.Series`, not `pandas.DataFrame`. – Brian Apr 15 '20 at 13:06
`s.index.get_loc(5)` returns `KeyError: 5`. I tried `str(target_price.index[5])`, then found it works. – Brian Apr 15 '20 at 13:08
Anyway, thank you for your hint. :-) – Brian Apr 15 '20 at 13:09
hups, you are right, just tested. – jezrael Apr 15 '20 at 13:12

0 Answers0