{"id":3443,"date":"2023-07-17T11:18:50","date_gmt":"2023-07-17T11:18:50","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-menghapus-duplikat-pertahankan-maks\/"},"modified":"2023-07-17T11:18:50","modified_gmt":"2023-07-17T11:18:50","slug":"panda-menghapus-duplikat-pertahankan-maks","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-menghapus-duplikat-pertahankan-maks\/","title":{"rendered":"Pandas: cara menghapus duplikat sekaligus menjaga baris dengan nilai maksimal"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan metode berikut untuk menghapus duplikat di pandas DataFrame tetapi pertahankan baris yang berisi nilai maksimum di kolom tertentu:<\/span><\/p>\n

Metode 1: Hapus Duplikat di Kolom dan Pertahankan Baris dengan Maks<\/strong><\/span><\/p>\n

 df. sort_values<\/span> (' var2<\/span> ', ascending= False<\/span> ). drop_duplicates<\/span> (' var1<\/span> '). sort_index<\/span> ()\n<\/strong><\/pre>\n
 Metode 2: Hapus Duplikat di Beberapa Kolom dan Pertahankan Baris dengan Maks<\/strong><\/span><\/p>\n
 df. sort_values<\/span> (' var3<\/span> ', ascending= False<\/span> ). drop_duplicates<\/span> ([' var1<\/span> ', ' var2<\/span> ']). sort_index<\/span> ()<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan masing-masing metode dalam praktik.<\/span><\/p>\n
 Contoh 1: Hapus duplikat dalam kolom dan pertahankan baris dengan Max<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang poin yang dicetak oleh pemain bola basket dari tim berbeda:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame\ndf = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'A', 'A', 'B', 'B', 'B', 'C', 'C', 'C'],\n                   ' points<\/span> ': [20, 24, 28, 30, 14, 19, 29, 40, 22]})\n\n#view DataFrame\n<\/span>print<\/span> (df)\n\n  team points\n0 to 20\n1 to 24\n2 to 28\n3 B 30\n4 B 14\n5 B 19\n6 C 29\n7 C 40\n8 C 22\n<\/span><\/span><\/strong><\/pre>\n
 Kita dapat menggunakan sintaks berikut untuk menghapus baris dengan nama tim<\/strong> duplikat tetapi tetap mempertahankan baris dengan nilai poin<\/strong> maksimum :<\/span><\/p>\n
 #drop duplicate teams but keeps row with max points\n<\/span>df_new = df. sort_values<\/span> (' points<\/span> ', ascending= False<\/span> ). drop_duplicates<\/span> (' team<\/span> '). sort_index<\/span> ()\n\n#view DataFrame\n<\/span>print<\/span> (df_new)\n\n  team points\n2 to 28\n3 B 30\n7 C 40<\/span><\/span><\/strong><\/pre>\n
 Setiap baris dengan nama tim<\/strong> duplikat telah dihapus, namun baris dengan nilai poin<\/strong> maksimum dipertahankan untuk setiap tim<\/strong> .<\/span><\/p>\n
 Contoh 2: Hapus duplikat di beberapa kolom dan pertahankan baris dengan Maks<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki panda DataFrame berikut:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame\ndf = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'A', 'A', 'B', 'B', 'B', 'C', 'C', 'C'],\n                   ' position<\/span> ': ['G', 'G', 'F', 'G', 'F', 'F', 'G', 'G', 'F'],\n                   ' points<\/span> ': [20, 24, 28, 30, 14, 19, 29, 40, 22]})\n\n#view DataFrame\n<\/span>print<\/span> (df)\n\n  team position points\n0 AG 20\n1 GA 24\n2AF 28\n3 BG 30\n4 BF 14\n5 BF 19\n6 GC 29\n7 GC 40\n8 CF 22\n<\/span><\/span><\/strong><\/pre>\n
 Kita dapat menggunakan sintaks berikut untuk menghapus baris dengan nama tim<\/strong> dan<\/em> posisi<\/strong> duplikat, tetapi pertahankan baris dengan nilai poin<\/strong> maksimum :<\/span><\/p>\n
 #drop rows with duplicate team and positions but keeps row with max points\n<\/span>df_new = df. sort_values<\/span> (' points<\/span> ', ascending= False<\/span> ). drop_duplicates<\/span> ([' team<\/span> ',' position<\/span> ']). sort_index<\/span> ()\n\n#view DataFrame\n<\/span>print<\/span> (df_new)\n\n  team position points\n1 GA 24\n2AF 28\n3 BG 30\n5 BF 19\n7 GC 40\n8 CF 22<\/span><\/span><\/strong><\/pre>\n
 Setiap baris dengan nama tim<\/strong> dan posisi<\/strong> duplikat telah dihapus, tetapi baris dengan nilai poin<\/strong> maksimum dipertahankan untuk setiap kombinasi<\/strong> tim<\/strong> dan posisi.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di panda:<\/span><\/p>\n
 Cara menghapus baris duplikat di Pandas<\/a>
 Cara menghapus kolom duplikat di Pandas<\/a>
 Cara menghitung duplikat di panda<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan metode berikut untuk menghapus duplikat di pandas DataFrame tetapi pertahankan baris yang berisi nilai maksimum di kolom tertentu: Metode 1: Hapus Duplikat di Kolom dan Pertahankan Baris dengan Maks df. sort_values (‘ var2 ‘, ascending= False ). drop_duplicates (‘ var1 ‘). sort_index () Metode 2: Hapus Duplikat di Beberapa Kolom dan Pertahankan […]<\/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":"\nPandas: Cara menghapus duplikat sambil mempertahankan baris dengan nilai maksimum \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus duplikat di pandas DataFrame sambil mempertahankan baris dengan nilai maksimum di kolom tertentu.\" \/>\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-menghapus-duplikat-pertahankan-maks\/\" \/>\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 sambil mempertahankan baris dengan nilai maksimum \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus duplikat di pandas DataFrame sambil mempertahankan baris dengan nilai maksimum di kolom tertentu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-menghapus-duplikat-pertahankan-maks\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T11:18: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-menghapus-duplikat-pertahankan-maks\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-menghapus-duplikat-pertahankan-maks\/\",\"name\":\"Pandas: Cara menghapus duplikat sambil mempertahankan baris dengan nilai maksimum \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T11:18:50+00:00\",\"dateModified\":\"2023-07-17T11:18:50+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus duplikat di pandas DataFrame sambil mempertahankan baris dengan nilai maksimum di kolom tertentu.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-menghapus-duplikat-pertahankan-maks\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-menghapus-duplikat-pertahankan-maks\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-menghapus-duplikat-pertahankan-maks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menghapus duplikat sekaligus menjaga baris dengan nilai maksimal\"}]},{\"@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 sambil mempertahankan baris dengan nilai maksimum \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghapus duplikat di pandas DataFrame sambil mempertahankan baris dengan nilai maksimum di kolom tertentu.","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-menghapus-duplikat-pertahankan-maks\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menghapus duplikat sambil mempertahankan baris dengan nilai maksimum \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghapus duplikat di pandas DataFrame sambil mempertahankan baris dengan nilai maksimum di kolom tertentu.","og_url":"https:\/\/statorials.org\/id\/panda-menghapus-duplikat-pertahankan-maks\/","og_site_name":"Statorials","article_published_time":"2023-07-17T11:18: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-menghapus-duplikat-pertahankan-maks\/","url":"https:\/\/statorials.org\/id\/panda-menghapus-duplikat-pertahankan-maks\/","name":"Pandas: Cara menghapus duplikat sambil mempertahankan baris dengan nilai maksimum \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T11:18:50+00:00","dateModified":"2023-07-17T11:18:50+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus duplikat di pandas DataFrame sambil mempertahankan baris dengan nilai maksimum di kolom tertentu.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-menghapus-duplikat-pertahankan-maks\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-menghapus-duplikat-pertahankan-maks\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-menghapus-duplikat-pertahankan-maks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menghapus duplikat sekaligus menjaga baris dengan nilai maksimal"}]},{"@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\/3443"}],"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=3443"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3443\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3443"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3443"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3443"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}