0

I have a pandas dataframe with the following format:

Time        07:45:00    08:00:00    08:30:00    08:45:00    09:05:00    09:30:00    10:00:00    11:30:00    Total
2020-03-09  NaN         NaN         NaN         NaN         400.0       NaN         450.0       NaN     NaN
2020-03-10  NaN         NaN         NaN         NaN         350.0       NaN         NaN         NaN     10

I want to adjust the timestamps into the rows (as indexes or just as values), without the total column, how can I convert it, that it looks like:

Time          Timestamp   Value  Total
2020-03-09    07:45:00    NaN    NaN
....
2020-03-09    09:05:00    400.0  NaN
...
20-03-10     11:30:00     NaN    10
PV8
  • 5,799
  • 7
  • 43
  • 87

0 Answers0