Skip to main content
 首页 » 编程设计

python之Pandas 索引与日期值的差异

2024年10月24日13webabcd

如果我有这样的 DataFrame

Date           value 
04 May 2015     1 
06 May 2015     1 
07 May 2015     1 
11 May 2015     1 
11 May 2015     1 

如何获取日期索引的差异?即下面的第三列:

Date           value   Diff 
04 May 2015     1      NA 
06 May 2015     1       2 
07 May 2015     1       1 
11 May 2015     1       4 
11 May 2015     1       0 

请您参考如下方法:

你可以使用pandas.Series.diff

>>> df['Diff'] = df.index.to_series().diff() 
 
            value     Diff 
Date                     
2015-05-04      1      NaT 
2015-05-06      1   2 days 
2015-05-07      1   1 days 
2015-05-11      1   4 days 
2015-05-11      1   0 days 

转换为 float 的优雅方式是

df['Diff'] = df.index.to_series().diff().dt.days 
>>df 
            value  Diff 
Date                    
2015-05-04      1   NaN 
2015-05-06      1   2.0 
2015-05-07      1   1.0 
2015-05-11      1   4.0 
2015-05-11      1   0.0 

更快的方法是类型转换为天数

df.index.to_series().diff().astype('timedelta64[D]') 

转换为整数 (pandas verson >= 0.24 )

df.index.to_series().diff().astype('timedelta64[D]').astype('Int64')  
>>df 
            value  Diff 
Date                    
2015-05-04      1   NaN 
2015-05-06      1     2 
2015-05-07      1     1 
2015-05-11      1     4 
2015-05-11      1     0 

注意:Int64 是 Pandas Nullable Integer数据类型(非 int64)