/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

10 votes187 views6 answers
How to show a progress bar in python
Python
0 vote200 views1 answer
Django rest framework encrypt passwors
Python
1 vote229 views1 answer
Indentation levels in programming
Python
5 votes199 views1 answer
Selenium webdriver imports
Python
8 votes140 views1 answer
How to get specific columns in df
Python
0 vote187 views1 answer
Pandas dataframe get number of occurrence in column
Python
0 vote200 views1 answer
Sowpods python
Python
0 vote184 views1 answer
Returns the dataframe with the modified Title column in which the updated groupings are reflected.
Python
1 vote176 views1 answer
Minimum from list of tuples
Python
0 vote222 views1 answer
How to loop through pages of pdf using python
Python