Plotting a time series?
Please use
df.set_index('Date').plot()
or
df.plot(x='Date', y='Result')
because of the plot by default use index of df
as the x-axis, so you should set the 'Date' column as the index, or specify which column to use as the x-axis.
see more at pandas.DataFrame.plot
RedaBitar
Updated on July 05, 2022Comments
-
RedaBitar almost 2 years
I'm really new to using python as a data analysis tool, and it's my first time ever dealing with time series. I have a data set which has dates in the first column, and a "result" integer which is either 1 or 0. The date column was successfully converted to a time object. I tried to plot the values directly using matplotlib's plot function, but that did not work.. Sample:
Date Result 2017-01-06 0.0 2017-01-06 1.0 2017-01-06 0.0 2017-01-07 0.0 2017-01-07 0.0
I tried using df.plot(), but the resulting plot has very undesirable results.
What I want at the end of the day is dates on the x axis, and the "result" on the y axis. Where am I going wrong? What's wrong with what I'm doing? EDIT: Here's the graph