{"id":3918,"date":"2023-07-14T18:27:05","date_gmt":"2023-07-14T18:27:05","guid":{"rendered":"https:\/\/statorials.org\/id\/gabungan-luar-panda\/"},"modified":"2023-07-14T18:27:05","modified_gmt":"2023-07-14T18:27:05","slug":"gabungan-luar-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/gabungan-luar-panda\/","title":{"rendered":"Cara melakukan outer join di pandas (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Gabungan luar<\/strong> adalah jenis gabungan yang mengembalikan semua baris dari dua panda DataFrames.<\/span><\/p>\n

Anda dapat menggunakan sintaks dasar berikut untuk melakukan gabungan luar di panda:<\/span><\/p>\n

 import<\/span> pandas as<\/span> pd\n<\/span>\ndf1. merge<\/span> (df2, on=' some_column<\/span> ', how=' outer<\/span> ')\n<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Cara melakukan penggabungan luar di Pandas<\/strong><\/span><\/h2>\n
 Katakanlah kita memiliki dua panda DataFrames berikut yang berisi informasi tentang berbagai tim bola basket:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame\ndf1 = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H'],\n                    ' points<\/span> ': [18, 22, 19, 14, 14, 11, 20, 28]})\n\ndf2 = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'B', 'C', 'D', 'J', 'K'],\n                    ' assists<\/span> ': [4, 9, 14, 13, 10, 8]})\n\n#view DataFrames\n<\/span>print<\/span> (df1)\n\n  team points\n0 to 18\n1 B 22\n2 C 19\n3 D 14\n4 E 14\n5 F 11\n6 G 20\n7:28 a.m.\n\nprint<\/span> (df2)\n\n  team assists\n0 to 4\n1 B 9\n2 C 14\n3 D 13\n4 D 10\n5K 8<\/span><\/span><\/strong><\/pre>\n
 Kita dapat menggunakan kode berikut untuk melakukan gabungan luar, mencocokkan baris antara DataFrames berdasarkan nilai kolom tim<\/strong> dan mempertahankan semua baris dari kedua DataFrames:<\/span><\/p>\n
 #perform outer join\n<\/span>df1. merge<\/span> (df2, on=' team<\/span> ', how=' outer<\/span> ')\n\n\n        team points assists\n0 to 18.0 4.0\n1 B 22.0 9.0\n2 C 19.0 14.0\n3D 14.0 13.0\n4 E 14.0 NaN\n5 F 11.0 NaN\n6G 20.0 NaN\n7 H 28.0 NaN\n8 J NaN 10.0\n9K NaN 8.0\n<\/span><\/span><\/strong><\/pre>\n
 Hasilnya adalah DataFrame yang berisi semua baris di setiap DataFrame.<\/span><\/span><\/p>\n
 Perhatikan bahwa nilai NaN<\/strong> diisi untuk setiap baris di mana nilai kolom tim<\/strong> tidak ada di kedua DataFrames.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi penggabungan<\/strong> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di panda:<\/span><\/p>\n
 Cara melakukan anti-gabung di Pandas<\/a>
 Cara melakukan inner join di Pandas<\/a>
 Cara melakukan cross join di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Gabungan luar adalah jenis gabungan yang mengembalikan semua baris dari dua panda DataFrames. Anda dapat menggunakan sintaks dasar berikut untuk melakukan gabungan luar di panda: import pandas as pd df1. merge (df2, on=’ some_column ‘, how=’ outer ‘) Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Cara melakukan penggabungan luar di Pandas Katakanlah […]<\/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 Melakukan Gabung Luar di Pandas (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan penggabungan luar di panda, dengan sebuah 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\/gabungan-luar-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Gabung Luar di Pandas (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan penggabungan luar di panda, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/gabungan-luar-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T18:27:05+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\/gabungan-luar-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/gabungan-luar-panda\/\",\"name\":\"Cara Melakukan Gabung Luar di Pandas (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T18:27:05+00:00\",\"dateModified\":\"2023-07-14T18:27:05+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan penggabungan luar di panda, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/gabungan-luar-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/gabungan-luar-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/gabungan-luar-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan outer join 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 Melakukan Gabung Luar di Pandas (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara melakukan penggabungan luar di panda, dengan sebuah 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\/gabungan-luar-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Gabung Luar di Pandas (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara melakukan penggabungan luar di panda, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/gabungan-luar-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-14T18:27:05+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\/gabungan-luar-panda\/","url":"https:\/\/statorials.org\/id\/gabungan-luar-panda\/","name":"Cara Melakukan Gabung Luar di Pandas (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T18:27:05+00:00","dateModified":"2023-07-14T18:27:05+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan penggabungan luar di panda, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/gabungan-luar-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/gabungan-luar-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/gabungan-luar-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan outer join 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\/3918"}],"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=3918"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3918\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}