{"action":"created","issue":{"url":"https://api.github.com/repos/pydata/pandas/issues/11870","labels_url":"https://api.github.com/repos/pydata/pandas/issues/11870/labels{/name}","comments_url":"https://api.github.com/repos/pydata/pandas/issues/11870/comments","events_url":"https://api.github.com/repos/pydata/pandas/issues/11870/events","html_url":"https://github.com/pydata/pandas/pull/11870","id":123095824,"number":11870,"title":"raise NotImplemented for date parsing args in read_excel #11544","user":{"login":"grahamjeffries","id":2829866,"avatar_url":"https://avatars.githubusercontent.com/u/2829866?v=3","gravatar_id":"","url":"https://api.github.com/users/grahamjeffries","html_url":"https://github.com/grahamjeffries","followers_url":"https://api.github.com/users/grahamjeffries/followers","following_url":"https://api.github.com/users/grahamjeffries/following{/other_user}","gists_url":"https://api.github.com/users/grahamjeffries/gists{/gist_id}","starred_url":"https://api.github.com/users/grahamjeffries/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/grahamjeffries/subscriptions","organizations_url":"https://api.github.com/users/grahamjeffries/orgs","repos_url":"https://api.github.com/users/grahamjeffries/repos","events_url":"https://api.github.com/users/grahamjeffries/events{/privacy}","received_events_url":"https://api.github.com/users/grahamjeffries/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pydata/pandas/labels/Error%20Reporting","name":"Error Reporting","color":"ffa0ff"},{"url":"https://api.github.com/repos/pydata/pandas/labels/IO%20Excel","name":"IO Excel","color":"bfe5bf"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/pydata/pandas/milestones/36","html_url":"https://github.com/pydata/pandas/milestones/0.18.0","labels_url":"https://api.github.com/repos/pydata/pandas/milestones/36/labels","id":1214851,"number":36,"title":"0.18.0","description":"","creator":{"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},"open_issues":59,"closed_issues":84,"state":"open","created_at":"2015-07-19T20:18:45Z","updated_at":"2015-12-19T20:03:33Z","due_on":"2016-01-31T05:00:00Z","closed_at":null},"comments":5,"created_at":"2015-12-19T16:21:50Z","updated_at":"2015-12-22T11:15:32Z","closed_at":"2015-12-19T20:03:33Z","pull_request":{"url":"https://api.github.com/repos/pydata/pandas/pulls/11870","html_url":"https://github.com/pydata/pandas/pull/11870","diff_url":"https://github.com/pydata/pandas/pull/11870.diff","patch_url":"https://github.com/pydata/pandas/pull/11870.patch"},"body":"Fixes #11544\r\n\r\nThe `parse_dates` and `date_parser` args are passed to `TextReader` and then to `TextFileReader` where they don't seem to have an effect. It was decided to raise the exception at the `_parse_excel` level however, following suit with the handling of `chunksize` args."},"comment":{"url":"https://api.github.com/repos/pydata/pandas/issues/comments/166585415","html_url":"https://github.com/pydata/pandas/pull/11870#issuecomment-166585415","issue_url":"https://api.github.com/repos/pydata/pandas/issues/11870","id":166585415,"user":{"login":"jorisvandenbossche","id":1020496,"avatar_url":"https://avatars.githubusercontent.com/u/1020496?v=3","gravatar_id":"","url":"https://api.github.com/users/jorisvandenbossche","html_url":"https://github.com/jorisvandenbossche","followers_url":"https://api.github.com/users/jorisvandenbossche/followers","following_url":"https://api.github.com/users/jorisvandenbossche/following{/other_user}","gists_url":"https://api.github.com/users/jorisvandenbossche/gists{/gist_id}","starred_url":"https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jorisvandenbossche/subscriptions","organizations_url":"https://api.github.com/users/jorisvandenbossche/orgs","repos_url":"https://api.github.com/users/jorisvandenbossche/repos","events_url":"https://api.github.com/users/jorisvandenbossche/events{/privacy}","received_events_url":"https://api.github.com/users/jorisvandenbossche/received_events","type":"User","site_admin":false},"created_at":"2015-12-22T11:15:32Z","updated_at":"2015-12-22T11:15:32Z","body":"As a small example it actually does something:\r\n\r\n```\r\nIn [43]: dti = pd.date_range('2014-1-1', periods=10)\r\n\r\nIn [44]: df = pd.DataFrame({'dates':dti, 'strings':pd.Series(dti).astype(str)})\r\n\r\nIn [46]: df.to_excel('test.xlsx', index=False)\r\n\r\nIn [47]: pd.read_excel('test.xlsx').dtypes\r\nOut[47]:\r\ndates      datetime64[ns]\r\nstrings            object\r\ndtype: object\r\n\r\nIn [48]: pd.read_excel('test.xlsx', parse_dates=['strings']).dtypes\r\nOut[48]:\r\ndates      datetime64[ns]\r\nstrings    datetime64[ns]\r\ndtype: object\r\n```"}}