/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

0 vote304 views1 answer
Regex for repeating words python
Python
0 vote343 views1 answer
Settings.debug django
Python Django
2 votes293 views1 answer
How to make rich presence discord,py
Python
0 vote311 views2 answers
How to get value from txtbox in flask
Python
31 votes305 views2 answers
How to divide string in python
Python
11 votes336 views3 answers
Ocr python library
Python
1 vote369 views1 answer
Redirected but the response is missing a Location: header.
Python
0 vote288 views1 answer
Python compactar arquivo antes de exportar
Python
9 votes306 views2 answers
Install python linux ubuntu
Python
7 votes341 views3 answers
Python change data type to integer
Python