How to plot time series data in plotly?

Question

When I plot my data with just the index the graph looks fine. But when I try to plot it with a datetime object in the x axis, the plot gets messed up. Does anyone know why? I provided the head of my data and also the two plots.

import plotly.express as px
fig = px.line(y=data.iloc[:,3])
fig.show()

fig = px.line(y=data.iloc[:,3],x=data.iloc[:,0])
fig.show()

Manish Kumar Singh · Accepted Answer · 2020-07-17 00:59:25Z

1

It is probably because of missing dates as you have around 180 data points but your second plot shows data spans from 2014 to 2019 that means it does not have many data points in between that's why your second graph looks like that.

Instead of datetime try plotting converting it into string but then it will not be a time series as you will have many missing dates

answered Jul 17, 2020 at 0:59

Manish Kumar Singh

4113 silver badges13 bronze badges

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

Comments

Rajdeep Borgohain · Accepted Answer · 2021-11-23 20:31:36Z

0

Here I have two solutions:

Use reset_index() function to get rid off the missing dates but it just explains the chart but x-axis values don't provide date information anymore. Heres an example: This is the data frame and I want to plot the chart between time and closing price

import plotly.graph_objects as go
fig = go.Figure([go.Scatter(x=df.reset_index().index, y=df['close'])])
fig.show()

1277 is the index value and corresponding value is the closing price. Use .iloc() to find the x-axis value

Convert x-axis value to datetime object Follow this link: https://stackoverflow.com/a/51231209/10277042

answered Nov 23, 2021 at 20:31

Rajdeep Borgohain

12113 bronze badges

Collectives™ on Stack Overflow

How to plot time series data in plotly?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related