{"id":2927,"date":"2023-07-20T01:36:38","date_gmt":"2023-07-20T01:36:38","guid":{"rendered":"https:\/\/statorials.org\/id\/segel-interior-panda\/"},"modified":"2023-07-20T01:36:38","modified_gmt":"2023-07-20T01:36:38","slug":"segel-interior-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/segel-interior-panda\/","title":{"rendered":"Cara melakukan inner join di pandas (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

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

 import<\/span> pandas as<\/span> pd\n<\/span>\ndf1. merge<\/span> (df2, on=' column_name<\/span> ', how=' inner<\/span> ')\n<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Cara melakukan inner join 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\nprint<\/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 dalam, yang hanya menyimpan baris tempat nama tim<\/strong> muncul di kedua DataFrame:<\/span><\/p>\n
 #perform left join\ndf1. merge<\/span> (df2, on=' team<\/span> ', how=' inner<\/span> ')\n\n\tteam points assists\n0 to 18 4\n1 B 22 9\n2 C 19 14\n3 D 14 13\n4 G 20 10\n5:28 8\n<\/span><\/span><\/strong><\/pre>\n
 Satu-satunya baris yang terdapat dalam DataFrame gabungan adalah baris tempat nama tim muncul di kedua DataFrame.<\/span><\/span><\/p>\n
 Perhatikan bahwa dua tim telah dihapus (tim E dan F) karena mereka tidak muncul di kedua DataFrames.<\/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=' inner<\/span> ')\n\n\tteam points assists\n0 to 18 4\n1 B 22 9\n2 C 19 14\n3 D 14 13\n4 G 20 10\n5:28 8<\/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><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di panda:<\/span><\/p>\n
 Bagaimana cara melakukan gabung kiri di Pandas<\/a>
 Cara menggabungkan Pandas DataFrames di beberapa kolom<\/a>
 Pandas Bergabung atau Bergabung: Apa bedanya?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk melakukan penggabungan dalam di panda: import pandas as pd df1. merge (df2, on=’ column_name ‘, how=’ inner ‘) Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Cara melakukan inner join 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 inner join di panda (dengan contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan inner join 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\/segel-interior-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara melakukan inner join di panda (dengan contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan inner join di panda, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/segel-interior-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T01:36: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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/segel-interior-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/segel-interior-panda\/\",\"name\":\"Cara melakukan inner join di panda (dengan contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T01:36:38+00:00\",\"dateModified\":\"2023-07-20T01:36:38+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan inner join di panda, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/segel-interior-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/segel-interior-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/segel-interior-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan inner 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 inner join di panda (dengan contoh) - Statorials","description":"Tutorial ini menjelaskan cara melakukan inner join 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\/segel-interior-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Cara melakukan inner join di panda (dengan contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara melakukan inner join di panda, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/segel-interior-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-20T01:36:38+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\/segel-interior-panda\/","url":"https:\/\/statorials.org\/id\/segel-interior-panda\/","name":"Cara melakukan inner join di panda (dengan contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T01:36:38+00:00","dateModified":"2023-07-20T01:36:38+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan inner join di panda, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/segel-interior-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/segel-interior-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/segel-interior-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan inner 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\/2927"}],"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=2927"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2927\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}