/Python/How to slice dataframe based on daterange in pandas

How to slice dataframe based on daterange in pandas

In [15]: df = pd.DataFrame([1, 2, 3], index=[dt.datetime(2013, 1, 1), dt.datetime(2013, 1, 3), dt.datetime(2013, 1, 5)])

In [16]: df
Out[16]: 
            0
2013-01-01  1
2013-01-03  2
2013-01-05  3

In [22]: start = df.index.searchsorted(dt.datetime(2013, 1, 2))

In [23]: end = df.index.searchsorted(dt.datetime(2013, 1, 4))

In [24]: df.iloc[start:end]
Out[24]: 
            0
2013-01-03  2

Source: stackoverflow.com

Similar codes

59 votes310 views6 answers
How to clear console python
Python
14 votes319 views1 answer
Play videos in python
Python
35 votes334 views2 answers
Download pyaudio for python 3.9
Python
0 vote337 views2 answers
How to record youtube cc in python
Python
19 votes306 views2 answers
Renaming headers pandasd
Python
0 vote330 views1 answer
Kivy lang
Python
1 vote327 views2 answers
End python print with space
Python
0 vote339 views1 answer
Django charfield force lowercase
Python
0 vote295 views1 answer
Python why is it important to check the __name__
Python
1 vote317 views1 answer
Django filter not equal to
Python