{"id":3126,"date":"2023-07-19T02:30:16","date_gmt":"2023-07-19T02:30:16","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-bergabung-pada-nama-kolom-yang-berbeda\/"},"modified":"2023-07-19T02:30:16","modified_gmt":"2023-07-19T02:30:16","slug":"panda-bergabung-pada-nama-kolom-yang-berbeda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-bergabung-pada-nama-kolom-yang-berbeda\/","title":{"rendered":"Pandas: cara menggabungkan dua dataframe dengan nama kolom berbeda"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menggabungkan dua panda DataFrames dengan nama kolom berbeda:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>p.d. <span style=\"color: #3366ff;\">merge<\/span> (df1, df2, left_on=' <span style=\"color: #ff0000;\">left_column_name<\/span> ', right_on=' <span style=\"color: #ff0000;\">right_column_name<\/span> ')\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Gabungkan dua Pandas DataFrames dengan nama kolom berbeda<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Mari kita asumsikan kita memiliki dua panda DataFrames berikut:<\/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 first DataFrame\n<span style=\"color: #000000;\">df1 = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['A', 'B', 'C', 'D', 'E', 'F'],\n                    ' <span style=\"color: #ff0000;\">points<\/span> ': [4, 4, 6, 8, 9, 5]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df1)\n\n  team points\n0 to 4\n1 B 4\n2 C 6\n3 D 8\n4 E 9\n5 F 5\n\n<span style=\"color: #008080;\">#create second DataFrame\n<\/span>df2 = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team_name<\/span> ': ['A', 'B', 'C', 'D', 'E', 'F'],\n                    ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [12, 7, 8, 8, 5, 11]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df2)\n\n  team_name rebounds\n0 to 12\n1 B 7\n2 C 8\n3 D 8\n4 E 5\n5 F 11\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk melakukan penggabungan dalam, menggunakan kolom <strong>tim<\/strong> di DataFrame pertama dan kolom <strong>nama_tim<\/strong> di DataFrame kedua:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#merge DataFrames\n<span style=\"color: #000000;\">df3 = pd. <span style=\"color: #3366ff;\">merge<\/span> (df1, df2, left_on=' <span style=\"color: #ff0000;\">team<\/span> ', right_on=' <span style=\"color: #ff0000;\">team_name<\/span> ')\n<\/span>\n#view result\n<span style=\"color: #000000;\"><span style=\"color: #008000;\">print<\/span> (df3)\n\n  team points team_name rebounds\n0 A 4 A 12\n1 B 4 B 7\n2 C 6 C 8\n3 D 8 D 8\n4 E 9 E 5\n5 F 5 F 11\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kami berhasil melakukan penggabungan dalam meskipun dua nama kolom yang kami gunakan untuk penggabungan berbeda di setiap DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa kita juga dapat menggunakan kode berikut untuk menghapus kolom <strong>nama_tim<\/strong> dari DataFrame gabungan terakhir karena nilai di kolom ini cocok dengan nilai di kolom <strong>tim<\/strong> :<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#drop team_name column<\/span>\ndf3. <span style=\"color: #3366ff;\">drop<\/span> (' <span style=\"color: #ff0000;\">team_name<\/span> ', axis= <span style=\"color: #008000;\">1<\/span> , inplace= <span style=\"color: #008000;\">True<\/span> )\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df3)\n\n  team points rebounds\n0 to 4 12\n1 B 4 7\n2 C 6 8\n3 D 8 8\n4 E 9 5\n5 F 5 11\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kolom <b>nama_tim<\/b> telah dihapus dari DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/jatuhkan-panda-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara Menghapus Kolom di Pandas (4 Contoh)<\/a><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas panda umum lainnya:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/panda-mengubah-urutan-kolom\/\" target=\"_blank\" rel=\"noopener\">Bagaimana mengubah urutan kolom di Pandas<\/a><br \/> Cara mengganti nama kolom di Pandas<br \/> <a href=\"https:\/\/statorials.org\/id\/panda-mengurutkan-kolom-berdasarkan-nama\/\" target=\"_blank\" rel=\"noopener\">Cara mengurutkan kolom berdasarkan nama di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menggabungkan dua panda DataFrames dengan nama kolom berbeda: p.d. merge (df1, df2, left_on=&#8217; left_column_name &#8216;, right_on=&#8217; right_column_name &#8216;) Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Gabungkan dua Pandas DataFrames dengan nama kolom berbeda Mari kita asumsikan kita memiliki dua panda DataFrames berikut: import pandas as [&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>Pandas: Cara menggabungkan dua DataFrame dengan nama kolom berbeda - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggabungkan dua panda DataFrames menggunakan nama kolom yang berbeda, termasuk contohnya.\" \/>\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-bergabung-pada-nama-kolom-yang-berbeda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara menggabungkan dua DataFrame dengan nama kolom berbeda - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggabungkan dua panda DataFrames menggunakan nama kolom yang berbeda, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-bergabung-pada-nama-kolom-yang-berbeda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T02:30:16+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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/panda-bergabung-pada-nama-kolom-yang-berbeda\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-bergabung-pada-nama-kolom-yang-berbeda\/\",\"name\":\"Pandas: Cara menggabungkan dua DataFrame dengan nama kolom berbeda - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T02:30:16+00:00\",\"dateModified\":\"2023-07-19T02:30:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggabungkan dua panda DataFrames menggunakan nama kolom yang berbeda, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-bergabung-pada-nama-kolom-yang-berbeda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-bergabung-pada-nama-kolom-yang-berbeda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-bergabung-pada-nama-kolom-yang-berbeda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menggabungkan dua dataframe dengan nama kolom berbeda\"}]},{\"@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":"Pandas: Cara menggabungkan dua DataFrame dengan nama kolom berbeda - Statorials","description":"Tutorial ini menjelaskan cara menggabungkan dua panda DataFrames menggunakan nama kolom yang berbeda, termasuk contohnya.","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-bergabung-pada-nama-kolom-yang-berbeda\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menggabungkan dua DataFrame dengan nama kolom berbeda - Statorials","og_description":"Tutorial ini menjelaskan cara menggabungkan dua panda DataFrames menggunakan nama kolom yang berbeda, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/panda-bergabung-pada-nama-kolom-yang-berbeda\/","og_site_name":"Statorials","article_published_time":"2023-07-19T02:30:16+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/panda-bergabung-pada-nama-kolom-yang-berbeda\/","url":"https:\/\/statorials.org\/id\/panda-bergabung-pada-nama-kolom-yang-berbeda\/","name":"Pandas: Cara menggabungkan dua DataFrame dengan nama kolom berbeda - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T02:30:16+00:00","dateModified":"2023-07-19T02:30:16+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggabungkan dua panda DataFrames menggunakan nama kolom yang berbeda, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-bergabung-pada-nama-kolom-yang-berbeda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-bergabung-pada-nama-kolom-yang-berbeda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-bergabung-pada-nama-kolom-yang-berbeda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menggabungkan dua dataframe dengan nama kolom berbeda"}]},{"@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\/3126"}],"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=3126"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3126\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}