TypeError: 'DatetimeIndex' object is not callable

Question

I have the following data:

                High
 Date
 2017-07-17    150.90
 2017-07-18    150.13
 2017-07-19    151.42
 2017-07-20    151.74
 2017-07-21    150.44
 2017-07-24    152.44

I was trying to get the index by putting in value inside Highs.index(values) but am unable to get the index.

import datetime as dt
from datetime import timedelta as td
import pandas as pd
import pandas_datareader.data as web
import numpy as np

start = dt.datetime(2017, 7, 15)
df = web.DataReader('AAPL', 'google', start)
highs = df['High']
print('Index = ',highs.index(150.44))

When i use print('Index = ',highs.index(150.44)) i get the type error:

print('Index = ',highs.index(150.44))

TypeError: 'DatetimeIndex' object is not callable

Is their anyway to get the datetime index using a particular value from the dataframe?

What is the 150.44?

patrick
– patrick

2017-07-25 15:04:44 +00:00
Commented Jul 25, 2017 at 15:04 — patrick
– patrick, Commented Jul 25, 2017 at 15:04
sorry, edited the question, please check now.

BlueQuant
– BlueQuant

2017-07-25 15:06:03 +00:00
Commented Jul 25, 2017 at 15:06 — BlueQuant
– BlueQuant, Commented Jul 25, 2017 at 15:06

coldspeed95 · Accepted Answer · 2019-02-18 10:23:25Z

4

You have to use square braces since you are trying to index/slice into the DataFrame's index. So, instead of

df.index(...)

Use

df.index[...]

However, it seems you want to get the index of the column where the High is 150.44. You can do that like this, with boolean indexing:

highs[df['High'] == 150.44].index
# DatetimeIndex(['2017-07-21'], dtype='datetime64[ns]', name='Date', freq=None)

Or, more simply:

highs[df['High'] == 150.44].index.tolist()[0]
# Timestamp('2017-07-21 00:00:00')

edited Feb 18, 2019 at 10:23

answered Jul 25, 2017 at 15:17

coldspeed95

407k106 gold badges746 silver badges799 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

BlueQuant Over a year ago

Highs[df['High'] == 150.44].index This returns date but with unnecessary information, is their anyway to just get output like 2017-07-21 @Coldspeed ?

Collectives™ on Stack Overflow

TypeError: 'DatetimeIndex' object is not callable

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related