'DataFrame' object has no attribute 'DatetimeIndex'

Question

I am trying to return a Pandas with Date that has been set as the DateTimeIndex. I have tried many things similar to

inx=OutputDataSet.DatetimeIndex.to_pydatetime()

or

inx=OutputDataSet.DatetimeIndex.to_pydatetime(format =''%y-%m-%d'')

But I keep getting the error

'DataFrame' object has no attribute 'DatetimeIndex'

This is what the info attribute is showing;

<class 'pandas.core.frame.DataFrame'>
DatetimeIndex: 1047 entries, 2017-01-03 to 2021-02-19
Data columns (total 6 columns):
Open         1047 non-null float64
High         1047 non-null float64
Low          1047 non-null float64
Close        1047 non-null float64
Adj Close    1047 non-null float64
Volume       1047 non-null int64
dtypes: float64(5), int64(1)
memory usage: 57.3 KB

So clearly there is a DatetimeIndex

The print output has no problem displaying the DatetimeIndex

                     Open       High   ...     Adj Close   Volume
Date                               ...                       
2017-01-03   2.870000   2.940000   ...      2.842312   146804
2017-01-04   2.950000   3.090000   ...      2.871415   292371
2017-01-05   3.000000   3.000000   ...      2.871415   186374
2017-01-06   2.950000   2.970000   ...      2.764707   141723
2017-01-09   2.900000   2.970000   ...      2.842312    60815

Ideally I would like the DataFrame to present as

    Date         1047 non-null datetime
    Open         1047 non-null float64
    High         1047 non-null float64
    Low          1047 non-null float64
    Close        1047 non-null float64
    Adj Close    1047 non-null float64
    Volume       1047 non-null int64

Any help would be appreciated

Rikki · Accepted Answer · 2021-02-20 03:59:08Z

1

I think DatetimeIndex is the type of index you have on your pandas.DataFrame. Every DataFrame comes with the property index and index could be of different types from DateTimeIndex to PeriodIndex and TimedeltaIndex (guide here)

So in your output, Date IS your index. You might want to rethink using pandas DataFrame if that's not the output you are expecting.

edited Feb 20, 2021 at 3:59

answered Feb 20, 2021 at 3:13

Rikki

3,5681 gold badge25 silver badges34 bronze badges

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

4 Comments

Ben Watson Over a year ago

The package that I am calling is returning the DataFrame and the target system that is processing the data (SQL Server) is expecting a DataFrame to no getting away from Pandas.

Rikki Over a year ago

Then df.index should return the date you're looking for. Working with Pandas is really easy, don't get me wrong. My point was, perhaps read the docs and see how you can get what you want out of it.

Ben Watson Over a year ago

Got it - thank you Rikki. DateTimeIndex is an 'type' of 'property' index.

Rikki Over a year ago

Precisely. So you could set df.index to df['timestamp'] or just call df.reset_index(inplace=True) which will reset your index to default (pandas.pydata.org/pandas-docs/stable/reference/api/…). Please accept the answer when you get a chance. Thank you.

Ben Watson · Accepted Answer · 2021-02-20 23:47:38Z

1

Solution is the following;

OutputDataSet.insert(loc=0,column=''Date'', value=pd.to_datetime(OutputDataSet.index))

answered Feb 20, 2021 at 23:47

Ben Watson

1592 silver badges10 bronze badges

Comments

George Odette · Accepted Answer · 2023-03-03 20:43:28Z

0

If OutputDataSet is your dataFrame, you should call DatetimeIndex as a method in pandas and not the dataFrame. You will want to call pd.DatetimeIndex and not OutputDataSet.DatetimeIndex. Same to to_pydatetime. It should be pd.to_pydatetime

answered Mar 3, 2023 at 20:43

George Odette

113 bronze badges

Collectives™ on Stack Overflow

'DataFrame' object has no attribute 'DatetimeIndex'

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related