{"action":"created","comment":{"url":"https://api.github.com/repos/pandas-dev/pandas/pulls/comments/168753655","pull_request_review_id":97174516,"id":168753655,"diff_hunk":"@@ -301,6 +301,28 @@ This is also a valid argument to :meth:`DataFrame.append`:\n           labels=['df1', 'df4'], vertical=True);\n    plt.close('all');\n \n+.. _merging.assign:\n+\n+Concatenating using ``assign``\n+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n+\n+You can concatenate one Series to a DataFrame using the DataFrame method","path":"doc/source/merging.rst","position":9,"original_position":9,"commit_id":"742f4962a4e6f70621ff6b1949a3a86144967866","original_commit_id":"742f4962a4e6f70621ff6b1949a3a86144967866","user":{"login":"TomAugspurger","id":1312546,"avatar_url":"https://avatars3.githubusercontent.com/u/1312546?v=4","gravatar_id":"","url":"https://api.github.com/users/TomAugspurger","html_url":"https://github.com/TomAugspurger","followers_url":"https://api.github.com/users/TomAugspurger/followers","following_url":"https://api.github.com/users/TomAugspurger/following{/other_user}","gists_url":"https://api.github.com/users/TomAugspurger/gists{/gist_id}","starred_url":"https://api.github.com/users/TomAugspurger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TomAugspurger/subscriptions","organizations_url":"https://api.github.com/users/TomAugspurger/orgs","repos_url":"https://api.github.com/users/TomAugspurger/repos","events_url":"https://api.github.com/users/TomAugspurger/events{/privacy}","received_events_url":"https://api.github.com/users/TomAugspurger/received_events","type":"User","site_admin":false},"body":"I'm a bit worried about this phrasing, and the section title.\r\n\r\nConcatenation already has a well-defined meaning in pandas. This is similar, since `df[col] = series`, which is what `assign` is doing, will do alignment like `concat`, but it's different since you're only adding a single column.\r\n\r\nI'd almost prefer a simple like this at the start or end of the `concat` documentation that says something like \"concat combins many pandas objects into a single new one. If you want to to include a Series in a DataFrame as a new column, assign directly like ...\"","created_at":"2018-02-16T13:19:33Z","updated_at":"2018-02-16T13:19:33Z","html_url":"https://github.com/pandas-dev/pandas/pull/18665#discussion_r168753655","pull_request_url":"https://api.github.com/repos/pandas-dev/pandas/pulls/18665","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/pandas-dev/pandas/pulls/comments/168753655"},"html":{"href":"https://github.com/pandas-dev/pandas/pull/18665#discussion_r168753655"},"pull_request":{"href":"https://api.github.com/repos/pandas-dev/pandas/pulls/18665"}}},"pull_request":{"url":"https://api.github.com/repos/pandas-dev/pandas/pulls/18665","id":156790766,"html_url":"https://github.com/pandas-dev/pandas/pull/18665","diff_url":"https://github.com/pandas-dev/pandas/pull/18665.diff","patch_url":"https://github.com/pandas-dev/pandas/pull/18665.patch","issue_url":"https://api.github.com/repos/pandas-dev/pandas/issues/18665","number":18665,"state":"open","locked":false,"title":"DOC: added a reference to DataFrame assign in concatenate section of merging","user":{"login":"obilodeau","id":546325,"avatar_url":"https://avatars2.githubusercontent.com/u/546325?v=4","gravatar_id":"","url":"https://api.github.com/users/obilodeau","html_url":"https://github.com/obilodeau","followers_url":"https://api.github.com/users/obilodeau/followers","following_url":"https://api.github.com/users/obilodeau/following{/other_user}","gists_url":"https://api.github.com/users/obilodeau/gists{/gist_id}","starred_url":"https://api.github.com/users/obilodeau/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/obilodeau/subscriptions","organizations_url":"https://api.github.com/users/obilodeau/orgs","repos_url":"https://api.github.com/users/obilodeau/repos","events_url":"https://api.github.com/users/obilodeau/events{/privacy}","received_events_url":"https://api.github.com/users/obilodeau/received_events","type":"User","site_admin":false},"body":"Because of various stack overflow answers we are directed to the merging\r\npage where a link to DataFrame.assign would be better. Adding the\r\nreference here will make people's code better. At least it would have\r\nfor me.\r\n\r\n- [ ] tests added / passed\r\n- [x] passes `git diff upstream/master -u -- \"*.py\" | flake8 --diff`\r\n- [x] whatsnew entry\r\n\r\nFor tests, we'll see with CI.","created_at":"2017-12-06T17:24:35Z","updated_at":"2018-02-16T13:19:33Z","closed_at":null,"merged_at":null,"merge_commit_sha":"26dff84c867f771127627a6d19c7f1c69d69ae45","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[{"id":134699,"url":"https://api.github.com/repos/pandas-dev/pandas/labels/Docs","name":"Docs","color":"3465A4","default":false},{"id":13098779,"url":"https://api.github.com/repos/pandas-dev/pandas/labels/Reshaping","name":"Reshaping","color":"02d7e1","default":false}],"milestone":{"url":"https://api.github.com/repos/pandas-dev/pandas/milestones/53","html_url":"https://github.com/pandas-dev/pandas/milestone/53","labels_url":"https://api.github.com/repos/pandas-dev/pandas/milestones/53/labels","id":2853937,"number":53,"title":"0.23.0","description":"after 0.22","creator":{"login":"jreback","id":953992,"avatar_url":"https://avatars2.githubusercontent.com/u/953992?v=4","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":108,"closed_issues":892,"state":"open","created_at":"2017-10-20T10:17:09Z","updated_at":"2018-02-16T13:07:40Z","due_on":"2018-03-31T07:00:00Z","closed_at":null},"commits_url":"https://api.github.com/repos/pandas-dev/pandas/pulls/18665/commits","review_comments_url":"https://api.github.com/repos/pandas-dev/pandas/pulls/18665/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/18665/comments","statuses_url":"https://api.github.com/repos/pandas-dev/pandas/statuses/742f4962a4e6f70621ff6b1949a3a86144967866","head":{"label":"GoSecure:doc-assign-ref","ref":"doc-assign-ref","sha":"742f4962a4e6f70621ff6b1949a3a86144967866","user":{"login":"GoSecure","id":16034225,"avatar_url":"https://avatars1.githubusercontent.com/u/16034225?v=4","gravatar_id":"","url":"https://api.github.com/users/GoSecure","html_url":"https://github.com/GoSecure","followers_url":"https://api.github.com/users/GoSecure/followers","following_url":"https://api.github.com/users/GoSecure/following{/other_user}","gists_url":"https://api.github.com/users/GoSecure/gists{/gist_id}","starred_url":"https://api.github.com/users/GoSecure/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GoSecure/subscriptions","organizations_url":"https://api.github.com/users/GoSecure/orgs","repos_url":"https://api.github.com/users/GoSecure/repos","events_url":"https://api.github.com/users/GoSecure/events{/privacy}","received_events_url":"https://api.github.com/users/GoSecure/received_events","type":"Organization","site_admin":false},"repo":{"id":113345287,"name":"pandas","full_name":"GoSecure/pandas","owner":{"login":"GoSecure","id":16034225,"avatar_url":"https://avatars1.githubusercontent.com/u/16034225?v=4","gravatar_id":"","url":"https://api.github.com/users/GoSecure","html_url":"https://github.com/GoSecure","followers_url":"https://api.github.com/users/GoSecure/followers","following_url":"https://api.github.com/users/GoSecure/following{/other_user}","gists_url":"https://api.github.com/users/GoSecure/gists{/gist_id}","starred_url":"https://api.github.com/users/GoSecure/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GoSecure/subscriptions","organizations_url":"https://api.github.com/users/GoSecure/orgs","repos_url":"https://api.github.com/users/GoSecure/repos","events_url":"https://api.github.com/users/GoSecure/events{/privacy}","received_events_url":"https://api.github.com/users/GoSecure/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/GoSecure/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/GoSecure/pandas","forks_url":"https://api.github.com/repos/GoSecure/pandas/forks","keys_url":"https://api.github.com/repos/GoSecure/pandas/keys{/key_id}","collaborators_url":"https://api.github.com/repos/GoSecure/pandas/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/GoSecure/pandas/teams","hooks_url":"https://api.github.com/repos/GoSecure/pandas/hooks","issue_events_url":"https://api.github.com/repos/GoSecure/pandas/issues/events{/number}","events_url":"https://api.github.com/repos/GoSecure/pandas/events","assignees_url":"https://api.github.com/repos/GoSecure/pandas/assignees{/user}","branches_url":"https://api.github.com/repos/GoSecure/pandas/branches{/branch}","tags_url":"https://api.github.com/repos/GoSecure/pandas/tags","blobs_url":"https://api.github.com/repos/GoSecure/pandas/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/GoSecure/pandas/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/GoSecure/pandas/git/refs{/sha}","trees_url":"https://api.github.com/repos/GoSecure/pandas/git/trees{/sha}","statuses_url":"https://api.github.com/repos/GoSecure/pandas/statuses/{sha}","languages_url":"https://api.github.com/repos/GoSecure/pandas/languages","stargazers_url":"https://api.github.com/repos/GoSecure/pandas/stargazers","contributors_url":"https://api.github.com/repos/GoSecure/pandas/contributors","subscribers_url":"https://api.github.com/repos/GoSecure/pandas/subscribers","subscription_url":"https://api.github.com/repos/GoSecure/pandas/subscription","commits_url":"https://api.github.com/repos/GoSecure/pandas/commits{/sha}","git_commits_url":"https://api.github.com/repos/GoSecure/pandas/git/commits{/sha}","comments_url":"https://api.github.com/repos/GoSecure/pandas/comments{/number}","issue_comment_url":"https://api.github.com/repos/GoSecure/pandas/issues/comments{/number}","contents_url":"https://api.github.com/repos/GoSecure/pandas/contents/{+path}","compare_url":"https://api.github.com/repos/GoSecure/pandas/compare/{base}...{head}","merges_url":"https://api.github.com/repos/GoSecure/pandas/merges","archive_url":"https://api.github.com/repos/GoSecure/pandas/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/GoSecure/pandas/downloads","issues_url":"https://api.github.com/repos/GoSecure/pandas/issues{/number}","pulls_url":"https://api.github.com/repos/GoSecure/pandas/pulls{/number}","milestones_url":"https://api.github.com/repos/GoSecure/pandas/milestones{/number}","notifications_url":"https://api.github.com/repos/GoSecure/pandas/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/GoSecure/pandas/labels{/name}","releases_url":"https://api.github.com/repos/GoSecure/pandas/releases{/id}","deployments_url":"https://api.github.com/repos/GoSecure/pandas/deployments","created_at":"2017-12-06T17:12:52Z","updated_at":"2017-12-06T17:12:58Z","pushed_at":"2018-02-15T15:52:54Z","git_url":"git://github.com/GoSecure/pandas.git","ssh_url":"git@github.com:GoSecure/pandas.git","clone_url":"https://github.com/GoSecure/pandas.git","svn_url":"https://github.com/GoSecure/pandas","homepage":"http://pandas.pydata.org","size":116232,"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,"archived":false,"open_issues_count":0,"license":null,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"pandas-dev:master","ref":"master","sha":"2fdf1e256e5e0b7f1fe909629e2f0b7893c8c7c3","user":{"login":"pandas-dev","id":21206976,"avatar_url":"https://avatars2.githubusercontent.com/u/21206976?v=4","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://avatars2.githubusercontent.com/u/21206976?v=4","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":"2018-02-16T12:16:27Z","pushed_at":"2018-02-16T11:56:39Z","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":116608,"stargazers_count":12886,"watchers_count":12886,"language":"Python","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":5001,"mirror_url":null,"archived":false,"open_issues_count":2337,"license":{"key":"bsd-3-clause","name":"BSD 3-Clause \"New\" or \"Revised\" License","spdx_id":"BSD-3-Clause","url":"https://api.github.com/licenses/bsd-3-clause"},"forks":5001,"open_issues":2337,"watchers":12886,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/pandas-dev/pandas/pulls/18665"},"html":{"href":"https://github.com/pandas-dev/pandas/pull/18665"},"issue":{"href":"https://api.github.com/repos/pandas-dev/pandas/issues/18665"},"comments":{"href":"https://api.github.com/repos/pandas-dev/pandas/issues/18665/comments"},"review_comments":{"href":"https://api.github.com/repos/pandas-dev/pandas/pulls/18665/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/18665/commits"},"statuses":{"href":"https://api.github.com/repos/pandas-dev/pandas/statuses/742f4962a4e6f70621ff6b1949a3a86144967866"}},"author_association":"NONE"}}
{"actor":{"display_login":"TomAugspurger"}}