{"id":1732,"date":"2023-07-25T05:15:38","date_gmt":"2023-07-25T05:15:38","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-menggabungkan-dua-kolom\/"},"modified":"2023-07-25T05:15:38","modified_gmt":"2023-07-25T05:15:38","slug":"panda-menggabungkan-dua-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-menggabungkan-dua-kolom\/","title":{"rendered":"Cara menggabungkan dua kolom di pandas (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menggabungkan dua kolom teks menjadi satu di pandas DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[' <span style=\"color: #ff0000;\">new_column<\/span> '] = df[' <span style=\"color: #ff0000;\">column1<\/span> '] + df[' <span style=\"color: #ff0000;\">column2<\/span> ']\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Jika salah satu kolom belum menjadi string, Anda dapat mengonversinya menggunakan perintah <strong>astype(str)<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[' <span style=\"color: #ff0000;\">new_column<\/span> '] = df[' <span style=\"color: #ff0000;\">column1<\/span> ']. <span style=\"color: #3366ff;\">astype<\/span> ( <span style=\"color: #008000;\">str<\/span> )+df[' <span style=\"color: #ff0000;\">column2<\/span> ']<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dan Anda dapat menggunakan sintaks berikut untuk menggabungkan beberapa kolom teks menjadi satu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[' <span style=\"color: #ff0000;\">new_column<\/span> '] = df[[' <span style=\"color: #ff0000;\">col1<\/span> ', ' <span style=\"color: #ff0000;\">col2<\/span> ', ' <span style=\"color: #ff0000;\">col3<\/span> ', ...]]. <span style=\"color: #3366ff;\">agg<\/span> (' '. <span style=\"color: #3366ff;\">join<\/span> , axis= <span style=\"color: #008000;\">1<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggabungkan kolom teks dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Gabungkan dua kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menggabungkan dua kolom teks menjadi satu di pandas DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#create dataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['Mavs', 'Lakers', 'Spurs', 'Cavs'],\n                   ' <span style=\"color: #ff0000;\">first<\/span> ': ['Dirk', 'Kobe', 'Tim', 'Lebron'],\n                   ' <span style=\"color: #ff0000;\">last<\/span> ': ['Nowitzki', 'Bryant', 'Duncan', 'James'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [26, 31, 22, 29]})\n\n<span style=\"color: #008080;\">#combine first and last name column into new column, with space in between<\/span>\ndf[' <span style=\"color: #ff0000;\">full_name<\/span> '] = df[' <span style=\"color: #ff0000;\">first<\/span> '] + ' ' + df[' <span style=\"color: #ff0000;\">last<\/span> ']\n\n<span style=\"color: #008080;\">#view resulting dataFrame\n<span style=\"color: #000000;\">df<\/span>\n\n<span style=\"color: #000000;\">team first last<\/span> <span style=\"color: #000000;\">points full_name\n0 Mavs Dirk Nowitzki<\/span> <span style=\"color: #000000;\">26 Dirk Nowitzki\n1 Lakers Kobe Bryant<\/span> <span style=\"color: #000000;\">31 Kobe Bryant\n2 Spurs Tim Duncan<\/span> <span style=\"color: #000000;\">22 Tim Duncan\n3 Cavs LeBron James<\/span> <span style=\"color: #000000;\">29 LeBron James\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita telah menggabungkan kolom nama depan dan belakang dengan spasi di antaranya, namun kita juga dapat menggunakan pemisah lain seperti tanda hubung:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#combine first and last name column into new column, with dash in between<\/span>\ndf[' <span style=\"color: #ff0000;\">full_name<\/span> '] = df[' <span style=\"color: #ff0000;\">first<\/span> '] + ' <span style=\"color: #ff0000;\">-<\/span> ' + df[' <span style=\"color: #ff0000;\">last<\/span> ']\n\n<span style=\"color: #008080;\">#view resulting dataFrame\n<span style=\"color: #000000;\">df<\/span>\n\n<span style=\"color: #000000;\">team first last<\/span> <span style=\"color: #000000;\">points full_name\n0 Mavs Dirk Nowitzki<\/span> <span style=\"color: #000000;\">26 Dirk<\/span> - <span style=\"color: #000000;\">Nowitzki\n1 Lakers Kobe Bryant<\/span> <span style=\"color: #000000;\">31 Kobe<\/span> - <span style=\"color: #000000;\">Bryant\n2 Spurs Tim Duncan<\/span> <span style=\"color: #000000;\">22 Tim<\/span> - <span style=\"color: #000000;\">Duncan\n3 Cavs Lebron James<\/span> <span style=\"color: #000000;\">29 Lebron<\/span> - <span style=\"color: #000000;\">James<\/span><\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Konversi ke Teks dan Gabungkan Dua Kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengonversi kolom menjadi teks lalu menggabungkannya ke kolom lain:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#create dataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['Mavs', 'Lakers', 'Spurs', 'Cavs'],\n                   ' <span style=\"color: #ff0000;\">first<\/span> ': ['Dirk', 'Kobe', 'Tim', 'Lebron'],\n                   ' <span style=\"color: #ff0000;\">last<\/span> ': ['Nowitzki', 'Bryant', 'Duncan', 'James'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [26, 31, 22, 29]})\n\n<span style=\"color: #008080;\">#convert points to text, then join to last name column<\/span>\ndf[' <span style=\"color: #ff0000;\">name_points<\/span> '] = df[' <span style=\"color: #ff0000;\">last<\/span> '] + df[' <span style=\"color: #ff0000;\">points<\/span> ']. <span style=\"color: #3366ff;\">astype<\/span> ( <span style=\"color: #008000;\">str<\/span> )\n\n<span style=\"color: #008080;\">#view resulting dataFrame\n<span style=\"color: #000000;\">df<\/span>\n\n        <span style=\"color: #000000;\">team first last<\/span> <span style=\"color: #000000;\">points name_points\n0 Mavs Dirk Nowitzki<\/span> <span style=\"color: #000000;\">26 Nowitzki26\n1 Lakers Kobe Bryant<\/span> <span style=\"color: #000000;\">31 Bryant31\n2 Spurs Tim Duncan<\/span> <span style=\"color: #000000;\">22 Duncan22\n3 Cavs LeBron James<\/span> <span style=\"color: #000000;\">29 James29<\/span><\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Gabungkan lebih dari dua kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menggabungkan beberapa kolom menjadi satu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#create dataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['Mavs', 'Lakers', 'Spurs', 'Cavs'],\n                   ' <span style=\"color: #ff0000;\">first<\/span> ': ['Dirk', 'Kobe', 'Tim', 'Lebron'],\n                   ' <span style=\"color: #ff0000;\">last<\/span> ': ['Nowitzki', 'Bryant', 'Duncan', 'James'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [26, 31, 22, 29]})\n\n<span style=\"color: #008080;\">#join team, first name, and last name into one column<\/span>\ndf[' <span style=\"color: #ff0000;\">team_and_name<\/span> '] = df[[' <span style=\"color: #ff0000;\">team<\/span> ', ' <span style=\"color: #ff0000;\">first<\/span> ', ' <span style=\"color: #ff0000;\">last<\/span> ']]. <span style=\"color: #3366ff;\">agg<\/span> (' '. <span style=\"color: #3366ff;\">join<\/span> , axis= <span style=\"color: #008000;\">1<\/span> )\n\n<span style=\"color: #008080;\">#view resulting dataFrame\n<span style=\"color: #000000;\">df<\/span>\n\n<span style=\"color: #000000;\">team first last points team_name\n0 Mavs Dirk Nowitzki 26 Mavs Dirk Nowitzki\n1 Lakers Kobe Bryant 31 Lakers Kobe Bryant\n2 Spurs Tim Duncan 22 Spurs Tim Duncan\n3 Cavs Lebron James 29 Cavs Lebron James<\/span><\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/perbedaan-panda-antara-dua-kolom\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mencari selisih antara dua kolom<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/perbedaan-panda-antar-baris\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mencari perbedaan antara dua garis<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-mengurutkan-kolom-berdasarkan-nama\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mengurutkan kolom berdasarkan nama<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk menggabungkan dua kolom teks menjadi satu di pandas DataFrame: df[&#8216; new_column &#8216;] = df[&#8216; column1 &#8216;] + df[&#8216; column2 &#8216;] Jika salah satu kolom belum menjadi string, Anda dapat mengonversinya menggunakan perintah astype(str) : df[&#8216; new_column &#8216;] = df[&#8216; column1 &#8216;]. astype ( str )+df[&#8216; column2 &#8216;] Dan Anda [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Menggabungkan Dua Kolom di Pandas (Dengan Contoh)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggabungkan dua kolom dalam pandas DataFrame, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/panda-menggabungkan-dua-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggabungkan Dua Kolom di Pandas (Dengan Contoh)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggabungkan dua kolom dalam pandas DataFrame, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-menggabungkan-dua-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T05:15:38+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/panda-menggabungkan-dua-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-menggabungkan-dua-kolom\/\",\"name\":\"Cara Menggabungkan Dua Kolom di Pandas (Dengan Contoh)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T05:15:38+00:00\",\"dateModified\":\"2023-07-25T05:15:38+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggabungkan dua kolom dalam pandas DataFrame, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-menggabungkan-dua-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-menggabungkan-dua-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-menggabungkan-dua-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggabungkan dua kolom di pandas (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Menggabungkan Dua Kolom di Pandas (Dengan Contoh)","description":"Tutorial ini menjelaskan cara menggabungkan dua kolom dalam pandas DataFrame, dengan beberapa contoh.","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:\/\/statorials.org\/id\/panda-menggabungkan-dua-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggabungkan Dua Kolom di Pandas (Dengan Contoh)","og_description":"Tutorial ini menjelaskan cara menggabungkan dua kolom dalam pandas DataFrame, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-menggabungkan-dua-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-25T05:15:38+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/panda-menggabungkan-dua-kolom\/","url":"https:\/\/statorials.org\/id\/panda-menggabungkan-dua-kolom\/","name":"Cara Menggabungkan Dua Kolom di Pandas (Dengan Contoh)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T05:15:38+00:00","dateModified":"2023-07-25T05:15:38+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggabungkan dua kolom dalam pandas DataFrame, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-menggabungkan-dua-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-menggabungkan-dua-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-menggabungkan-dua-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggabungkan dua kolom di pandas (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1732"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=1732"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1732\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}