Plotly axis shows Datetime as numbers instead of dates

Question

I am plotting my Dataframe using Plotly but for some reason, my Datetime values gets converted numbers instead of getting displayed as letters

    fig.add_trace(go.Scatter(x=df2plt["PyDate"].values,
                         y=df2plt["Data"].values))

Renaud · Accepted Answer · 2020-01-24 00:12:28Z

1

If df2plt["PyDate"] is already in datetime format:

fig.add_trace(go.Scatter(x=df2plt["PyDate"],
                     y=df2plt["Data"].values))

Else:

fig.add_trace(go.Scatter(x=pd.to_datetime(df2plt["PyDate"]) ,
                     y=df2plt["Data"].values))

You can change the display with the variable format:

*format : string, default None strftime to parse time, eg “%d/%m/%Y”, note that “%f” will parse all the way up to nanoseconds. See strftime documentation for more information on choices: https://docs.python.org/3/library/datetime.html#strftime-and-strptime-behavior *

answered Jan 23, 2020 at 22:59

Renaud

2,8172 gold badges12 silver badges25 bronze badges

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

1 Answer 1