使用给定的timedelta重新采样时间序列

使用给定的timedelta重新采样时间序列

您可以使用

melt

带有

resample

-
0.18.1版本的大熊猫
：

df.beginning_time = pd.to_datetime(df.beginning_time)df.end_time = pd.to_datetime(df.end_time)df = pd.melt(df, id_vars=['Id','bitrate'], value_name='dates').drop('variable', axis=1)df.set_index('dates', inplace=True)print(df)  Id  bitratedates        2016-07-08 02:17:42  CODI126640013.ts  37500002016-07-08 02:05:35  CODI126622312.ts  37500002016-07-08 02:17:55  CODI126640013.ts  37500002016-07-08 02:26:11  CODI126622312.ts  3750000print (df.groupby('Id').resample('1S').ffill())        Id  bitrateId    dates        CODI126622312.ts 2016-07-08 02:05:35  CODI126622312.ts  3750000      2016-07-08 02:05:36  CODI126622312.ts  3750000      2016-07-08 02:05:37  CODI126622312.ts  3750000      2016-07-08 02:05:38  CODI126622312.ts  3750000      2016-07-08 02:05:39  CODI126622312.ts  3750000      2016-07-08 02:05:40  CODI126622312.ts  3750000      2016-07-08 02:05:41  CODI126622312.ts  3750000      2016-07-08 02:05:42  CODI126622312.ts  3750000      2016-07-08 02:05:43  CODI126622312.ts  3750000      2016-07-08 02:05:44  CODI126622312.ts  3750000      2016-07-08 02:05:45  CODI126622312.ts  3750000      2016-07-08 02:05:46  CODI126622312.ts  3750000      2016-07-08 02:05:47  CODI126622312.ts  3750000      ...      ...