{"id":2577,"date":"2023-07-21T16:06:41","date_gmt":"2023-07-21T16:06:41","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-menjatuhkan-duplikat-beberapa-kolom\/"},"modified":"2023-07-21T16:06:41","modified_gmt":"2023-07-21T16:06:41","slug":"panda-menjatuhkan-duplikat-beberapa-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-menjatuhkan-duplikat-beberapa-kolom\/","title":{"rendered":"Pandas: cara menghapus duplikat di banyak kolom"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk menghapus baris duplikat di beberapa kolom di pandas DataFrame:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Hapus duplikat di semua kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">drop_duplicates<\/span> ()\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Hapus duplikat di kolom tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">drop_duplicates<\/span> ([' <span style=\"color: #ff0000;\">column1<\/span> ',' <span style=\"color: #ff0000;\">column3<\/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: #107d3f;\">import<\/span> pandas <span style=\"color: #107d3f;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame\n<\/span>df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">region<\/span> ': ['East', 'East', 'East', 'West', 'West', 'West'],\n                   ' <span style=\"color: #ff0000;\">store<\/span> ': [1, 1, 2, 1, 2, 2],\n                   ' <span style=\"color: #ff0000;\">sales<\/span> ': [5, 5, 7, 9, 12, 8]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  region store sales\n0 East 1 5\n1 East 1 5\n2 East 2 7\n3 West 1 9\n4 West 2 12\n5 West 2 8<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Hapus duplikat di semua kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menghapus baris dengan nilai duplikat di semua kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#drop rows that have duplicate values across all columns\n<\/span>df. <span style=\"color: #3366ff;\">drop_duplicates<\/span> ()\n\n\tregion store sales\n0 East 1 5\n2 East 2 7\n3 West 1 9\n4 West 2 12\n5 West 2 8\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Baris pada posisi indeks 1 memiliki nilai yang sama di semua kolom dengan baris pada posisi indeks 0, sehingga dihapus dari DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Secara default, panda menyimpan baris pertama sebagai duplikat. Namun, Anda dapat menggunakan argumen <strong>keep<\/strong> untuk menentukan agar baris duplikat terakhir dipertahankan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#drop rows that have duplicate values across all columns (keep last duplicate)\n<\/span>df. <span style=\"color: #3366ff;\">drop_duplicates<\/span> (keep=' <span style=\"color: #ff0000;\">last<\/span> ')\n\n\tregion store sales\n1 East 1 5\n2 East 2 7\n3 West 1 9\n4 West 2 12\n5 West 2 8<\/span><\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Hapus duplikat di kolom tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan kode berikut untuk menghapus baris dengan nilai duplikat hanya di kolom <strong>wilayah<\/strong> dan <strong>penyimpanan<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#drop rows that have duplicate values across region and store columns\n<\/span>df. <span style=\"color: #3366ff;\">drop_duplicates<\/span> ([' <span style=\"color: #ff0000;\">region<\/span> ',' <span style=\"color: #ff0000;\">store<\/span> '])\n\n\tregion store sales\n0 East 1 5\n2 East 2 7\n3 West 1 9\n4 West 2 12\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Secara total, dua baris telah dihapus dari DataFrame karena berisi nilai duplikat di kolom <strong>Wilayah<\/strong> dan <strong>Penyimpanan<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi <strong>drop_duplications()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.DataFrame.drop_duplicates.html\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/panda-menemukan-duplikat\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan duplikat di panda<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-menjatuhkan-kolom-duplikat\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus kolom duplikat di Pandas<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-pertama\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus baris pertama di Pandas DataFrame<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk menghapus baris duplikat di beberapa kolom di pandas DataFrame: Metode 1: Hapus duplikat di semua kolom df. drop_duplicates () Metode 2: Hapus duplikat di kolom tertentu df. drop_duplicates ([&#8216; column1 &#8216;,&#8217; column3 &#8216;]) Contoh berikut menunjukkan cara menggunakan setiap metode dalam praktik dengan pandas DataFrame berikut: import pandas as [&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 menghapus duplikat di banyak kolom \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus baris duplikat di beberapa kolom 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\/panda-menjatuhkan-duplikat-beberapa-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara menghapus duplikat di banyak kolom \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus baris duplikat di beberapa kolom di panda, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-menjatuhkan-duplikat-beberapa-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T16:06:41+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-menjatuhkan-duplikat-beberapa-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-menjatuhkan-duplikat-beberapa-kolom\/\",\"name\":\"Pandas: Cara menghapus duplikat di banyak kolom \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T16:06:41+00:00\",\"dateModified\":\"2023-07-21T16:06:41+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus baris duplikat di beberapa kolom di panda, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-menjatuhkan-duplikat-beberapa-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-menjatuhkan-duplikat-beberapa-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-menjatuhkan-duplikat-beberapa-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menghapus duplikat di banyak kolom\"}]},{\"@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 menghapus duplikat di banyak kolom \u2013 Statorial","description":"Tutorial ini menjelaskan cara menghapus baris duplikat di beberapa kolom 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\/panda-menjatuhkan-duplikat-beberapa-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menghapus duplikat di banyak kolom \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menghapus baris duplikat di beberapa kolom di panda, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-menjatuhkan-duplikat-beberapa-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-21T16:06:41+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-menjatuhkan-duplikat-beberapa-kolom\/","url":"https:\/\/statorials.org\/id\/panda-menjatuhkan-duplikat-beberapa-kolom\/","name":"Pandas: Cara menghapus duplikat di banyak kolom \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T16:06:41+00:00","dateModified":"2023-07-21T16:06:41+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus baris duplikat di beberapa kolom di panda, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-menjatuhkan-duplikat-beberapa-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-menjatuhkan-duplikat-beberapa-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-menjatuhkan-duplikat-beberapa-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menghapus duplikat di banyak kolom"}]},{"@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\/2577"}],"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=2577"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2577\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}