KeyError: 0 when accessing value in pandas series

python pandas indexing series
Bharat Sharma picture Bharat Sharma · Sep 11, 2017 · Viewed 26.5k times · Source

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?

Answer

cs95 picture cs95 · Sep 11, 2017

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]

Related questions

Accessing a Pandas index like a regular column

I have a Pandas DataFrame with a named index. I want to pass it off to a piece off code that takes a DataFrame, a column name, and some other stuff, and does a bunch of work involving that column. …

Read More
Python Pandas: Get index of rows which column matches certain value

Given a DataFrame with a column "BoolCol", we want to find the indexes of the DataFrame in which the values for "BoolCol" == True I currently have the iterating way to do it, which works perfectly: for i in range(100,3000): if …

Read More
Selecting a row of pandas series/dataframe by integer index

I am curious as to why df[2] is not supported, while df.ix[2] and df[2:3] both work. In [26]: df.ix[2] Out[26]: A 1.027680 B 1.514210 C -1.466963 D -0.162339 Name: 2000-01-03 00:00:00 In [27]: df[2:3] Out[27]: A B C D 2000-01-03 1.02768 1.51421 -1.466963 …

Read More