{"id":976,"date":"2023-07-28T03:15:43","date_gmt":"2023-07-28T03:15:43","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kolom\/"},"modified":"2023-07-28T03:15:43","modified_gmt":"2023-07-28T03:15:43","slug":"panda-menggabungkan-beberapa-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kolom\/","title":{"rendered":"Cara menggabungkan pandas dataframes di beberapa kolom"},"content":{"rendered":"

<\/p>\n

\n

Seringkali Anda mungkin ingin menggabungkan dua panda DataFrames di beberapa kolom. Untungnya, hal ini mudah dilakukan menggunakan fungsi pandas merge()<\/a> , yang menggunakan sintaks berikut:<\/span><\/p>\n

 p.d. merge<\/span> (df1, df2, left_on=['col1','col2'], right_on = ['col1','col2'])<\/strong><\/pre>\n
 Tutorial ini menjelaskan cara menggunakan fungsi ini dalam praktik.<\/span><\/p>\n
 Contoh 1: Gabungkan<\/span> beberapa kolom dengan nama berbeda<\/strong><\/h3>\n
 Mari kita asumsikan kita memiliki dua panda DataFrames berikut:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#create and view first DataFrame<\/span>\ndf1 = pd.DataFrame({'a1': [0, 0, 1, 1, 2],\n                   'b': [0, 0, 1, 1, 1],\n                   'c': [11, 8, 10, 6, 6]})\n\nprint<\/span> (df1)\n\n   a1 bc\n0 0 0 11\n1 0 0 8\n2 1 1 10\n3 1 1 6\n4 2 1 6\n\n#create and view second DataFrame<\/span> \ndf2 = pd.DataFrame({'a2': [0, 1, 1, 1, 3],\n                   'b': [0, 0, 0, 1, 1],\n                   'd': [22, 24, 25, 33, 37]})\n\nprint<\/span> (df2)\n\n   a2 comic\n0 0 0 22\n1 1 0 24\n2 1 0 25\n3 1 1 33\n4 3 1 37\n<\/strong><\/pre>\n
 Kode berikut menunjukkan cara melakukan penggabungan kiri menggunakan beberapa kolom dari kedua DataFrames:<\/span><\/p>\n
 p.d. merge<\/span> (df1, df2, how=' left<\/span> ', left_on=[' a1<\/span> ', ' b<\/span> '], right_on = [' a2<\/span> ', ' b<\/span> '])\n\n\n        a1 b c a2 d\n0 0 0 11 0.0 22.0\n1 0 0 8 0.0 22.0\n2 1 1 10 1.0 33.0\n3 1 1 6 1.0 33.0\n4 2 1 6 NaN NaN\n<\/strong><\/pre>\n
 Contoh 2: Gabungkan<\/span> beberapa kolom dengan nama yang sama<\/strong><\/h3>\n
 Misalkan kita memiliki dua panda DataFrames berikut dengan nama kolom yang sama:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrames<\/span>\ndf1 = pd.DataFrame({'a': [0, 0, 1, 1, 2],\n                   'b': [0, 0, 1, 1, 1],\n                   'c': [11, 8, 10, 6, 6]})\n\ndf2 = pd.DataFrame({'a': [0, 1, 1, 1, 3],\n                   'b': [0, 0, 0, 1, 1],\n                   'd': [22, 24, 25, 33, 37]})\n<\/strong><\/pre>\n
 Dalam hal ini, kita dapat menyederhanakan penggunaan on = [‘a’, ‘b’]<\/strong> karena nama kolom di kedua DataFrame sama:<\/span><\/p>\n
 p.d. merge<\/span> (df1, df2, how=' left<\/span> ', on=[' a<\/span> ', ' b<\/span> '])\n\n\ta b c d\n0 0 0 11 22.0\n1 0 0 8 22.0\n2 1 1 10 33.0\n3 1 1 6 33.0\n4 2 1 6 NaN\n<\/strong><\/pre>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Cara menggabungkan dua Pandas DataFrames di index
 Cara menumpuk beberapa Pandas DataFrames<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Seringkali Anda mungkin ingin menggabungkan dua panda DataFrames di beberapa kolom. Untungnya, hal ini mudah dilakukan menggunakan fungsi pandas merge() , yang menggunakan sintaks berikut: p.d. merge (df1, df2, left_on=[‘col1′,’col2’], right_on = [‘col1′,’col2’]) Tutorial ini menjelaskan cara menggunakan fungsi ini dalam praktik. Contoh 1: Gabungkan beberapa kolom dengan nama berbeda Mari kita asumsikan kita memiliki […]<\/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":"\nCara menggabungkan Pandas DataFrames di beberapa kolom \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara menggabungkan dua panda DataFrames di beberapa kolom, termasuk 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-beberapa-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggabungkan Pandas DataFrames di beberapa kolom \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara menggabungkan dua panda DataFrames di beberapa kolom, termasuk contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T03:15:43+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=\"1 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-beberapa-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kolom\/\",\"name\":\"Cara menggabungkan Pandas DataFrames di beberapa kolom \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T03:15:43+00:00\",\"dateModified\":\"2023-07-28T03:15:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara menggabungkan dua panda DataFrames di beberapa kolom, termasuk contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggabungkan pandas dataframes di beberapa kolom\"}]},{\"@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 Pandas DataFrames di beberapa kolom \u2013 Statorial","description":"Penjelasan sederhana tentang cara menggabungkan dua panda DataFrames di beberapa kolom, termasuk 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-beberapa-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggabungkan Pandas DataFrames di beberapa kolom \u2013 Statorial","og_description":"Penjelasan sederhana tentang cara menggabungkan dua panda DataFrames di beberapa kolom, termasuk contoh.","og_url":"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-28T03:15:43+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kolom\/","url":"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kolom\/","name":"Cara menggabungkan Pandas DataFrames di beberapa kolom \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T03:15:43+00:00","dateModified":"2023-07-28T03:15:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara menggabungkan dua panda DataFrames di beberapa kolom, termasuk contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggabungkan pandas dataframes di beberapa kolom"}]},{"@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\/976"}],"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=976"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/976\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}