TypeError after trying to plot dataframe with mpf.plot

Question

I have a panda dataframe with the following columns:

Now I would like to plot out a chart with mpf.plot. But I am getting the following error:

How can I avoid the above TypeError Message? I did set the df index with the following command:

dfnew_plot = dfnew_plot.set_index('Date')

Are you sure Date is already a datetime column? in other words, when you print type(dfnew_plot.index) does it return pandas.core.indexes.datetimes.DatetimeIndex ? — solopiu
– solopiu, Commented Jan 30, 2021 at 11:04

Ollie in PGH · Accepted Answer · 2021-01-30 11:34:12Z

2

Your index isn't the correct dtype. It needs to be converted using:

dfnew_plot.index = pd.to_datetime(dfnew_plot.index)

answered Jan 30, 2021 at 11:34

Ollie in PGH

2,6292 gold badges18 silver badges19 bronze badges

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

2 Comments

Yvar Over a year ago

Thanks a lot for your help. Your solution solves my problem. Question: If I print the df before and after the code dfnew_plot.index = pd.to_datetime(dfnew_plot.index), i do not see any differences? What do I have to learn, to understand the difference?

Ollie in PGH Over a year ago

Your index was a dtype of string or "object" according to pandas. To check the dtype of any Series (column, or index) you can use the dtype attribute. Example: `dfnew_plot.index.dtype'. If the result is "O" or "Object" or anything besides "DateTimeIndex" then your financial plotting library won't work.

Collectives™ on Stack Overflow

TypeError after trying to plot dataframe with mpf.plot

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related