{"action":"closed","issue":{"url":"https://api.github.com/repos/pydata/pandas/issues/10747","labels_url":"https://api.github.com/repos/pydata/pandas/issues/10747/labels{/name}","comments_url":"https://api.github.com/repos/pydata/pandas/issues/10747/comments","events_url":"https://api.github.com/repos/pydata/pandas/issues/10747/events","html_url":"https://github.com/pydata/pandas/issues/10747","id":99020384,"number":10747,"title":"JSON: handling missing values in date coercion","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},"labels":[{"url":"https://api.github.com/repos/pydata/pandas/labels/Bug","name":"Bug","color":"e10c02"},{"url":"https://api.github.com/repos/pydata/pandas/labels/Difficulty%20Intermediate","name":"Difficulty Intermediate","color":"fbca04"},{"url":"https://api.github.com/repos/pydata/pandas/labels/Effort%20Low","name":"Effort Low","color":"006b75"},{"url":"https://api.github.com/repos/pydata/pandas/labels/IO%20JSON","name":"IO JSON","color":"207de5"},{"url":"https://api.github.com/repos/pydata/pandas/labels/Timeseries","name":"Timeseries","color":"AFEEEE"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/pydata/pandas/milestones/34","html_url":"https://github.com/pydata/pandas/milestones/0.17.0","labels_url":"https://api.github.com/repos/pydata/pandas/milestones/34/labels","id":1033710,"number":34,"title":"0.17.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":79,"closed_issues":337,"state":"open","created_at":"2015-03-23T10:47:38Z","updated_at":"2015-08-24T11:36:49Z","due_on":"2015-08-31T04:00:00Z","closed_at":null},"comments":1,"created_at":"2015-08-04T17:37:50Z","updated_at":"2015-08-24T11:36:49Z","closed_at":"2015-08-24T11:36:49Z","body":"xref https://github.com/pydata/pandas/issues/10746\r\n\r\n```\r\nIn [1]: data = '''\r\n   ...: [{\"id\": 1, \"timestamp\": 1036713600000},\r\n   ...:  {\"id\": 2}]\r\n   ...: '''\r\n```\r\n\r\nafter #10776 this is ok\r\n```\r\nIn [2]: pd.read_json(StringIO(data), orient='records', dtype={'id': 'int32', 'timestamp': 'datetime64[ms]'})\r\nOut[2]: \r\n   id     timestamp\r\n0   1  1.036714e+12\r\n1   2           NaN\r\n\r\nIn [2]: pd.read_json(StringIO(data), orient='records', dtype={'id': 'int32', 'timestamp': 'datetime64[ms]'})\r\nOut[10]: \r\n   id  timestamp\r\n0   1 2002-11-08\r\n1   2        NaT\r\n```\r\n\r\nstill open\r\n```\r\nIn [7]: pd.read_json(StringIO(data), orient='records', date_unit='ms')\r\nOut[7]: \r\n   id     timestamp\r\n0   1  1.036714e+12\r\n1   2           NaN\r\n```"}}