Slice pandas dataframe based on datetime column

Question

I have a pandas dataframe with a column as datatime that looks like:

data.ts_placed
Out[68]: 
1         2008-02-22 15:30:40
2         2008-03-20 16:56:00
3         2008-06-14 21:26:02
4         2008-06-16 10:26:02
5         2008-06-23 20:41:03
6         2008-07-17 08:02:00
7         2008-10-13 12:47:05
8         2008-11-14 09:20:33
9         2009-02-23 11:24:18
10        2009-03-02 10:29:19

I'd like to slice the dataframe by eliminating all rows before 2009

EdChum · Accepted Answer · 2015-08-07 13:19:12Z

15

You can use a simple string comparison to compare the values against a year string:

In [63]:
df.loc[df['date'] >= '2009']

Out[63]:
                     date
index                    
9     2009-02-23 11:24:18
10    2009-03-02 10:29:19

Or use the dt attribute to access the year:

In [64]:
df.loc[df['date'].dt.year >= 2009]

Out[64]:
                     date
index                    
9     2009-02-23 11:24:18
10    2009-03-02 10:29:19

answered Aug 7, 2015 at 13:19

EdChum

397k204 gold badges836 silver badges583 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Slice pandas dataframe based on datetime column

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related