重采样重复时间序列

Question

我有下面的时间序列

time             sensor  status
2017-11-20 12:28:16 SM4 Movement
2017-11-20 12:28:18 SM4 No movement
2017-11-20 12:28:20 SM4 Movement
2017-11-20 12:28:20 SM3 Movement
2017-11-20 12:28:20 SM3 No movement
2017-11-20 12:28:23 D03 Open
2017-11-20 12:28:25 C13 Open

我想重新采样重复的datetimeindex，并将此索引作为最终重采样数据帧中的副本

df= pd.read_csv(r'.........p\gg.csv', parse_dates=['time'], index_col= 'time')

df=df.resample('s').first().ffill()

我明白了

time            sensor  status      
2017-11-20 12:28:16 SM4 Movement
2017-11-20 12:28:17 SM4 Movement
2017-11-20 12:28:18 SM4 No movement
2017-11-20 12:28:19 SM4 No movement
2017-11-20 12:28:20 SM4 Movement
2017-11-20 12:28:21 SM4 Movement
2017-11-20 12:28:22 SM4 Movement
2017-11-20 12:28:23 D03 Open
2017-11-20 12:28:24 D03 Open
2017-11-20 12:28:25 C13 Open

我试过了

df.set_index('time', inplace=True)

我希望

time             sensor status          
2017-11-20 12:28:16 SM4 Movement
2017-11-20 12:28:17 SM4 Movement
2017-11-20 12:28:18 SM4 No movement
2017-11-20 12:28:19 SM4 No movement
2017-11-20 12:28:20 SM4 Movement
2017-11-20 12:28:21 SM4 Movement
2017-11-20 12:28:22 SM4 Movement
2017-11-20 12:28:20 SM3 Movement
2017-11-20 12:28:21 SM3 Movement
2017-11-20 12:28:22 SM3 Movement
2017-11-20 12:28:20 SM3 No movement
2017-11-20 12:28:21 SM3 No movement
2017-11-20 12:28:22 SM3 No movement