如何检查两个日期是否介于代表开始日期和结束日期的数据框的两列之间 [英] How to check if two dates falls between two columns of dataframe representing start date and end date

问题描述

我正在尝试检查我的开始日期和结束日期是否在数据框中的给定StartDate和EndDate之间

I am trying to check if my start date and end date falls between the given StartDate and EndDate in my dataframe

DataFrame看起来像

DataFrame looks like

TermYear Term   StartDate      EndDate
 2017     1     2017-01-10    2017-03-31
 2017     2     2017-04-10    2017-06-30
 2017     3     2017-07-24    2017-09-18
 2017     4     2017-09-30    2017-12-04

我正在尝试获取给定日期即

I am trying to fetch the term and TermYear when my given date i.e.

Start Date: '2017-01-24'
End Date: '2017-09-29'

在数据帧的开始日期和结束日期之间，应该获取多个行有什么想法吗?我尝试过

Lies between start and end date of dataframe it should fetch multiple rows any ideas? I have tried

lowerDate = np.datetime64('2017-07-24')
upperDate = np.datetime64('2017-07-26')
termDates = termDates[(termDates.StartDate >= lowerDate) &
                      (termDates.EndDate <= upperDate) ][['Term', 'TermYear']]

但是它返回了空的数据框

But it returns me empty dataframe

预期输出:

Term    TermYear
 2017     1     
 2017     2     
 2017     3     

推荐答案

使用

In [1820]: df[(df.StartDate <= StartDate) & (df.EndDate >= EndDate)]
Out[1820]:
   TermYear  Term   StartDate     EndDate
2      2017     3  2017-07-24  2017-09-18

对于特定列

In [1826]: df.loc[(df.StartDate<=StartDate) & (df.EndDate>=EndDate), ['Term', 'TermYear']]
Out[1826]:
   Term  TermYear
2     3      2017

在哪里

In [1821]: df
Out[1821]:
   TermYear  Term   StartDate     EndDate
0      2017     1  2017-01-10  2017-03-31
1      2017     2  2017-04-10  2017-06-30
2      2017     3  2017-07-24  2017-09-18
3      2017     4  2017-09-30  2017-12-04

In [1822]: StartDate
Out[1822]: '2017-07-24'

In [1823]: EndDate
Out[1823]: '2017-08-29'

In [1835]: df.dtypes
Out[1835]:
TermYear              int64
Term                  int64
StartDate    datetime64[ns]
EndDate      datetime64[ns]
dtype: object

这篇关于如何检查两个日期是否介于代表开始日期和结束日期的数据框的两列之间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！