如何检查的日期在一个大熊猫列后一个日期

0

的问题

我有一个大熊猫据框

      date       
0     2010-03  
1     2017-09-14     
2     2020-10-26      
3     2004-12     
4     2012-04-01      
5     2017-02-01      
6     2013-01

我基本上想要的过滤器在日后2015-12(Dec2015年)

要得到这个:

      date       
0     2017-09-14     
1     2020-10-26          
2     2017-02-01  

我尝试过这种

df = df[(df['date']> "2015-12")]

但我得到一个错误

Valueerror异常:错误的数量的项目通过了17、安置意味着1

dataframe pandas python-3.x
2021-11-24 06:19:25
1

最好的答案

1

首先对我的工作解正确的:

df = df[(df['date']> "2015-12")]
print (df)
         date
1  2017-09-14
2  2020-10-26
5  2017-02-01

如果转换为datetimes,应更多强大的对于我的工作:

df = df[(pd.to_datetime(df['date'])> "2015-12")]
print (df)
         date
1  2017-09-14
2  2020-10-26
5  2017-02-01

详细说明:

print (pd.to_datetime(df['date']))
0   2010-03-01
1   2017-09-14
2   2020-10-26
3   2004-12-01
4   2012-04-01
5   2017-02-01
6   2013-01-01
Name: date, dtype: datetime64[ns]
2021-11-24 06:20:45

其他语言

此页面有其他语言版本

Русский
..................................................................................................................
Italiano
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................