如何基于日期时间索引对Pandas Dataframe进行切片 [英] How to slice a Pandas Dataframe based on datetime index
本文介绍了如何基于日期时间索引对Pandas Dataframe进行切片的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
这已经困扰了我好久了:
This has been bothering me for ages now:
给出一个简单的熊猫DataFrame
Given a simple pandas DataFrame
>>> df
Timestamp Col1
2008-08-01 0.001373
2008-09-01 0.040192
2008-10-01 0.027794
2008-11-01 0.012590
2008-12-01 0.026394
2009-01-01 0.008564
2009-02-01 0.007714
2009-03-01 -0.019727
2009-04-01 0.008888
2009-05-01 0.039801
2009-06-01 0.010042
2009-07-01 0.020971
2009-08-01 0.011926
2009-09-01 0.024998
2009-10-01 0.005213
2009-11-01 0.016804
2009-12-01 0.020724
2010-01-01 0.006322
2010-02-01 0.008971
2010-03-01 0.003911
2010-04-01 0.013928
2010-05-01 0.004640
2010-06-01 0.000744
2010-07-01 0.004697
2010-08-01 0.002553
2010-09-01 0.002770
2010-10-01 0.002834
2010-11-01 0.002157
2010-12-01 0.001034
如何分隔它,以便新的DataFrame等于df中2009-05-01
和2010-03-01
How do I separate it so that a new DataFrame equals the entries in df for the dates between 2009-05-01
and 2010-03-01
>>> df2
Timestamp Col1
2009-05-01 0.039801
2009-06-01 0.010042
2009-07-01 0.020971
2009-08-01 0.011926
2009-09-01 0.024998
2009-10-01 0.005213
2009-11-01 0.016804
2009-12-01 0.020724
2010-01-01 0.006322
2010-02-01 0.008971
2010-03-01 0.003911
推荐答案
如果已将时间戳"列设置为索引,则可以简单地使用
If you have set the "Timestamp" column as the index , then you can simply use
df['2009-05-01' :'2010-03-01']
这篇关于如何基于日期时间索引对Pandas Dataframe进行切片的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文