{"id":2926,"date":"2023-07-20T01:42:49","date_gmt":"2023-07-20T01:42:49","guid":{"rendered":"https:\/\/statorials.org\/id\/kiri-bergabung-dengan-panda\/"},"modified":"2023-07-20T01:42:49","modified_gmt":"2023-07-20T01:42:49","slug":"kiri-bergabung-dengan-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kiri-bergabung-dengan-panda\/","title":{"rendered":"Cara melakukan gabung kiri di pandas (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

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

 import<\/span> pandas as<\/span> pd\n<\/span>\ndf1. merge<\/span> (df2, on=' column_name<\/span> ', how=' left<\/span> ')\n<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Cara melakukan join kiri 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', 'G', 'H'],\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\n4G 10\n5:8 a.m.<\/span><\/span><\/strong><\/pre>\n
 Kita dapat menggunakan kode berikut untuk melakukan penggabungan kiri, mempertahankan semua baris dari DataFrame pertama dan menambahkan semua kolom yang cocok berdasarkan kolom tim<\/strong> di DataFrame kedua:<\/span><\/p>\n
 #perform left join\ndf1. merge<\/span> (df2, on=' team<\/span> ', how=' left<\/span> ')\n\n        team points assists\n0 to 18 4.0\n1 B 22 9.0\n2 C 19 14.0\n3 D 14 13.0\n4 E 14 NaN\n5 F 11 NaN\n6G 20 10.0\n7:28 a.m. 8.0\n<\/span><\/span><\/strong><\/pre>\n
 Setiap tim di DataFrame kiri ( df1<\/strong> ) dikembalikan dalam DataFrame gabungan dan hanya baris di DataFrame kanan ( df2<\/strong> ) yang cocok dengan nama tim di DataFrame kiri yang dikembalikan.<\/span><\/p>\n
 Perhatikan bahwa dua tim di df2<\/strong> (tim E dan F) yang tidak cocok dengan nama tim di df1<\/strong> cukup mengembalikan nilai NaN<\/strong> di kolom assist dari DataFrame yang digabungkan.<\/span><\/p>\n
 Perhatikan bahwa Anda juga dapat menggunakan pd.merge()<\/strong> dengan sintaks berikut untuk mengembalikan hasil yang sama persis:<\/span><\/p>\n
 #perform left join\np.d. merge<\/span> (df1, df2, on=' team<\/span> ', how=' left<\/span> ')\n\n\n        team points assists\n0 to 18 4.0\n1 B 22 9.0\n2 C 19 14.0\n3 D 14 13.0\n4 E 14 NaN\n5 F 11 NaN\n6G 20 10.0\n7:28 a.m. 8.0<\/span><\/span><\/strong><\/pre>\n
 Perhatikan bahwa DataFrame gabungan ini cocok dengan contoh sebelumnya.<\/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":"
Anda dapat menggunakan sintaks dasar berikut untuk melakukan gabung kiri di panda: import pandas as pd df1. merge (df2, on=’ column_name ‘, how=’ left ‘) Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Cara melakukan join kiri di Pandas Katakanlah kita memiliki dua panda DataFrames berikut yang berisi informasi tentang berbagai tim bola […]<\/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 kiri di Pandas (dengan contoh) \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan join kiri 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\/kiri-bergabung-dengan-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 kiri di Pandas (dengan contoh) \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan join kiri di panda, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kiri-bergabung-dengan-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T01:42:49+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\/kiri-bergabung-dengan-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/kiri-bergabung-dengan-panda\/\",\"name\":\"Cara melakukan gabung kiri di Pandas (dengan contoh) \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T01:42:49+00:00\",\"dateModified\":\"2023-07-20T01:42:49+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan join kiri di panda, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kiri-bergabung-dengan-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kiri-bergabung-dengan-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kiri-bergabung-dengan-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan gabung kiri 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 kiri di Pandas (dengan contoh) \u2013 Statorials","description":"Tutorial ini menjelaskan cara melakukan join kiri 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\/kiri-bergabung-dengan-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Cara melakukan gabung kiri di Pandas (dengan contoh) \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara melakukan join kiri di panda, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/kiri-bergabung-dengan-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-20T01:42:49+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\/kiri-bergabung-dengan-panda\/","url":"https:\/\/statorials.org\/id\/kiri-bergabung-dengan-panda\/","name":"Cara melakukan gabung kiri di Pandas (dengan contoh) \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T01:42:49+00:00","dateModified":"2023-07-20T01:42:49+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan join kiri di panda, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kiri-bergabung-dengan-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kiri-bergabung-dengan-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kiri-bergabung-dengan-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan gabung kiri 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\/2926"}],"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=2926"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2926\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}