Plotly Dash : Time Series Scatter plot rendering

Question

I’m following the dash wind streaming example to stream data from a MySQL database. Data is added to the database every 5 seconds and queried respectively. I used the Interval component to query and a hidden div to store. I read the jsonified data in a callback function into a dataframe called df.

I generate a trace using the following:

trace_sensor_1 = Scatter(
    x=df.loc[df['sensor_id'] == 1]['timestamp'],
    y=df.loc[df['sensor_id'] == 1]['sensor_reading'],
    mode='markers+lines',
    name='Sensor 1',

However, the scatter plot that this generates (attached) jumps all over the place. Is this due to the mode I’m using? How do I modify the trace to render a proper looking time series scatter?

provide some sample working data with the issue, this will provide a faster resolution! — Naren Murali
– Naren Murali, Commented Jun 1, 2018 at 4:30
Try sorting the date by 'timestamp' values, and then plot. — byouness
– byouness, Commented Jun 1, 2018 at 22:11

Nils · Accepted Answer · 2018-06-24 19:50:01Z

1

For plotly its important to sort your data by your x axis first.

In pandas you can sort like this:

df_sorted = df.sort_values(by=['timestamp'])

answered Jun 24, 2018 at 19:50

Nils

2,69518 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

Plotly Dash : Time Series Scatter plot rendering

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related