{"action":"created","issue":{"url":"https://api.github.com/repos/pydata/pandas/issues/13090","repository_url":"https://api.github.com/repos/pydata/pandas","labels_url":"https://api.github.com/repos/pydata/pandas/issues/13090/labels{/name}","comments_url":"https://api.github.com/repos/pydata/pandas/issues/13090/comments","events_url":"https://api.github.com/repos/pydata/pandas/issues/13090/events","html_url":"https://github.com/pydata/pandas/issues/13090","id":153212445,"number":13090,"title":"Slicing on DatetimeIndex throws KeyError: [int] not found","user":{"login":"twiecki","id":674200,"avatar_url":"https://avatars.githubusercontent.com/u/674200?v=3","gravatar_id":"","url":"https://api.github.com/users/twiecki","html_url":"https://github.com/twiecki","followers_url":"https://api.github.com/users/twiecki/followers","following_url":"https://api.github.com/users/twiecki/following{/other_user}","gists_url":"https://api.github.com/users/twiecki/gists{/gist_id}","starred_url":"https://api.github.com/users/twiecki/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/twiecki/subscriptions","organizations_url":"https://api.github.com/users/twiecki/orgs","repos_url":"https://api.github.com/users/twiecki/repos","events_url":"https://api.github.com/users/twiecki/events{/privacy}","received_events_url":"https://api.github.com/users/twiecki/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pydata/pandas/labels/Indexing","name":"Indexing","color":"0b02e1"},{"url":"https://api.github.com/repos/pydata/pandas/labels/Timeseries","name":"Timeseries","color":"AFEEEE"},{"url":"https://api.github.com/repos/pydata/pandas/labels/Usage%20Question","name":"Usage Question","color":"0052cc"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-05-05T11:17:10Z","updated_at":"2016-05-05T12:09:44Z","closed_at":null,"body":"#### Code Sample, a copy-pastable example if possible\r\nUnfortunately can't reproduce it with other examples. Only this which I load from csv.\r\n![image](https://cloud.githubusercontent.com/assets/674200/15042375/893f4f52-12c3-11e6-9e18-96892b53035e.png)\r\n\r\n```txn.loc[pd.Timestamp('2014-06-04 00:00:00'):]```\r\n\r\n```---------------------------------------------------------------------------\r\nKeyError                                  Traceback (most recent call last)\r\n<ipython-input-35-ce3d2db63a82> in <module>()\r\n----> 1 txn.loc[pd.Timestamp('2014-06-04 00:00:00'):]\r\n\r\n/opt/miniconda/lib/python2.7/site-packages/pandas/core/indexing.py in __getitem__(self, key)\r\n   1284             return self._getitem_tuple(key)\r\n   1285         else:\r\n-> 1286             return self._getitem_axis(key, axis=0)\r\n   1287 \r\n   1288     def _getitem_axis(self, key, axis=0):\r\n\r\n/opt/miniconda/lib/python2.7/site-packages/pandas/core/indexing.py in _getitem_axis(self, key, axis)\r\n   1398         if isinstance(key, slice):\r\n   1399             self._has_valid_type(key, axis)\r\n-> 1400             return self._get_slice_axis(key, axis=axis)\r\n   1401         elif is_bool_indexer(key):\r\n   1402             return self._getbool_axis(key, axis=axis)\r\n\r\n/opt/miniconda/lib/python2.7/site-packages/pandas/core/indexing.py in _get_slice_axis(self, slice_obj, axis)\r\n   1306         labels = obj._get_axis(axis)\r\n   1307         indexer = labels.slice_indexer(slice_obj.start, slice_obj.stop,\r\n-> 1308                                        slice_obj.step, kind=self.name)\r\n   1309 \r\n   1310         if isinstance(indexer, slice):\r\n\r\n/opt/miniconda/lib/python2.7/site-packages/pandas/tseries/index.py in slice_indexer(self, start, end, step, kind)\r\n   1503 \r\n   1504         try:\r\n-> 1505             return Index.slice_indexer(self, start, end, step, kind=kind)\r\n   1506         except KeyError:\r\n   1507             # For historical reasons DatetimeIndex by default supports\r\n\r\n/opt/miniconda/lib/python2.7/site-packages/pandas/indexes/base.py in slice_indexer(self, start, end, step, kind)\r\n   2698         \"\"\"\r\n   2699         start_slice, end_slice = self.slice_locs(start, end, step=step,\r\n-> 2700                                                  kind=kind)\r\n   2701 \r\n   2702         # return a slice\r\n\r\n/opt/miniconda/lib/python2.7/site-packages/pandas/indexes/base.py in slice_locs(self, start, end, step, kind)\r\n   2877         start_slice = None\r\n   2878         if start is not None:\r\n-> 2879             start_slice = self.get_slice_bound(start, 'left', kind)\r\n   2880         if start_slice is None:\r\n   2881             start_slice = 0\r\n\r\n/opt/miniconda/lib/python2.7/site-packages/pandas/indexes/base.py in get_slice_bound(self, label, side, kind)\r\n   2826             except ValueError:\r\n   2827                 # raise the original KeyError\r\n-> 2828                 raise err\r\n   2829 \r\n   2830         if isinstance(slc, np.ndarray):\r\n\r\nKeyError: 1401840000000000000\r\n```\r\n\r\n#### Expected Output\r\nSlice of everything after '2014-06-04 00:00:00'.\r\n\r\n#### output of ``pd.show_versions()``\r\n```\r\nINSTALLED VERSIONS\r\n------------------\r\ncommit: None\r\npython: 2.7.11.final.0\r\npython-bits: 64\r\nOS: Linux\r\nOS-release: 3.13.0-77-generic\r\nmachine: x86_64\r\nprocessor: x86_64\r\nbyteorder: little\r\nLC_ALL: en_US.UTF-8\r\nLANG: en_US.UTF-8\r\n\r\npandas: 0.18.0\r\nnose: 1.3.7\r\npip: 8.1.1\r\nsetuptools: 20.7.0\r\nCython: 0.23.4\r\nnumpy: 1.11.0\r\nscipy: 0.17.0\r\nstatsmodels: 0.6.1\r\nxarray: None\r\nIPython: 3.2.1\r\nsphinx: 1.3.1\r\npatsy: 0.4.0\r\ndateutil: 2.5.3\r\npytz: 2016.4\r\nblosc: None\r\nbottleneck: 1.0.0\r\ntables: 3.2.2\r\nnumexpr: 2.4.3\r\nmatplotlib: 1.5.1\r\nopenpyxl: None\r\nxlrd: None\r\nxlwt: None\r\nxlsxwriter: None\r\nlxml: None\r\nbs4: 4.3.2\r\nhtml5lib: None\r\nhttplib2: None\r\napiclient: None\r\nsqlalchemy: 1.0.8\r\npymysql: None\r\npsycopg2: 2.6.1 (dt dec pq3 ext)\r\njinja2: 2.8\r\nboto: 2.30.0\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/pydata/pandas/issues/comments/217137615","html_url":"https://github.com/pydata/pandas/issues/13090#issuecomment-217137615","issue_url":"https://api.github.com/repos/pydata/pandas/issues/13090","id":217137615,"user":{"login":"jreback","id":953992,"avatar_url":"https://avatars.githubusercontent.com/u/953992?v=3","gravatar_id":"","url":"https://api.github.com/users/jreback","html_url":"https://github.com/jreback","followers_url":"https://api.github.com/users/jreback/followers","following_url":"https://api.github.com/users/jreback/following{/other_user}","gists_url":"https://api.github.com/users/jreback/gists{/gist_id}","starred_url":"https://api.github.com/users/jreback/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jreback/subscriptions","organizations_url":"https://api.github.com/users/jreback/orgs","repos_url":"https://api.github.com/users/jreback/repos","events_url":"https://api.github.com/users/jreback/events{/privacy}","received_events_url":"https://api.github.com/users/jreback/received_events","type":"User","site_admin":false},"created_at":"2016-05-05T12:09:44Z","updated_at":"2016-05-05T12:09:44Z","body":"cc @nileracecrew \r\n\r\n@shoyer @jorisvandenbossche "}}