{"id":27425,"date":"2024-03-16T08:27:13","date_gmt":"2024-03-16T08:27:13","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/"},"modified":"2024-03-22T11:00:27","modified_gmt":"2024-03-22T11:00:27","slug":"how-can-pandas-assign-values-to-one-column-based-on-another-column","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/","title":{"rendered":"How can pandas assign values to one column based on another column?"},"content":{"rendered":"<p>To assign values from one column to another column in Pandas, you can use the .loc method. Below is an example illustrating how to assign values to another column based on the values in one column.<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">import<\/span> pandas <span class=\"hljs-keyword\">as<\/span> pd\r\n\r\n<span class=\"hljs-comment\"># \u521b\u5efa\u4e00\u4e2a\u793a\u4f8bDataFrame<\/span>\r\ndata = {<span class=\"hljs-string\">'A'<\/span>: [<span class=\"hljs-number\">1<\/span>, <span class=\"hljs-number\">2<\/span>, <span class=\"hljs-number\">3<\/span>, <span class=\"hljs-number\">4<\/span>, <span class=\"hljs-number\">5<\/span>],\r\n        <span class=\"hljs-string\">'B'<\/span>: [<span class=\"hljs-number\">6<\/span>, <span class=\"hljs-number\">7<\/span>, <span class=\"hljs-number\">8<\/span>, <span class=\"hljs-number\">9<\/span>, <span class=\"hljs-number\">10<\/span>]}\r\ndf = pd.DataFrame(data)\r\n\r\n<span class=\"hljs-comment\"># \u6839\u636e\u5217'A'\u7684\u503c\uff0c\u5c06\u5217'B'\u7684\u503c\u8bbe\u7f6e\u4e3a\u65b0\u7684\u503c<\/span>\r\ndf.loc[df[<span class=\"hljs-string\">'A'<\/span>] &gt; <span class=\"hljs-number\">3<\/span>, <span class=\"hljs-string\">'B'<\/span>] = <span class=\"hljs-number\">0<\/span>\r\n\r\n<span class=\"hljs-built_in\">print<\/span>(df)\r\n<\/code><\/pre>\n<p>The output is as follows:<\/p>\n<pre class=\"post-pre\"><code>   A  B\r\n0  1  6\r\n1  2  7\r\n2  3  8\r\n3  4  0\r\n4  5  0\r\n<\/code><\/pre>\n<p>In the example above, we first created a DataFrame with two columns. Then, we used the .loc method to select rows where the value in column &#8216;A&#8217; is greater than 3 and set the value in column &#8216;B&#8217; to 0.<\/p>\n<p>Please note that this method will directly modify the original DataFrame without creating a new DataFrame. If you want to create a new DataFrame without altering the original one, you can use the .copy() method to create a copy of the DataFrame and then perform operations on the copy.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To assign values from one column to another column in Pandas, you can use the .loc method. Below is an example illustrating how to assign values to another column based on the values in one column. import pandas as pd # \u521b\u5efa\u4e00\u4e2a\u793a\u4f8bDataFrame data = {&#8216;A&#8217;: [1, 2, 3, 4, 5], &#8216;B&#8217;: [6, 7, 8, 9, [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-27425","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How can pandas assign values to one column based on another column? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can pandas assign values to one column based on another column?\" \/>\n<meta property=\"og:description\" content=\"To assign values from one column to another column in Pandas, you can use the .loc method. Below is an example illustrating how to assign values to another column based on the values in one column. import pandas as pd # \u521b\u5efa\u4e00\u4e2a\u793a\u4f8bDataFrame data = {&#039;A&#039;: [1, 2, 3, 4, 5], &#039;B&#039;: [6, 7, 8, 9, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T08:27:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T11:00:27+00:00\" \/>\n<meta name=\"author\" content=\"Ava Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ava Mitchell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/\"},\"author\":{\"name\":\"Ava Mitchell\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\"},\"headline\":\"How can pandas assign values to one column based on another column?\",\"datePublished\":\"2024-03-16T08:27:13+00:00\",\"dateModified\":\"2024-03-22T11:00:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/\"},\"wordCount\":140,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/\",\"name\":\"How can pandas assign values to one column based on another column? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T08:27:13+00:00\",\"dateModified\":\"2024-03-22T11:00:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can pandas assign values to one column based on another column?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\",\"name\":\"Ava Mitchell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"caption\":\"Ava Mitchell\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How can pandas assign values to one column based on another column? - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/","og_locale":"en_US","og_type":"article","og_title":"How can pandas assign values to one column based on another column?","og_description":"To assign values from one column to another column in Pandas, you can use the .loc method. Below is an example illustrating how to assign values to another column based on the values in one column. import pandas as pd # \u521b\u5efa\u4e00\u4e2a\u793a\u4f8bDataFrame data = {'A': [1, 2, 3, 4, 5], 'B': [6, 7, 8, 9, [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T08:27:13+00:00","article_modified_time":"2024-03-22T11:00:27+00:00","author":"Ava Mitchell","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Ava Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/"},"author":{"name":"Ava Mitchell","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64"},"headline":"How can pandas assign values to one column based on another column?","datePublished":"2024-03-16T08:27:13+00:00","dateModified":"2024-03-22T11:00:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/"},"wordCount":140,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/","name":"How can pandas assign values to one column based on another column? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T08:27:13+00:00","dateModified":"2024-03-22T11:00:27+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-pandas-assign-values-to-one-column-based-on-another-column\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How can pandas assign values to one column based on another column?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64","name":"Ava Mitchell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","caption":"Ava Mitchell"},"url":"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=27425"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27425\/revisions"}],"predecessor-version":[{"id":61656,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27425\/revisions\/61656"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=27425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=27425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=27425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}