python - 重新采样重复的时间序列

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

标签： pythonpandasnumpy