我有一个数据,看起来像这样:
时间 | 数据 |
---|---|
13:45:00 | 数据1 |
00:00:03 | 数据6 |
试试这个:
idx = pd.to_datetime("2021/04/19 " + df["Time"]) + pd.to_timedelta(
pd.to_datetime(df["Time"]).diff().lt(pd.Timedelta(seconds=0)).cumsum(), unit="days"
)
dfi = df.set_index(idx)
dfi.resample("S").ffill()
输出:
Time Data
Time
2021-04-19 13:45:00 13:45:00 Data 1
2021-04-19 13:45:01 13:45:00 Data 1
2021-04-19 13:45:02 13:45:00 Data 1
2021-04-19 13:45:03 13:45:03 Data 2
2021-04-19 13:45:04 13:45:03 Data 2
... ... ...
2021-04-20 00:00:22 00:00:03 Data 6
2021-04-20 00:00:23 00:00:03 Data 6
2021-04-20 00:00:24 00:00:03 Data 6
2021-04-20 00:00:25 00:00:03 Data 6
2021-04-20 00:00:26 00:00:26 Data 7
[36927 rows x 2 columns]