I am trying to visualize Time series data is as follows enter image description here

following is my code to plot the data

plt.plot(data['date'], data['c_16_avg_a'])


the date is getting truncated here. and the plot looks wired.

Any suggestions will greatly be appreciated

enter image description here

  • $\begingroup$ Are your values sorted by the date (increasing)? If not matplotlib will simply go in the order the values are provided (i.e. go forwards and backwards) in time. $\endgroup$
    – Oxbowerce
    Commented Jan 27, 2021 at 8:36

1 Answer 1


This is happening because the dates in your column are not sorted. To fix this either sort the values by the date column or, even better, plot using the timestamps instead of their dates. Matplotlib inherently handles datetime format better than it does datest represented as strings!

The best option however, is to add the timestamps as the dataframe's index and use pd.Series.plot() instead of matplotlib.

data.index = data['time_stamp']

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.