python方差的计算公式_使用python中的时间序列数据来计算均值、方差和标准偏差...

我想您可以先将sec^{}、^{}和{a3}转换为2 seconds（2S）：df['sec'] = pd.to_timedelta(df.sec, unit='s')

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

print (df)

nanosec value

sec

00:16:41 1 0.2

00:16:41 2 0.2

00:16:41 3 0.2

00:16:42 1 0.1

00:16:42 2 0.2

00:16:42 3 0.1

00:16:43 1 0.2

00:16:43 2 0.2

00:16:43 3 0.1

00:16:44 1 0.2

00:16:44 2 0.2

00:16:44 3 0.2

00:16:44 4 0.1

^{pr2}$

也许你需要在resample中改变base：print (df.value.resample('2S', base=1).mean())

sec

00:16:42 0.166667

00:16:44 0.171429

00:16:46 NaN

Freq: 2S, Name: value, dtype: float64

print (df.value.resample('2S', base=1).std())

sec

00:16:42 0.051640

00:16:44 0.048795

00:16:46 NaN

Freq: 2S, Name: value, dtype: float64

print (df.val