Assumed I have a table
| id | Datetime | Value |
|---|---|---|
| 1 | 2019-06-01 03:25:00 | 1 |
| 2 | 2019-06-01 08:20:00 | 2 |
| 3 | 2019-06-01 11:50:00 | 3 |
| 5 | 2019-06-02 11:50:00 | 4 |
| 6 | 2019-06-02 01:20:00 | 5 |
How can I create a scatter diagram for value per time, ignoring the date? Using y=df['Datetime'].dt.time throws an error.
Secondly, for correlation analysis: What is the best way to create time as separate column for such correlation analysis?
Thanks!