KeyError: 0 when accessing value in pandas series

Question

In my script I have df['Time'] as shown below.

497   2017-08-06 11:00:00
548   2017-08-08 15:00:00
580   2017-08-10 04:00:00
646   2017-08-12 23:00:00
Name: Time, dtype: datetime64[ns]

But when i do

t1=pd.Timestamp(df['Time'][0])

I get an error like this :

KeyError: 0

Do I need any type conversion here, if yes then how it can be fixed?

Try `df['Time'].iloc[0]`. Since `0` doesn't exist in index it doesn't work. For positional indexing you need to use `.iloc` — Zero, Sep 11 '17 at 10:37

score 33 · Accepted Answer · edited Sep 11 '17 at 10:53

33

You're looking for df.iloc.

df['Time'].iloc[0]

df['Time'][0] would've worked if your series had an index beginning from 0

And if need scalar only use Series.iat:

df['Time'].iat[0]

edited Sep 11 '17 at 10:53

jezrael

answered Sep 11 '17 at 10:42

cs95

3

Since the dtype is `datetime` `to_datetime` is not required. `pd.Timestamp` as well. – Bharath Sep 11 '17 at 10:50

1 Answers1