{"id":895,"date":"2023-07-28T09:46:04","date_gmt":"2023-07-28T09:46:04","guid":{"rendered":"https:\/\/statorials.org\/id\/jatuhkan-panda\/"},"modified":"2023-07-28T09:46:04","modified_gmt":"2023-07-28T09:46:04","slug":"jatuhkan-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jatuhkan-panda\/","title":{"rendered":"Cara menghapus baris dengan nilai nan di pandas"},"content":{"rendered":"

<\/p>\n

\n

Seringkali Anda mungkin ingin menghapus baris yang berisi nilai NaN di pandas DataFrame. Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi pandas dropna()<\/a> .<\/span><\/p>\n

Tutorial ini menunjukkan beberapa contoh penggunaan fungsi ini pada pandas DataFrame berikut:<\/span><\/p>\n

 import<\/span> numpy as<\/span> np\nimport<\/span> scipy.stats as<\/span> stats\n\n#create DataFrame with some NaN values<\/span>\ndf = pd.DataFrame({'rating': [np.nan, 85, np.nan, 88, 94, 90, 76, 75, 87, 86],\n                   'points': [np.nan, 25, 14, 16, 27, 20, 12, 15, 14, 19],\n                   'assists': [5, 7, 7, np.nan, 5, 7, 6, 9, 9, 5],\n                   'rebounds': [11, 8, 10, 6, 6, 9, 6, 10, 10, 7]})\n\n#view DataFrame\n<\/span>df\n\n\n        rating points assists rebounds\n0 NaN NaN 5.0 11\n1 85.0 25.0 7.0 8\n2 NaN 14.0 7.0 10\n3 88.0 16.0 NaN 6\n4 94.0 27.0 5.0 6\n5 90.0 20.0 7.0 9\n6 76.0 12.0 6.0 6\n7 75.0 15.0 9.0 10\n8 87.0 14.0 9.0 10\n9 86.0 19.0 5.0 7\n<\/strong><\/pre>\n
 Contoh 1: Hapus baris dengan nilai NaN<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan sintaks berikut untuk menghapus semua baris yang mengandung nilai<\/em> NaN :<\/span><\/p>\n
 df. dropna<\/span> ()\n\n\trating points assists rebounds\n1 85.0 25.0 7.0 8\n4 94.0 27.0 5.0 6\n5 90.0 20.0 7.0 9\n6 76.0 12.0 6.0 6\n7 75.0 15.0 9.0 10\n8 87.0 14.0 9.0 10\n9 86.0 19.0 5.0 7\n<\/strong><\/pre>\n
 Contoh 2: Hapus baris dengan semua nilai NaN<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan sintaks berikut untuk menghapus semua baris yang berisi semua<\/em> nilai NaN di setiap kolom:<\/span><\/p>\n
 df. dropna<\/span> (how=' all<\/span> ') \n\n        rating points assists rebounds\n0 NaN NaN 5.0 11\n1 85.0 25.0 7.0 8\n2 NaN 14.0 7.0 10\n3 88.0 16.0 NaN 6\n4 94.0 27.0 5.0 6\n5 90.0 20.0 7.0 9\n6 76.0 12.0 6.0 6\n7 75.0 15.0 9.0 10\n8 87.0 14.0 9.0 10\n9 86.0 19.0 5.0 7\n<\/strong><\/pre>\n
 Tidak ada baris dengan semua nilai NaN di DataFrame khusus ini, jadi tidak ada baris yang dihapus.<\/span><\/p>\n
 Contoh 3: Hapus baris di bawah ambang batas tertentu<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan sintaks berikut untuk menghapus semua baris yang tidak memiliki setidaknya<\/em> sejumlah nilai non-NaN tertentu:<\/span><\/p>\n
 df. dropna<\/span> (thresh= 3<\/span> ) \n\n\trating points assists rebounds\n1 85.0 25.0 7.0 8\n2 NaN 14.0 7.0 10\n3 88.0 16.0 NaN 6\n4 94.0 27.0 5.0 6\n5 90.0 20.0 7.0 9\n6 76.0 12.0 6.0 6\n7 75.0 15.0 9.0 10\n8 87.0 14.0 9.0 10\n9 86.0 19.0 5.0 7\n<\/strong><\/pre>\n
 Baris pertama dari DataFrame asli tidak berisi setidaknya 3 nilai non-NaN, jadi itulah satu-satunya baris yang dihapus.<\/span><\/p>\n
 Contoh 4: Hapus baris dengan nilai Nan di kolom tertentu<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan sintaks berikut untuk menghapus semua baris yang memiliki nilai NaN di kolom tertentu:<\/span><\/p>\n
 df. dropna<\/span> (subset=[' assists<\/span> '])\n\n\trating points assists rebounds\n0 NaN NaN 5.0 11\n1 85.0 25.0 7.0 8\n2 NaN 14.0 7.0 10\n4 94.0 27.0 5.0 6\n5 90.0 20.0 7.0 9\n6 76.0 12.0 6.0 6\n7 75.0 15.0 9.0 10\n8 87.0 14.0 9.0 10\n9 86.0 19.0 5.0 7<\/strong><\/pre>\n
 Contoh 5: Reset indeks setelah menghapus baris dengan NaNs<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan sintaks berikut untuk mereset indeks DataFrame setelah menghapus baris dengan nilai NaN:<\/span><\/p>\n
 #drop all rows that have any NaN values<\/span>\ndf = df. dropna<\/span> ()\n\n#reset index of DataFrame<\/span>\ndf = df. reset_index<\/span> (drop=True)\n\n#view DataFrame<\/span>\ndf\n\n        rating points assists rebounds\n0 85.0 25.0 7.0 8\n1 94.0 27.0 5.0 6\n2 90.0 20.0 7.0 9\n3 76.0 12.0 6.0 6\n4 75.0 15.0 9.0 10\n5 87.0 14.0 9.0 10\n6 86.0 19.0 5.0 77<\/strong><\/pre>\n
 Anda dapat menemukan dokumentasi lengkap untuk fungsi dropna() di sini<\/a> .<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Seringkali Anda mungkin ingin menghapus baris yang berisi nilai NaN di pandas DataFrame. Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi pandas dropna() . Tutorial ini menunjukkan beberapa contoh penggunaan fungsi ini pada pandas DataFrame berikut: import numpy as np import scipy.stats as stats #create DataFrame with some NaN values df = pd.DataFrame({‘rating’: [np.nan, 85, […]<\/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":"\nCara menghapus baris dengan nilai NaN di Pandas<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara menghapus baris dengan nilai NaN di pandas DataFrame.\" \/>\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\/jatuhkan-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghapus baris dengan nilai NaN di Pandas\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara menghapus baris dengan nilai NaN di pandas DataFrame.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jatuhkan-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T09:46:04+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\/jatuhkan-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/jatuhkan-panda\/\",\"name\":\"Cara menghapus baris dengan nilai NaN di Pandas\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T09:46:04+00:00\",\"dateModified\":\"2023-07-28T09:46:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara menghapus baris dengan nilai NaN di pandas DataFrame.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jatuhkan-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jatuhkan-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jatuhkan-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus baris dengan nilai nan di pandas\"}]},{\"@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 menghapus baris dengan nilai NaN di Pandas","description":"Penjelasan sederhana tentang cara menghapus baris dengan nilai NaN di pandas DataFrame.","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\/jatuhkan-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghapus baris dengan nilai NaN di Pandas","og_description":"Penjelasan sederhana tentang cara menghapus baris dengan nilai NaN di pandas DataFrame.","og_url":"https:\/\/statorials.org\/id\/jatuhkan-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-28T09:46:04+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\/jatuhkan-panda\/","url":"https:\/\/statorials.org\/id\/jatuhkan-panda\/","name":"Cara menghapus baris dengan nilai NaN di Pandas","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T09:46:04+00:00","dateModified":"2023-07-28T09:46:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara menghapus baris dengan nilai NaN di pandas DataFrame.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jatuhkan-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jatuhkan-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jatuhkan-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus baris dengan nilai nan di pandas"}]},{"@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\/895"}],"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=895"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/895\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}