{"id":3772,"date":"2023-07-15T15:33:27","date_gmt":"2023-07-15T15:33:27","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-memilih-baris-dengan-nan\/"},"modified":"2023-07-15T15:33:27","modified_gmt":"2023-07-15T15:33:27","slug":"panda-memilih-baris-dengan-nan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-memilih-baris-dengan-nan\/","title":{"rendered":"Cara memilih baris dengan nilai nan di pandas (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan metode berikut untuk memilih baris dengan nilai NaN di panda:<\/span><\/p>\n

Metode 1: Pilih Baris dengan Nilai NaN di Kolom Mana Pun<\/strong><\/span><\/p>\n

 df. loc<\/span> [df. isnull<\/span> (). any<\/span> (axis= 1<\/span> )]\n<\/strong><\/pre>\n
 Metode 2: Pilih baris dengan nilai NaN di kolom tertentu<\/strong><\/span><\/p>\n
 df. loc<\/span> [df[' this_column<\/span> ']. isnull<\/span> ()]<\/strong><\/span><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan setiap metode dalam praktik dengan pandas DataFrame berikut:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\nimport<\/span> numpy as<\/span> np\n\n#createDataFrame<\/span>\ndf = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H'],\n                   ' points<\/span> ': [18, np.NaN, 19, 14, 14, 11, 20, 28],\n                   ' assists<\/span> ': [5, 7, 7, 9, np.NaN, 9, 9, np.NaN],\n                   ' rebounds<\/span> ': [11, 8, 10, 6, 6, 5, 9, np.NaN]})\n\n#view DataFrame\n<\/span>print<\/span> (df)<\/strong><\/pre>\n
 Contoh 1: Pilih baris dengan nilai NaN di kolom mana pun<\/strong><\/span><\/h2>\n
 Kita dapat menggunakan sintaks berikut untuk memilih baris dengan nilai NaN di kolom mana pun di DataFrame:<\/span><\/p>\n
 #create new DataFrame that only contains rows with NaNs in any column\n<\/span>df_nan_rows = df. loc<\/span> [df. isnull<\/span> (). any<\/span> (axis= 1<\/span> )]\n\n#view results\n<\/span>print<\/span> (df_nan_rows)\n\n  team points assists rebounds\n1 B NaN 7.0 8.0\n4 E 14.0 NaN 6.0\n7 H 28.0 NaN NaN   \n<\/strong><\/pre>\n
 Perhatikan bahwa setiap baris DataFrame yang dihasilkan berisi nilai NaN di setidaknya satu kolom.<\/span><\/p>\n
 Contoh 2: Pilih baris dengan nilai NaN di kolom tertentu<\/strong><\/span><\/h2>\n
 Kita dapat menggunakan sintaks berikut untuk memilih baris dengan nilai NaN di kolom pembantu<\/strong> DataFrame:<\/span><\/p>\n
 #create new DataFrame that only contains rows with NaNs in assists column\n<\/span>df_assists_nans = df. loc<\/span> [df[' assists<\/span> ']. isnull<\/span> ()]\n#view results\n<\/span>print<\/span> (df_assists_nans)\n\n  team points assists rebounds\n4 E 14.0 NaN 6.0\n7 H 28.0 NaN NaN   \n<\/strong><\/pre>\n
 Perhatikan bahwa setiap baris DataFrame yang dihasilkan berisi nilai NaN di kolom pembantu<\/strong> .<\/span><\/p>\n
 Terdapat baris dengan nilai NaN pada kolom poin<\/strong> , namun baris tersebut tidak dipilih karena juga tidak memiliki nilai NaN pada kolom assist<\/strong> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di panda:<\/span><\/p>\n
 Pandas: Cara menghapus baris dengan nilai NaN<\/a>
 Pandas: cara mengganti nilai NaN dengan string<\/a>
 Pandas: cara mengisi nilai NaN dengan rata-rata<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan metode berikut untuk memilih baris dengan nilai NaN di panda: Metode 1: Pilih Baris dengan Nilai NaN di Kolom Mana Pun df. loc [df. isnull (). any (axis= 1 )] Metode 2: Pilih baris dengan nilai NaN di kolom tertentu df. loc [df[‘ this_column ‘]. isnull ()] Contoh berikut menunjukkan cara menggunakan […]<\/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 memilih baris dengan nilai NaN di Pandas (dengan contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memilih semua baris dengan nilai NaN di pandas DataFrame, termasuk contohnya.\" \/>\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-dengan-nan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara memilih baris dengan nilai NaN di Pandas (dengan contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memilih semua baris dengan nilai NaN di pandas DataFrame, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-memilih-baris-dengan-nan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T15:33:27+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-dengan-nan\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-memilih-baris-dengan-nan\/\",\"name\":\"Cara memilih baris dengan nilai NaN di Pandas (dengan contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T15:33:27+00:00\",\"dateModified\":\"2023-07-15T15:33:27+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memilih semua baris dengan nilai NaN di pandas DataFrame, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-memilih-baris-dengan-nan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-memilih-baris-dengan-nan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-memilih-baris-dengan-nan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memilih baris dengan nilai nan di pandas (dengan contoh)\"}]},{\"@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 memilih baris dengan nilai NaN di Pandas (dengan contoh) - Statorials","description":"Tutorial ini menjelaskan cara memilih semua baris dengan nilai NaN di pandas DataFrame, termasuk contohnya.","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-dengan-nan\/","og_locale":"id_ID","og_type":"article","og_title":"Cara memilih baris dengan nilai NaN di Pandas (dengan contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara memilih semua baris dengan nilai NaN di pandas DataFrame, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/panda-memilih-baris-dengan-nan\/","og_site_name":"Statorials","article_published_time":"2023-07-15T15:33:27+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-dengan-nan\/","url":"https:\/\/statorials.org\/id\/panda-memilih-baris-dengan-nan\/","name":"Cara memilih baris dengan nilai NaN di Pandas (dengan contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T15:33:27+00:00","dateModified":"2023-07-15T15:33:27+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memilih semua baris dengan nilai NaN di pandas DataFrame, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-memilih-baris-dengan-nan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-memilih-baris-dengan-nan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-memilih-baris-dengan-nan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memilih baris dengan nilai nan di pandas (dengan contoh)"}]},{"@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\/3772"}],"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=3772"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3772\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}