本文介绍了如何检查两个日期是否介于代表开始日期和结束日期的数据框的两列之间的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试检查我的开始日期和结束日期是否在数据框中的给定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更多推荐
如何检查两个日期是否介于代表开始日期和结束日期的数据框的两列之间
发布评论