{"id":3342,"date":"2023-07-18T00:09:53","date_gmt":"2023-07-18T00:09:53","guid":{"rendered":"https:\/\/statorials.org\/id\/lintas-panda\/"},"modified":"2023-07-18T00:09:53","modified_gmt":"2023-07-18T00:09:53","slug":"lintas-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/lintas-panda\/","title":{"rendered":"Cara melakukan cross join di pandas (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk melakukan gabungan silang di panda:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create common key\n<\/span>df1[' <span style=\"color: #ff0000;\">key<\/span> '] = 0\ndf2[' <span style=\"color: #ff0000;\">key<\/span> '] = 0\n\n<span style=\"color: #008080;\">#outer merge on common key (eg a cross join)\n<\/span>df1. <span style=\"color: #3366ff;\">merge<\/span> (df2, on=' <span style=\"color: #ff0000;\">key<\/span> ', how=' <span style=\"color: #ff0000;\">outer<\/span> ')\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Melakukan Cross Join di Pandas<\/strong><\/span><\/h2>\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;\"> <span style=\"color: #000000;\"><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>df1 = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['A', 'B', 'C', 'D'],\n                    ' <span style=\"color: #ff0000;\">points<\/span> ': [18, 22, 19, 14]})\n\n<span style=\"color: #008000;\">print<\/span> (df1)\n\n  team points\n0 to 18\n1 B 22\n2 C 19\n3 D 14\n\n<span style=\"color: #008080;\">#create second DataFrame\n<\/span>df2 = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['A', 'B', 'F'],\n                    ' <span style=\"color: #ff0000;\">assists<\/span> ': [4, 9, 8]})\n\n<span style=\"color: #008000;\">print<\/span> (df2)\n\n  team assists\n0 to 4\n1 B 9\n2 F 8\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kode berikut menunjukkan cara melakukan gabungan silang pada dua DataFrame:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create common key\n<span style=\"color: #000000;\">df1[' <span style=\"color: #ff0000;\">key<\/span> '] = 0\ndf2[' <span style=\"color: #ff0000;\">key<\/span> '] = 0\n\n<span style=\"color: #008080;\">#perform cross join\n<\/span>df3 = df1. <span style=\"color: #3366ff;\">merge<\/span> (df2, on=' <span style=\"color: #ff0000;\">key<\/span> ', how=' <span style=\"color: #ff0000;\">outer<\/span> ')\n\n<span style=\"color: #008080;\">#drop key column\n<\/span><span style=\"color: #008000;\">del<\/span> df3[' <span style=\"color: #ff0000;\">key<\/span> ']\n\n<span style=\"color: #008080;\">#view results\n<\/span><span style=\"color: #008000;\">print<\/span> (df3)\n\n   team_x points team_y assists\n0 A 18 A 4\n1 A 18 B 9\n2 A 18 F 8\n3 B 22 A 4\n4 B 22 B 9\n5 B 22 F 8\n6 C 19 A 4\n7 C 19 B 9\n8 C 19 F 8\n9 D 14 A 4\n10 D 14 B 9\n11 D 14 F 8<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Hasilnya adalah DataFrame yang berisi semua kemungkinan kombinasi baris dari setiap DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, baris pertama DataFrame pertama<\/span> <span style=\"color: #000000;\">berisi Tim <strong>A<\/strong> dan <strong>18<\/strong> poin. Baris ini sesuai dengan setiap baris DataFrame kedua.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian baris kedua DataFrame pertama berisi Tim <strong>B<\/strong> dan <strong>22<\/strong> poin. Baris ini juga sesuai dengan setiap baris DataFrame kedua.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hasil akhirnya adalah DataFrame dengan 12 baris.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/kiri-bergabung-dengan-panda\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara melakukan gabung kiri di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kiri-bergabung-dengan-panda\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara melakukan gabung kiri di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-bergabung-vs-bergabung\/\" target=\"_blank\" rel=\"noopener\">Pandas Bergabung atau Bergabung: Apa bedanya?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk melakukan gabungan silang di panda: #create common key df1[&#8216; key &#8216;] = 0 df2[&#8216; key &#8216;] = 0 #outer merge on common key (eg a cross join) df1. merge (df2, on=&#8217; key &#8216;, how=&#8217; outer &#8216;) Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Contoh: Melakukan Cross [&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>Cara Melakukan Cross Join di Pandas (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan cross 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\/lintas-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Cross Join di Pandas (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan cross join di panda, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/lintas-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T00:09:53+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\/lintas-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/lintas-panda\/\",\"name\":\"Cara Melakukan Cross Join di Pandas (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T00:09:53+00:00\",\"dateModified\":\"2023-07-18T00:09:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan cross join di panda, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/lintas-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/lintas-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/lintas-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan cross 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 Cross Join di Pandas (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara melakukan cross 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\/lintas-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Cross Join di Pandas (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara melakukan cross join di panda, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/lintas-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-18T00:09:53+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\/lintas-panda\/","url":"https:\/\/statorials.org\/id\/lintas-panda\/","name":"Cara Melakukan Cross Join di Pandas (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T00:09:53+00:00","dateModified":"2023-07-18T00:09:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan cross join di panda, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/lintas-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/lintas-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/lintas-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan cross 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\/3342"}],"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=3342"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3342\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}