Matplotlib: Display epoch timestamp as regular date in a plot

Question

Here is my code to plot col_A vs. time:

ax[0].plot(data_df['time'], data_df['col_A'] , color = 'black')

The the plot looks like this:

The x-axis time is currently in "epoch timestamp" unit (https://www.freeformatter.com/epoch-timestamp-to-date-converter.html). Can I display the x-axis using the regular date in the plot? Thanks!

Why don't you just either convert the timestamp before plotting or create a new column in the format you want? See [this](https://stackoverflow.com/questions/19231871/convert-unix-time-to-readable-date-in-pandas-dataframe) for example. There's plenty of examples on Google. — roganjosh, Mar 15 '18 at 19:21
Does it work if you add `data_df['time'].astype('datetime64[s]')` instead of only `data_df['time']` inside `plot` function? — niraj, Mar 15 '18 at 19:23

score 1 · Accepted Answer · answered Mar 15 '18 at 19:46

1

You can try adding data_df['time'].astype('datetime64[s]') instead of only data_df['time'] inside plot function:

ax[0].plot(data_df['time'].astype('datetime64[s]'), data_df['col_A'] , color = 'black')

answered Mar 15 '18 at 19:46

niraj

1 Answers1