{"action":"created","comment":{"url":"https://api.github.com/repos/pandas-dev/pandas/pulls/comments/111795687","pull_request_review_id":33062018,"id":111795687,"diff_hunk":"@@ -136,8 +136,14 @@ def pivot_table(data, values=None, index=None, columns=None, aggfunc='mean',\n \n     table = agged\n     if table.index.nlevels > 1:\n-        to_unstack = [agged.index.names[i] or i\n-                      for i in range(len(index), len(keys))]\n+        index_names = agged.index.names[:len(index)]","path":"pandas/tools/pivot.py","position":6,"original_position":6,"commit_id":"c0435e843495dc9e58f35241789f6e3fdff33ef8","original_commit_id":"c0435e843495dc9e58f35241789f6e3fdff33ef8","user":{"login":"mroeschke","id":10647082,"avatar_url":"https://avatars3.githubusercontent.com/u/10647082?v=3","gravatar_id":"","url":"https://api.github.com/users/mroeschke","html_url":"https://github.com/mroeschke","followers_url":"https://api.github.com/users/mroeschke/followers","following_url":"https://api.github.com/users/mroeschke/following{/other_user}","gists_url":"https://api.github.com/users/mroeschke/gists{/gist_id}","starred_url":"https://api.github.com/users/mroeschke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mroeschke/subscriptions","organizations_url":"https://api.github.com/users/mroeschke/orgs","repos_url":"https://api.github.com/users/mroeschke/repos","events_url":"https://api.github.com/users/mroeschke/events{/privacy}","received_events_url":"https://api.github.com/users/mroeschke/received_events","type":"User","site_admin":false},"body":"I tried this originally but some tests were failing because the MultiIndex names can also be ints. Looks like unstack first prioritizes index name if they aren't None and then defaults to index position by integer\r\n\r\n```\r\nIn [19]: index = pd.MultiIndex.from_tuples([('one', 'a'), ('one', 'b'),\r\n    ...: ...                                    ('two', 'a'), ('two', 'b'\r\n    ...: )])\r\n\r\nIn [20]: s = pd.Series(np.arange(1.0, 5.0), index=index)\r\n\r\nIn [21]: s\r\nOut[21]:\r\none  a    1.0\r\n     b    2.0\r\ntwo  a    3.0\r\n     b    4.0\r\ndtype: float64\r\n\r\nIn [22]: s.unstack(0)\r\nOut[22]:\r\n   one  two\r\na  1.0  3.0\r\nb  2.0  4.0\r\n\r\nIn [24]: s.index.names= [1,0]\r\n\r\nIn [25]: s.unstack(0)\r\nOut[25]:\r\n0      a    b\r\n1\r\none  1.0  2.0\r\ntwo  3.0  4.0\r\n```","created_at":"2017-04-17T18:49:27Z","updated_at":"2017-04-17T18:49:27Z","html_url":"https://github.com/pandas-dev/pandas/pull/16028#discussion_r111795687","pull_request_url":"https://api.github.com/repos/pandas-dev/pandas/pulls/16028","_links":{"self":{"href":"https://api.github.com/repos/pandas-dev/pandas/pulls/comments/111795687"},"html":{"href":"https://github.com/pandas-dev/pandas/pull/16028#discussion_r111795687"},"pull_request":{"href":"https://api.github.com/repos/pandas-dev/pandas/pulls/16028"}}},"pull_request":{"url":"https://api.github.com/repos/pandas-dev/pandas/pulls/16028","id":116091489,"html_url":"https://github.com/pandas-dev/pandas/pull/16028","diff_url":"https://github.com/pandas-dev/pandas/pull/16028.diff","patch_url":"https://github.com/pandas-dev/pandas/pull/16028.patch","issue_url":"https://api.github.com/repos/pandas-dev/pandas/issues/16028","number":16028,"state":"open","locked":false,"title":"BUG: Allow Series with same name with crosstab (#13279)","user":{"login":"mroeschke","id":10647082,"avatar_url":"https://avatars3.githubusercontent.com/u/10647082?v=3","gravatar_id":"","url":"https://api.github.com/users/mroeschke","html_url":"https://github.com/mroeschke","followers_url":"https://api.github.com/users/mroeschke/followers","following_url":"https://api.github.com/users/mroeschke/following{/other_user}","gists_url":"https://api.github.com/users/mroeschke/gists{/gist_id}","starred_url":"https://api.github.com/users/mroeschke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mroeschke/subscriptions","organizations_url":"https://api.github.com/users/mroeschke/orgs","repos_url":"https://api.github.com/users/mroeschke/repos","events_url":"https://api.github.com/users/mroeschke/events{/privacy}","received_events_url":"https://api.github.com/users/mroeschke/received_events","type":"User","site_admin":false},"body":" - [x] closes #13279\r\n - [x] tests added / passed\r\n - [x] passes ``git diff upstream/master --name-only -- '*.py' | flake8 --diff``\r\n - [x] whatsnew entry\r\n\r\nBefore, passing two `Series` with the same name in `crosstab` raised a `KeyError` because of a block in `pivot_table` that tried to unstack a `MultiIndex` with duplicate names. ","created_at":"2017-04-17T04:58:07Z","updated_at":"2017-04-17T18:49:27Z","closed_at":null,"merged_at":null,"merge_commit_sha":"910189d7eca12c3c06b895a19b22f46667c06c0f","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/pandas-dev/pandas/pulls/16028/commits","review_comments_url":"https://api.github.com/repos/pandas-dev/pandas/pulls/16028/comments","review_comment_url":"https://api.github.com/repos/pandas-dev/pandas/pulls/comments{/number}","comments_url":"https://api.github.com/repos/pandas-dev/pandas/issues/16028/comments","statuses_url":"https://api.github.com/repos/pandas-dev/pandas/statuses/c0435e843495dc9e58f35241789f6e3fdff33ef8","head":{"label":"mroeschke:fix_13279","ref":"fix_13279","sha":"c0435e843495dc9e58f35241789f6e3fdff33ef8","user":{"login":"mroeschke","id":10647082,"avatar_url":"https://avatars3.githubusercontent.com/u/10647082?v=3","gravatar_id":"","url":"https://api.github.com/users/mroeschke","html_url":"https://github.com/mroeschke","followers_url":"https://api.github.com/users/mroeschke/followers","following_url":"https://api.github.com/users/mroeschke/following{/other_user}","gists_url":"https://api.github.com/users/mroeschke/gists{/gist_id}","starred_url":"https://api.github.com/users/mroeschke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mroeschke/subscriptions","organizations_url":"https://api.github.com/users/mroeschke/orgs","repos_url":"https://api.github.com/users/mroeschke/repos","events_url":"https://api.github.com/users/mroeschke/events{/privacy}","received_events_url":"https://api.github.com/users/mroeschke/received_events","type":"User","site_admin":false},"repo":{"id":71015224,"name":"pandas","full_name":"mroeschke/pandas","owner":{"login":"mroeschke","id":10647082,"avatar_url":"https://avatars3.githubusercontent.com/u/10647082?v=3","gravatar_id":"","url":"https://api.github.com/users/mroeschke","html_url":"https://github.com/mroeschke","followers_url":"https://api.github.com/users/mroeschke/followers","following_url":"https://api.github.com/users/mroeschke/following{/other_user}","gists_url":"https://api.github.com/users/mroeschke/gists{/gist_id}","starred_url":"https://api.github.com/users/mroeschke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mroeschke/subscriptions","organizations_url":"https://api.github.com/users/mroeschke/orgs","repos_url":"https://api.github.com/users/mroeschke/repos","events_url":"https://api.github.com/users/mroeschke/events{/privacy}","received_events_url":"https://api.github.com/users/mroeschke/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/mroeschke/pandas","description":"Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more","fork":true,"url":"https://api.github.com/repos/mroeschke/pandas","forks_url":"https://api.github.com/repos/mroeschke/pandas/forks","keys_url":"https://api.github.com/repos/mroeschke/pandas/keys{/key_id}","collaborators_url":"https://api.github.com/repos/mroeschke/pandas/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/mroeschke/pandas/teams","hooks_url":"https://api.github.com/repos/mroeschke/pandas/hooks","issue_events_url":"https://api.github.com/repos/mroeschke/pandas/issues/events{/number}","events_url":"https://api.github.com/repos/mroeschke/pandas/events","assignees_url":"https://api.github.com/repos/mroeschke/pandas/assignees{/user}","branches_url":"https://api.github.com/repos/mroeschke/pandas/branches{/branch}","tags_url":"https://api.github.com/repos/mroeschke/pandas/tags","blobs_url":"https://api.github.com/repos/mroeschke/pandas/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/mroeschke/pandas/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/mroeschke/pandas/git/refs{/sha}","trees_url":"https://api.github.com/repos/mroeschke/pandas/git/trees{/sha}","statuses_url":"https://api.github.com/repos/mroeschke/pandas/statuses/{sha}","languages_url":"https://api.github.com/repos/mroeschke/pandas/languages","stargazers_url":"https://api.github.com/repos/mroeschke/pandas/stargazers","contributors_url":"https://api.github.com/repos/mroeschke/pandas/contributors","subscribers_url":"https://api.github.com/repos/mroeschke/pandas/subscribers","subscription_url":"https://api.github.com/repos/mroeschke/pandas/subscription","commits_url":"https://api.github.com/repos/mroeschke/pandas/commits{/sha}","git_commits_url":"https://api.github.com/repos/mroeschke/pandas/git/commits{/sha}","comments_url":"https://api.github.com/repos/mroeschke/pandas/comments{/number}","issue_comment_url":"https://api.github.com/repos/mroeschke/pandas/issues/comments{/number}","contents_url":"https://api.github.com/repos/mroeschke/pandas/contents/{+path}","compare_url":"https://api.github.com/repos/mroeschke/pandas/compare/{base}...{head}","merges_url":"https://api.github.com/repos/mroeschke/pandas/merges","archive_url":"https://api.github.com/repos/mroeschke/pandas/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/mroeschke/pandas/downloads","issues_url":"https://api.github.com/repos/mroeschke/pandas/issues{/number}","pulls_url":"https://api.github.com/repos/mroeschke/pandas/pulls{/number}","milestones_url":"https://api.github.com/repos/mroeschke/pandas/milestones{/number}","notifications_url":"https://api.github.com/repos/mroeschke/pandas/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/mroeschke/pandas/labels{/name}","releases_url":"https://api.github.com/repos/mroeschke/pandas/releases{/id}","deployments_url":"https://api.github.com/repos/mroeschke/pandas/deployments","created_at":"2016-10-15T21:46:32Z","updated_at":"2016-10-15T21:46:38Z","pushed_at":"2017-04-17T04:49:37Z","git_url":"git://github.com/mroeschke/pandas.git","ssh_url":"git@github.com:mroeschke/pandas.git","clone_url":"https://github.com/mroeschke/pandas.git","svn_url":"https://github.com/mroeschke/pandas","homepage":"http://pandas.pydata.org","size":93660,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"pandas-dev:master","ref":"master","sha":"5146b5971324009873cf1a54c8f0828de63874ae","user":{"login":"pandas-dev","id":21206976,"avatar_url":"https://avatars1.githubusercontent.com/u/21206976?v=3","gravatar_id":"","url":"https://api.github.com/users/pandas-dev","html_url":"https://github.com/pandas-dev","followers_url":"https://api.github.com/users/pandas-dev/followers","following_url":"https://api.github.com/users/pandas-dev/following{/other_user}","gists_url":"https://api.github.com/users/pandas-dev/gists{/gist_id}","starred_url":"https://api.github.com/users/pandas-dev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pandas-dev/subscriptions","organizations_url":"https://api.github.com/users/pandas-dev/orgs","repos_url":"https://api.github.com/users/pandas-dev/repos","events_url":"https://api.github.com/users/pandas-dev/events{/privacy}","received_events_url":"https://api.github.com/users/pandas-dev/received_events","type":"Organization","site_admin":false},"repo":{"id":858127,"name":"pandas","full_name":"pandas-dev/pandas","owner":{"login":"pandas-dev","id":21206976,"avatar_url":"https://avatars1.githubusercontent.com/u/21206976?v=3","gravatar_id":"","url":"https://api.github.com/users/pandas-dev","html_url":"https://github.com/pandas-dev","followers_url":"https://api.github.com/users/pandas-dev/followers","following_url":"https://api.github.com/users/pandas-dev/following{/other_user}","gists_url":"https://api.github.com/users/pandas-dev/gists{/gist_id}","starred_url":"https://api.github.com/users/pandas-dev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pandas-dev/subscriptions","organizations_url":"https://api.github.com/users/pandas-dev/orgs","repos_url":"https://api.github.com/users/pandas-dev/repos","events_url":"https://api.github.com/users/pandas-dev/events{/privacy}","received_events_url":"https://api.github.com/users/pandas-dev/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/pandas-dev/pandas","description":"Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more","fork":false,"url":"https://api.github.com/repos/pandas-dev/pandas","forks_url":"https://api.github.com/repos/pandas-dev/pandas/forks","keys_url":"https://api.github.com/repos/pandas-dev/pandas/keys{/key_id}","collaborators_url":"https://api.github.com/repos/pandas-dev/pandas/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/pandas-dev/pandas/teams","hooks_url":"https://api.github.com/repos/pandas-dev/pandas/hooks","issue_events_url":"https://api.github.com/repos/pandas-dev/pandas/issues/events{/number}","events_url":"https://api.github.com/repos/pandas-dev/pandas/events","assignees_url":"https://api.github.com/repos/pandas-dev/pandas/assignees{/user}","branches_url":"https://api.github.com/repos/pandas-dev/pandas/branches{/branch}","tags_url":"https://api.github.com/repos/pandas-dev/pandas/tags","blobs_url":"https://api.github.com/repos/pandas-dev/pandas/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/pandas-dev/pandas/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/pandas-dev/pandas/git/refs{/sha}","trees_url":"https://api.github.com/repos/pandas-dev/pandas/git/trees{/sha}","statuses_url":"https://api.github.com/repos/pandas-dev/pandas/statuses/{sha}","languages_url":"https://api.github.com/repos/pandas-dev/pandas/languages","stargazers_url":"https://api.github.com/repos/pandas-dev/pandas/stargazers","contributors_url":"https://api.github.com/repos/pandas-dev/pandas/contributors","subscribers_url":"https://api.github.com/repos/pandas-dev/pandas/subscribers","subscription_url":"https://api.github.com/repos/pandas-dev/pandas/subscription","commits_url":"https://api.github.com/repos/pandas-dev/pandas/commits{/sha}","git_commits_url":"https://api.github.com/repos/pandas-dev/pandas/git/commits{/sha}","comments_url":"https://api.github.com/repos/pandas-dev/pandas/comments{/number}","issue_comment_url":"https://api.github.com/repos/pandas-dev/pandas/issues/comments{/number}","contents_url":"https://api.github.com/repos/pandas-dev/pandas/contents/{+path}","compare_url":"https://api.github.com/repos/pandas-dev/pandas/compare/{base}...{head}","merges_url":"https://api.github.com/repos/pandas-dev/pandas/merges","archive_url":"https://api.github.com/repos/pandas-dev/pandas/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/pandas-dev/pandas/downloads","issues_url":"https://api.github.com/repos/pandas-dev/pandas/issues{/number}","pulls_url":"https://api.github.com/repos/pandas-dev/pandas/pulls{/number}","milestones_url":"https://api.github.com/repos/pandas-dev/pandas/milestones{/number}","notifications_url":"https://api.github.com/repos/pandas-dev/pandas/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/pandas-dev/pandas/labels{/name}","releases_url":"https://api.github.com/repos/pandas-dev/pandas/releases{/id}","deployments_url":"https://api.github.com/repos/pandas-dev/pandas/deployments","created_at":"2010-08-24T01:37:33Z","updated_at":"2017-04-17T15:07:17Z","pushed_at":"2017-04-17T18:04:52Z","git_url":"git://github.com/pandas-dev/pandas.git","ssh_url":"git@github.com:pandas-dev/pandas.git","clone_url":"https://github.com/pandas-dev/pandas.git","svn_url":"https://github.com/pandas-dev/pandas","homepage":"http://pandas.pydata.org","size":94142,"stargazers_count":9292,"watchers_count":9292,"language":"Python","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":3681,"mirror_url":null,"open_issues_count":1905,"forks":3681,"open_issues":1905,"watchers":9292,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/pandas-dev/pandas/pulls/16028"},"html":{"href":"https://github.com/pandas-dev/pandas/pull/16028"},"issue":{"href":"https://api.github.com/repos/pandas-dev/pandas/issues/16028"},"comments":{"href":"https://api.github.com/repos/pandas-dev/pandas/issues/16028/comments"},"review_comments":{"href":"https://api.github.com/repos/pandas-dev/pandas/pulls/16028/comments"},"review_comment":{"href":"https://api.github.com/repos/pandas-dev/pandas/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/pandas-dev/pandas/pulls/16028/commits"},"statuses":{"href":"https://api.github.com/repos/pandas-dev/pandas/statuses/c0435e843495dc9e58f35241789f6e3fdff33ef8"}}}}
{"actor":{"display_login":"mroeschke"}}