{"id":1517,"date":"2023-07-26T01:39:06","date_gmt":"2023-07-26T01:39:06","guid":{"rendered":"https:\/\/statorials.org\/id\/bandingkan-dua-kolom-di-panda\/"},"modified":"2023-07-26T01:39:06","modified_gmt":"2023-07-26T01:39:06","slug":"bandingkan-dua-kolom-di-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bandingkan-dua-kolom-di-panda\/","title":{"rendered":"Cara membandingkan dua kolom di pandas: dengan contoh"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin membandingkan dua kolom dalam Pandas DataFrame dan menulis hasil perbandingan ke kolom ketiga.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat dengan mudah melakukan ini menggunakan sintaks berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>conditions=[(condition1),(condition2)]\nchoices=[\" <span style=\"color: #008000;\">choice1<\/span> \",\" <span style=\"color: #008000;\">choice2<\/span> \"]\n\ndf[\" <span style=\"color: #008000;\">new_column_name<\/span> \"]=np. <span style=\"color: #3366ff;\">select<\/span> (conditions, choices, default)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Inilah yang dilakukan kode ini:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>condition<\/strong> adalah kondisi yang harus diperiksa antara dua kolom<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>pilihan<\/strong> adalah hasil yang dikembalikan berdasarkan kondisi<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>np.select<\/strong> digunakan untuk mengembalikan hasil di kolom baru<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan kode ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Bandingkan dua kolom di Pandas<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki DataFrame berikut yang menunjukkan jumlah gol yang dicetak oleh dua tim sepak bola dalam lima pertandingan berbeda:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">import<\/span> numpy <span style=\"color: #008000;\">as<\/span> np\n<span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame\n<\/span>df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #008000;\">A_points<\/span> ': [1, 3, 3, 3, 5],\n                   ' <span style=\"color: #008000;\">B_points<\/span> ': [4, 5, 2, 3, 2]})\n             \n<span style=\"color: #008080;\">#view DataFrame      \n<\/span>df\n\n          A_points B_points\n0 1 4\n1 3 5\n2 3 2\n3 3 3\n4 5 2\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk membandingkan jumlah gol per baris dan menampilkan pemenang pertandingan di kolom ketiga:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#define conditions<\/span>\nconditions = [df[' <span style=\"color: #008000;\">A_points<\/span> '] &gt; df[' <span style=\"color: #008000;\">B_points<\/span> '], \n              df[' <span style=\"color: #008000;\">A_points<\/span> '] &lt; df[' <span style=\"color: #008000;\">B_points<\/span> ']]\n\n<span style=\"color: #008080;\">#define choices\n<\/span>choices = [' <span style=\"color: #008000;\">A<\/span> ', ' <span style=\"color: #008000;\">B<\/span> ']\n\n<span style=\"color: #008080;\">#create new column in DataFrame that displays results of comparisons\n<\/span>df[' <span style=\"color: #008000;\">winner<\/span> '] = np. <span style=\"color: #3366ff;\">select<\/span> (conditions, choices, default=' <span style=\"color: #008000;\">Tie<\/span> ')\n\n<span style=\"color: #008080;\">#view the DataFrame\n<\/span>df\n\n          A_points B_points winner\n0 1 4 B\n1 3 5 B\n2 3 2 A\n3 3 3 Tie\n4 5 2 A<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Hasil perbandingannya ditampilkan pada kolom baru bernama <em>Winner<\/em> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Komentar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Berikut beberapa hal yang perlu diingat saat membandingkan dua kolom di pandas DataFrame:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Jumlah <strong>kondisi<\/strong> dan <strong>pilihan<\/strong> harus sama.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Defaultnya<\/strong> menentukan nilai yang akan ditampilkan di kolom baru jika tidak ada kondisi yang terpenuhi.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>NumPy<\/strong> dan <strong>Pandas<\/strong> diperlukan agar kode ini berfungsi.<\/span><\/li>\n<\/ul>\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\/panda-mengganti-nama-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara mengganti nama kolom di Pandas<\/a><br \/> Bagaimana cara menambahkan kolom ke Pandas DataFrame<br \/> <a href=\"https:\/\/statorials.org\/id\/panda-mengubah-urutan-kolom\/\" target=\"_blank\" rel=\"noopener\">Bagaimana mengubah urutan kolom di Pandas DataFrame<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin membandingkan dua kolom dalam Pandas DataFrame dan menulis hasil perbandingan ke kolom ketiga. Anda dapat dengan mudah melakukan ini menggunakan sintaks berikut: conditions=[(condition1),(condition2)] choices=[&#8221; choice1 &#8220;,&#8221; choice2 &#8220;] df[&#8221; new_column_name &#8220;]=np. select (conditions, choices, default) Inilah yang dilakukan kode ini: condition adalah kondisi yang harus diperiksa antara dua kolom pilihan adalah [&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 membandingkan dua kolom di Pandas: dengan contoh<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membandingkan dua kolom di Pandas DataFrame, dengan beberapa 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\/bandingkan-dua-kolom-di-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara membandingkan dua kolom di Pandas: dengan contoh\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membandingkan dua kolom di Pandas DataFrame, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bandingkan-dua-kolom-di-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T01:39:06+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\/bandingkan-dua-kolom-di-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/bandingkan-dua-kolom-di-panda\/\",\"name\":\"Cara membandingkan dua kolom di Pandas: dengan contoh\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T01:39:06+00:00\",\"dateModified\":\"2023-07-26T01:39:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membandingkan dua kolom di Pandas DataFrame, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bandingkan-dua-kolom-di-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bandingkan-dua-kolom-di-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bandingkan-dua-kolom-di-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membandingkan dua kolom 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 membandingkan dua kolom di Pandas: dengan contoh","description":"Tutorial ini menjelaskan cara membandingkan dua kolom di Pandas DataFrame, dengan beberapa 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\/bandingkan-dua-kolom-di-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Cara membandingkan dua kolom di Pandas: dengan contoh","og_description":"Tutorial ini menjelaskan cara membandingkan dua kolom di Pandas DataFrame, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/bandingkan-dua-kolom-di-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-26T01:39:06+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\/bandingkan-dua-kolom-di-panda\/","url":"https:\/\/statorials.org\/id\/bandingkan-dua-kolom-di-panda\/","name":"Cara membandingkan dua kolom di Pandas: dengan contoh","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T01:39:06+00:00","dateModified":"2023-07-26T01:39:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membandingkan dua kolom di Pandas DataFrame, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bandingkan-dua-kolom-di-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bandingkan-dua-kolom-di-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bandingkan-dua-kolom-di-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membandingkan dua kolom 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\/1517"}],"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=1517"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1517\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1517"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}