{"action":"created","issue":{"url":"https://api.github.com/repos/pydata/pandas/issues/12932","repository_url":"https://api.github.com/repos/pydata/pandas","labels_url":"https://api.github.com/repos/pydata/pandas/issues/12932/labels{/name}","comments_url":"https://api.github.com/repos/pydata/pandas/issues/12932/comments","events_url":"https://api.github.com/repos/pydata/pandas/issues/12932/events","html_url":"https://github.com/pydata/pandas/pull/12932","id":149763637,"number":12932,"title":"More examples  comparison with sql","user":{"login":"maxu777","id":11424941,"avatar_url":"https://avatars.githubusercontent.com/u/11424941?v=3","gravatar_id":"","url":"https://api.github.com/users/maxu777","html_url":"https://github.com/maxu777","followers_url":"https://api.github.com/users/maxu777/followers","following_url":"https://api.github.com/users/maxu777/following{/other_user}","gists_url":"https://api.github.com/users/maxu777/gists{/gist_id}","starred_url":"https://api.github.com/users/maxu777/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maxu777/subscriptions","organizations_url":"https://api.github.com/users/maxu777/orgs","repos_url":"https://api.github.com/users/maxu777/repos","events_url":"https://api.github.com/users/maxu777/events{/privacy}","received_events_url":"https://api.github.com/users/maxu777/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pydata/pandas/labels/Docs","name":"Docs","color":"3465A4"},{"url":"https://api.github.com/repos/pydata/pandas/labels/IO%20SQL","name":"IO SQL","color":"5319e7"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2016-04-20T13:11:53Z","updated_at":"2016-04-20T13:48:39Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/pydata/pandas/pulls/12932","html_url":"https://github.com/pydata/pandas/pull/12932","diff_url":"https://github.com/pydata/pandas/pull/12932.diff","patch_url":"https://github.com/pydata/pandas/pull/12932.patch"},"body":" - [ ] closes #xxxx\r\n - [ ] tests added / passed\r\n - [x] passes ``git diff upstream/master | flake8 --diff``\r\n - [x] whatsnew entry\r\n\r\nadded the following examples:\r\n - Top N rows with offset\r\n - Top N rows per group\r\n - ROW_NUMBER() OVER(PARTITION BY day ORDER BY total_bill DESC)\r\n - UPDATE\r\n - DELETE\r\n"},"comment":{"url":"https://api.github.com/repos/pydata/pandas/issues/comments/212432498","html_url":"https://github.com/pydata/pandas/pull/12932#issuecomment-212432498","issue_url":"https://api.github.com/repos/pydata/pandas/issues/12932","id":212432498,"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-04-20T13:48:39Z","updated_at":"2016-04-20T13:48:39Z","body":"just rebase on master\r\n\r\n``git rebase -i origin/master``"}}