如何在绘图上拟合日期

Question

我有下面的数据框，我正试图绘制它

    Date    Light (umols)   Time_difference Time_analysis
0   2018-11-17 00:00:00 5000.0  0 days 00:00:00 fine
1   2018-11-17 00:03:00 5000.0  0 days 00:03:00 fine
2   2018-11-17 00:06:00 5000.0  0 days 00:03:00 fine
3   2018-11-17 00:09:00 5000.0  0 days 00:03:00 fine
4   2018-11-17 00:12:00 5000.0  0 days 00:03:00 fine

... ... ... ... ...
482785  2021-02-22 23:59:56 634.4   0 days 00:00:00 fine
482786  2021-02-22 23:59:57 574.3   0 days 00:00:00 fine
482787  2021-02-22 23:59:58 598.9   0 days 00:00:00 fine
482788  2021-02-22 23:59:59 676.9   0 days 00:00:00 fine
482789  2021-02-23 00:00:00 5000.0  0 days 00:03:00 fine

正如你所看到的，它是巨大的，所以我将它分解成大约10个较小的df

我想把‘日期’和‘灯光（umols）’列绘制成一个直线图上的连续图

不幸的是，当我尝试下面的代码时，我想要绘制的日期时间都被压扁了，难以辨认

ax = plt.gca()

closer_1.plot(kind = 'line', x = 'Date', y = 'Light (umols)', ax=ax)

plt.show()

closer_1产生以下结果：

    Date    Light (umols)   Time_difference Time_analysis
0   2018-11-17 00:00:00 5000.0  0 days 00:00:00 fine
1   2018-11-17 00:03:00 5000.0  0 days 00:03:00 fine
2   2018-11-17 00:06:00 5000.0  0 days 00:03:00 fine
3   2018-11-17 00:09:00 5000.0  0 days 00:03:00 fine
4   2018-11-17 00:12:00 5000.0  0 days 00:03:00 fine
... ... ... ... ...
25675   2018-12-31 23:45:00 5000.0  0 days 00:03:00 fine
25676   2018-12-31 23:48:00 5000.0  0 days 00:03:00 fine
25677   2018-12-31 23:51:00 5000.0  0 days 00:03:00 fine
25678   2018-12-31 23:54:00 5000.0  0 days 00:03:00 fine
25679   2018-12-31 23:57:00 5000.0  0 days 00:03:00 fine

有什么建议吗

Answer 1

由于Date当前是类型object，请将其转换为实datetime并查看这是否有帮助：

closer_1['Date'] = pd.to_datetime(closer_1.Date)
closer_1.plot(kind = 'line', x = 'Date', y = 'Light (umols)', ax=ax)