{"id":3654,"date":"2023-07-16T07:44:59","date_gmt":"2023-07-16T07:44:59","guid":{"rendered":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-beberapa-kolom-sama\/"},"modified":"2023-07-16T07:44:59","modified_gmt":"2023-07-16T07:44:59","slug":"pandas-memeriksa-apakah-beberapa-kolom-sama","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-beberapa-kolom-sama\/","title":{"rendered":"Pandas: cara memeriksa apakah beberapa kolom sama"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk memeriksa apakah beberapa kolom sama di panda:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Periksa apakah semua kolom sama<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[' <span style=\"color: #ff0000;\">matching<\/span> '] = df. <span style=\"color: #3366ff;\">eq<\/span> (df. <span style=\"color: #3366ff;\">iloc<\/span> [:, 0], axis= <span style=\"color: #008000;\">0<\/span> ). <span style=\"color: #3366ff;\">all<\/span> (1)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Periksa apakah kolom tertentu sama<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[' <span style=\"color: #ff0000;\">matching<\/span> '] = df. <span style=\"color: #3366ff;\">apply<\/span> ( <span style=\"color: #008000;\">lambda<\/span> x: <span style=\"color: #3366ff;\">x.col1<\/span> == <span style=\"color: #3366ff;\">x.col3<\/span> == <span style=\"color: #3366ff;\">x.col4<\/span> , axis= <span style=\"color: #008000;\">1<\/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\n<\/span>df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">A<\/span> ': [4, 0, 3, 3, 6, 8, 7],\n                   ' <span style=\"color: #ff0000;\">B<\/span> ': [4, 2, 3, 5, 6, 4, 7],\n                   ' <span style=\"color: #ff0000;\">C<\/span> ': [4, 0, 3, 3, 5, 10, 7],\n                   ' <span style=\"color: #ff0000;\">D<\/span> ': [4, 0, 3, 3, 3, 8, 7]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n   ABCD\n0 4 4 4 4\n1 0 2 0 0\n2 3 3 3 3\n3 3 5 3 3\n4 6 6 5 3\n5 8 4 10 8\n6 7 7 7 7\n<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Periksa apakah semua kolom sama<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk memeriksa apakah nilai setiap kolom di DataFrame sama untuk setiap baris:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create new column that checks if all columns match in each row\n<\/span>df[' <span style=\"color: #ff0000;\">matching<\/span> '] = df. <span style=\"color: #3366ff;\">eq<\/span> (df. <span style=\"color: #3366ff;\">iloc<\/span> [:, 0], axis= <span style=\"color: #008000;\">0<\/span> ). <span style=\"color: #3366ff;\">all<\/span> (1)\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n   ABCD matching\n0 4 4 4 4 True\n1 0 2 0 0 False\n2 3 3 3 3 True\n3 3 5 3 3 False\n4 6 6 5 3 False\n5 8 4 10 8 False\n6 7 7 7 7 True\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Jika nilai setiap kolom sama, kolom terkait akan mengembalikan <strong>True<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika tidak, ia akan mengembalikan <strong>False<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda dapat mengonversi nilai <strong>Benar<\/strong> dan <strong>Salah<\/strong> menjadi <strong>1<\/strong> dan <strong>0<\/strong> menggunakan <strong>astype(int)<\/strong> sebagai berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create new column that checks if all columns match in each row\n<\/span>df[' <span style=\"color: #ff0000;\">matching<\/span> '] = df. <span style=\"color: #3366ff;\">eq<\/span> (df. <span style=\"color: #3366ff;\">iloc<\/span> [:, 0], axis= <span style=\"color: #008000;\">0<\/span> ). <span style=\"color: #3366ff;\">all<\/span> (1). <span style=\"color: #3366ff;\">astype<\/span> (int)\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n   ABCD matching\n0 4 4 4 4 1\n1 0 2 0 0 0\n2 3 3 3 3 1\n3 3 5 3 3 0\n4 6 6 5 3 0\n5 8 4 10 8 0\n6 7 7 7 7 1\n<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Periksa apakah kolom tertentu sama<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk memeriksa apakah nilai di kolom A, C, dan D DataFrame sama untuk setiap baris:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create new column that checks if values in columns A, C, and D are equal\n<\/span>df[' <span style=\"color: #ff0000;\">matching<\/span> '] = df. <span style=\"color: #3366ff;\">apply<\/span> ( <span style=\"color: #008000;\">lambda<\/span> x: x. <span style=\"color: #3366ff;\">A<\/span> == x. <span style=\"color: #3366ff;\">C<\/span> == x. <span style=\"color: #3366ff;\">D<\/span> , axis= <span style=\"color: #008000;\">1<\/span> )\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n   ABCD matching\n0 4 4 4 4 True\n1 0 2 0 0 True\n2 3 3 3 3 True\n3 3 5 3 3 True\n4 6 6 5 3 False\n5 8 4 10 8 False\n6 7 7 7 7 True\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Jika nilai di kolom A, C, dan D sama, kolom terkait akan mengembalikan <strong>True<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika tidak, ia akan mengembalikan <strong>False<\/strong> .<\/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 memeriksa apakah beberapa kolom sama di panda: Metode 1: Periksa apakah semua kolom sama df[&#8216; matching &#8216;] = df. eq (df. iloc [:, 0], axis= 0 ). all (1) Metode 2: Periksa apakah kolom tertentu sama df[&#8216; matching &#8216;] = df. apply ( lambda x: x.col1 == x.col3 == [&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: Cara memeriksa apakah beberapa kolom sama \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memeriksa apakah beberapa kolom sama di panda, 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\/pandas-memeriksa-apakah-beberapa-kolom-sama\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara memeriksa apakah beberapa kolom sama \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memeriksa apakah beberapa kolom sama di panda, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-beberapa-kolom-sama\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T07:44:59+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\/pandas-memeriksa-apakah-beberapa-kolom-sama\/\",\"url\":\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-beberapa-kolom-sama\/\",\"name\":\"Pandas: Cara memeriksa apakah beberapa kolom sama \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T07:44:59+00:00\",\"dateModified\":\"2023-07-16T07:44:59+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memeriksa apakah beberapa kolom sama di panda, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-beberapa-kolom-sama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-beberapa-kolom-sama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-beberapa-kolom-sama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara memeriksa apakah beberapa kolom 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: Cara memeriksa apakah beberapa kolom sama \u2013 Statorial","description":"Tutorial ini menjelaskan cara memeriksa apakah beberapa kolom sama di panda, 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\/pandas-memeriksa-apakah-beberapa-kolom-sama\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara memeriksa apakah beberapa kolom sama \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara memeriksa apakah beberapa kolom sama di panda, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-beberapa-kolom-sama\/","og_site_name":"Statorials","article_published_time":"2023-07-16T07:44:59+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\/pandas-memeriksa-apakah-beberapa-kolom-sama\/","url":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-beberapa-kolom-sama\/","name":"Pandas: Cara memeriksa apakah beberapa kolom sama \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T07:44:59+00:00","dateModified":"2023-07-16T07:44:59+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memeriksa apakah beberapa kolom sama di panda, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-beberapa-kolom-sama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-beberapa-kolom-sama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-beberapa-kolom-sama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara memeriksa apakah beberapa kolom 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\/3654"}],"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=3654"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3654\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}