Python数据帧在微秒内重新采样 [英] Python Data Frame resample on micro second

问题描述

我正在对数据帧进行重采样，它可以在数小时，数分钟的时间内运行，但不会在不到sec的时间内进行重采样.程序即使在很短的时间间隔内也会挂起.那我想念什么吗?

I am working with resampling data frame and it works on hours, days mins, but doesn't resample less then sec. Program just hangs even on short time span. So am I missing something?

我尝试了0.000001S，U等.到目前为止没有任何效果.

I tried 0.000001S, U etc... Nothing worked so far.

我的时间格式:2015-08-29 19:30:47.015506

my time format: 2015-08-29 19:30:47.015506

您可以看到变量sf代表重采样频率.

you can see varable sf represent resampling freq.

grph = df.set_index('Date and Time').resample(sf, len).astype(int)

如何以微秒粒度重新采样数据帧?

How can I resample data frame on micro seconds granularity?

推荐答案

sf = "1U" #for one microsecond

使用毫秒/微秒/秒:

L       milliseonds
U       microseconds
S       seconds

完整文档:

B       business day frequency
C       custom business day frequency (experimental)
D       calendar day frequency
W       weekly frequency
M       month end frequency
BM      business month end frequency
CBM     custom business month end frequency
MS      month start frequency
BMS     business month start frequency
CBMS    custom business month start frequency
Q       quarter end frequency
BQ      business quarter endfrequency
QS      quarter start frequency
BQS     business quarter start frequency
A       year end frequency
BA      business year end frequency
AS      year start frequency
BAS     business year start frequency
BH      business hour frequency
H       hourly frequency
T       minutely frequency
S       secondly frequency
L       milliseonds
U       microseconds
N       nanoseconds

这篇关于Python数据帧在微秒内重新采样的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！