您可以使用
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 ... ...
