An example is best:
2 Inn: df = P.DataFrame(index=P.date_range('2014-9-6 1:30', '2014-9-9', freq='6H')) 3 Inn: df 3 Out: 2014-09-06 01:30:00 2014-09-06 07:30:00 2014-09-06 13:30:00 2014-09-06 19:30:00 2014-09-07 01:30:00 2014-09-07 07:30:00 2014-09-07 13:30:00 2014-09-07 19:30:00 2014-09-08 01:30:00 2014-09-08 07:30:00 2014-09-08 13:30:00 2014-09-08 19:30:00 2014-09-09 01:30:00 4 Inn: df.index.asof('2014-9-8') # wrong 4 Out: Timestamp('2014-09-08 00:00:00') 5 Inn: df.index.asof(P.to_datetime('2014-9-8')) # right 5 Out: Timestamp('2014-09-07 19:30:00', offset='6H') 7 Inn: P.version.version 7 Out: '0.14.1'
df.index.asof() appears to know how to handle datetime strings, but it cant
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4