{"id":3803,"date":"2023-07-15T11:15:50","date_gmt":"2023-07-15T11:15:50","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-memilih-baris-atau-dua-kolom-yang-sama\/"},"modified":"2023-07-15T11:15:50","modified_gmt":"2023-07-15T11:15:50","slug":"panda-memilih-baris-atau-dua-kolom-yang-sama","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-memilih-baris-atau-dua-kolom-yang-sama\/","title":{"rendered":"Pandas: pilih baris yang dua kolomnya sama"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk memilih baris dalam pandas DataFrame di mana dua kolomnya (atau tidak) sama:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Pilih baris yang dua kolomnya sama<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">query<\/span> (' <span style=\"color: #ff0000;\">column1 ==column2<\/span> ')\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Pilih baris yang dua kolomnya tidak sama<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">query<\/span> (' <span style=\"color: #ff0000;\">column1<\/span> <span style=\"color: #ff0000;\">!=column2<\/span> ')<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dalam praktik dengan pandas DataFrame berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">painting<\/span> ': ['A', 'B', 'C', 'D', 'E', 'F'],\n                   ' <span style=\"color: #ff0000;\">fail1<\/span> ': ['Good', 'Good', 'Bad', 'Bad', 'Good', 'Good'],\n                   ' <span style=\"color: #ff0000;\">fail2<\/span> ': ['Good', 'Bad', 'Bad', 'Good', 'Good', 'Good']})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  painting rater1 rater2\n0 A Good Good\n1 B Good Bad\n2 C Bad Bad\n3 D Bad Good\n4 E Good Good\n5 F Good Good<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Pilih baris yang dua kolomnya sama<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk memilih hanya baris di DataFrame yang nilai kolom <strong>rater1<\/strong> dan <strong>rater2<\/strong> sama:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#select rows where rater1 is equal to rater2\n<\/span>df. <span style=\"color: #3366ff;\">query<\/span> (' <span style=\"color: #ff0000;\">rater1 ==rater2<\/span> ')\n\n painting rater1 rater2\n0 A Good Good\n2 C Bad Bad\n4 E Good Good\n5 F Good Good<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa hanya garis dimana <strong>miss1<\/strong> dan <strong>miss2<\/strong> sama yang dipilih.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita juga dapat menggunakan fungsi <strong>len()<\/strong> jika kita hanya ingin menghitung berapa banyak baris yang memiliki nilai sama di kolom <strong>rater1<\/strong> dan <strong>rater2<\/strong> :<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#count the number of rows where rater1 is equal to rater2\n<\/span><span style=\"color: #008000;\">len<\/span> ( <span style=\"color: #3366ff;\">df.query<\/span> (' <span style=\"color: #ff0000;\">rater1 ==rater2<\/span> '))\n\n4<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa ada <strong>4<\/strong> baris yang nilai kolom <strong>miss1<\/strong> dan <strong>miss2<\/strong> sama.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Pilih baris yang dua kolomnya tidak sama<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk memilih hanya baris-baris di DataFrame yang nilai kolom <strong>penilai1<\/strong> dan <strong>penilai2<\/strong> tidak sama:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#select rows where rater1 is not equal to rater2\n<\/span>df. <span style=\"color: #3366ff;\">query<\/span> (' <span style=\"color: #ff0000;\">rater1 !=rater2<\/span> ')\n\n painting rater1 rater2\n1 B Good Bad\n3 D Bad Good<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya garis dimana <strong>miss1<\/strong> dan <strong>miss2<\/strong> tidak sama yang dipilih.<\/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\/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>Anda dapat menggunakan metode berikut untuk memilih baris dalam pandas DataFrame di mana dua kolomnya (atau tidak) sama: Metode 1: Pilih baris yang dua kolomnya sama df. query (&#8216; column1 ==column2 &#8216;) Metode 2: Pilih baris yang dua kolomnya tidak sama df. query (&#8216; column1 !=column2 &#8216;) Contoh berikut menunjukkan cara menggunakan setiap metode dalam [&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>Pandas: pilih baris yang dua kolomnya sama \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memilih baris di pandas DataFrame di mana dua kolomnya sama, dengan 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\/panda-memilih-baris-atau-dua-kolom-yang-sama\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: pilih baris yang dua kolomnya sama \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memilih baris di pandas DataFrame di mana dua kolomnya sama, dengan contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-memilih-baris-atau-dua-kolom-yang-sama\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T11:15:50+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\/panda-memilih-baris-atau-dua-kolom-yang-sama\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-memilih-baris-atau-dua-kolom-yang-sama\/\",\"name\":\"Pandas: pilih baris yang dua kolomnya sama \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T11:15:50+00:00\",\"dateModified\":\"2023-07-15T11:15:50+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memilih baris di pandas DataFrame di mana dua kolomnya sama, dengan contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-memilih-baris-atau-dua-kolom-yang-sama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-memilih-baris-atau-dua-kolom-yang-sama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-memilih-baris-atau-dua-kolom-yang-sama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: pilih baris yang dua kolomnya sama\"}]},{\"@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":"Pandas: pilih baris yang dua kolomnya sama \u2013 Statorial","description":"Tutorial ini menjelaskan cara memilih baris di pandas DataFrame di mana dua kolomnya sama, dengan 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\/panda-memilih-baris-atau-dua-kolom-yang-sama\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: pilih baris yang dua kolomnya sama \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara memilih baris di pandas DataFrame di mana dua kolomnya sama, dengan contoh.","og_url":"https:\/\/statorials.org\/id\/panda-memilih-baris-atau-dua-kolom-yang-sama\/","og_site_name":"Statorials","article_published_time":"2023-07-15T11:15:50+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\/panda-memilih-baris-atau-dua-kolom-yang-sama\/","url":"https:\/\/statorials.org\/id\/panda-memilih-baris-atau-dua-kolom-yang-sama\/","name":"Pandas: pilih baris yang dua kolomnya sama \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T11:15:50+00:00","dateModified":"2023-07-15T11:15:50+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memilih baris di pandas DataFrame di mana dua kolomnya sama, dengan contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-memilih-baris-atau-dua-kolom-yang-sama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-memilih-baris-atau-dua-kolom-yang-sama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-memilih-baris-atau-dua-kolom-yang-sama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: pilih baris yang dua kolomnya sama"}]},{"@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\/3803"}],"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=3803"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3803\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3803"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3803"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}