i have a dataframe like this
Datetime status time
2020-03-28 22:14:08 start 0
2020-03-29 00:28:50 end 02:13:52
2020-03-29 07:15:10 start 0
2020-03-29 07:48:02 end 00:32:47
我该如何将其转换为以下内容
start end time
2020-03-28 22:14:08 2020-03-29 00:28:50 02:13:52
2020-03-29 07:15:10 2020-03-29 07:48:02 00:32:47
df = pd.DataFrame({'Datetime': ['2020-03-28 22:14:08', '2020-03-29 00:28:50', '2020-03-29 07:15:10', '2020-03-29 07:48:02'], 'status': ['start', 'end', 'start', 'end'], 'time': ['0', '02:13:52', '0', '00:32:47']})
- jezraelpd.DataFrame({'start': a.loc['start']['Datetime'].to_numpy(), ...})
。我认为使用inplace
不是一个好习惯,请参考这里和这里。 - jezrael