pandas 时间序列之间_日期时间函数? [英] pandas timeseries between_datetime function?

问题描述

我一直在熊猫中使用TimeSeries的between_time方法，该方法返回指定时间之间的所有值，而不管它们的日期如何.

I have been using the between_time method of TimeSeries in pandas, which returns all values between the specified times, regardless of their date.

但是我需要选择两个日期和时间，因为我的时间序列结构 包含多个日期.

But I need to select both date and time, because my timeseries structure contains multiple dates.

解决这个问题的一种方法虽然非常不灵活，但只是迭代这些值并删除那些不相关的值.

One way of solving this, though quite inflexible, is just iterate over the values and remove those which are not relevant.

是否有更优雅的方法?

Is there a more elegant way of doing this ?

推荐答案

您可以先选择感兴趣的日期，然后使用between_time.例如，假设您有一个72小时的时间序列:

You can select the dates that are of interest first, and then use between_time. For example, suppose you have a time series of 72 hours:

import pandas as pd
from numpy.random import randn

rng = pd.date_range('1/1/2013', periods=72, freq='H')
ts = pd.Series(randn(len(rng)), index=rng)

要在20:00& amp;之间选择1月2日和3日22:00，您可以执行以下操作:

To select the between 20:00 & 22:00 on the 2nd and 3rd of January you can simply do:

ts['2013-01-02':'2013-01-03'].between_time('20:00', '22:00')

给你这样的东西:

2013-01-02 20:00:00    0.144399
2013-01-02 21:00:00    0.886806
2013-01-02 22:00:00    0.126844
2013-01-03 20:00:00   -0.464741
2013-01-03 21:00:00    1.856746
2013-01-03 22:00:00   -0.286726

这篇关于 pandas 时间序列之间_日期时间函数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！