Skip to main content
 首页 » 编程设计

python之使用 Pandas 在连续的连续时间间隔中找到最小值

2025年05月04日18zfyouxi

我有点卡在这个上面了。我有一个 dataframe,它有一个变量样本,每个样本都有一个时间戳。数据按时间递增的顺序排序:

import pandas as pd 
 
dates = [#Continuous Block 
         pd.Timestamp('2012-05-03 09:00:01'),  
         pd.Timestamp('2012-05-03 09:00:02'),  
         pd.Timestamp('2012-05-03 09:00:03'), 
         pd.Timestamp('2012-05-03 09:00:04'), 
         #Non Continuous Block 
         pd.Timestamp('2012-05-03 16:00:00'), 
         pd.Timestamp('2012-05-03 17:00:04'), 
         #Continuous Block 
         pd.Timestamp('2012-05-03 18:00:01'),  
         pd.Timestamp('2012-05-03 18:00:02'),  
         pd.Timestamp('2012-05-03 18:00:03'), 
         #Non Continuous Block 
         pd.Timestamp('2012-05-03 19:00:03')]      
 
 
vars = [-0.105, -1.08, -1.08, -1.03, -1.0, -1.1, -0.15,-0.14,-0.13,-0.11] 
df = pd.DataFrame({'A' : vars}, index=dates) 

这给出:

                    A 
2012-05-03 09:00:01 -0.105 
2012-05-03 09:00:02 -1.080 
2012-05-03 09:00:03 -1.080 
2012-05-03 09:00:04 -1.030 
2012-05-03 16:00:00 -1.000 
2012-05-03 17:00:04 -1.100 
2012-05-03 18:00:01 -0.150 
2012-05-03 18:00:02 -0.140 
2012-05-03 18:00:03 -0.130 
2012-05-03 19:00:03 -0.110 

如您所见,连续的条目通常相隔一秒。我想在一组间隔 1 秒的时间戳中提取 A 的最低值。所以在上面的例子中,运行一个函数应该给出:

2012-05-03 09:00:03,    -1.080 
2012-05-03 16:00:00,    -1.000 
2012-05-03 17:00:04,    -1.100 
2012-05-03 18:00:01,    -0.150 
2012-05-03 19:00:03,    -0.110 

感谢任何帮助!

请您参考如下方法:

我通过创建一个名为“时间”的附加列来解决这个问题

df['Time'] = df.index 
df2 = df.groupby([df.index.hour]).apply(lambda x: x.min()) 
df2.reset_index(drop = True,inplace='True') 
print df2.head() 

给出:

     A                Time 
0 -1.08 2012-05-03 09:00:01 
1 -1.00 2012-05-03 16:00:00 
2 -1.10 2012-05-03 17:00:04 
3 -0.15 2012-05-03 18:00:01 
4 -0.11 2012-05-03 19:00:03 

如果您只需要按小时分组,则不需要时间列,您需要按时间戳分组:

df2 = df.groupby([df.index.hour]).apply(lambda x: x.min()) 
print df2.head() 

输出为:

       A 
9  -1.08 
16 -1.00 
17 -1.10 
18 -0.15 
19 -0.11