Select rows of DataFrame with datetime index based on date

Question

From the following DataFrame with datetime index

                                       'A'
2015-02-17 14:31:00+00:00           127.2801
2015-02-17 14:32:00+00:00           127.7250
2015-02-17 14:33:00+00:00           127.8010
2015-02-17 14:34:00+00:00           127.5450
2015-02-17 14:35:00+00:00           127.6300
...
2016-02-17 20:56:00+00:00            98.0900
2016-02-17 20:57:00+00:00            98.0901
2016-02-17 20:58:00+00:00            98.1000
2016-02-17 20:59:00+00:00            98.0500
2016-02-17 21:00:00+00:00            98.1100

I want to select all rows with a certain date, e.g. 2015-02-17.

Whats the best way to achieve that?

It does. Thanks for your answer! If you upgrade that to a complete answer, I can mark it. — Oblomov
– Oblomov, Commented Oct 10, 2016 at 15:41

EdChum · Accepted Answer · 2016-10-10 15:42:03Z

22

DatetimeIndex supports partial datetime strings for label based indexing:

In [18]:
df.loc['2015-02-17']

Out[18]:
                            A
2015-02-17 14:31:00  127.2801
2015-02-17 14:32:00  127.7250
2015-02-17 14:33:00  127.8010
2015-02-17 14:34:00  127.5450
2015-02-17 14:35:00  127.6300

answered Oct 10, 2016 at 15:42

EdChum

397k204 gold badges836 silver badges583 bronze badges

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

1 Comment

KaiSqDist Over a year ago

Hi, is it possible to retain the original df as a DataFrame instead of Series datatype?

Collectives™ on Stack Overflow

Select rows of DataFrame with datetime index based on date

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related