{"id":2028,"date":"2023-07-24T00:47:19","date_gmt":"2023-07-24T00:47:19","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-fillna\/"},"modified":"2023-07-24T00:47:19","modified_gmt":"2023-07-24T00:47:19","slug":"panda-fillna","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-fillna\/","title":{"rendered":"Cara menggunakan pandas fillna() untuk mengganti nilai nan"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan fungsi fillna()<\/strong> untuk mengganti nilai NaN di DataFrame pandas.<\/span><\/p>\n

Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n

 #replace NaN values in one column<\/span>\ndf[' col1<\/span> '] = df[' col1<\/span> ']. fillna<\/span> (0)\n\n#replace NaN values in multiple columns\n<\/span>df[[' col1<\/span> ', ' col2<\/span> ']] = df[[' col1<\/span> ', ' col2<\/span> ']]. fillna<\/span> (0) \n\n#replace NaN values in all columns<\/span>\ndf = df. fillna<\/span> (0)<\/strong><\/pre>\n
 Tutorial ini menjelaskan cara menggunakan fungsi ini dengan pandas DataFrame berikut:<\/span><\/p>\n
 import<\/span> numpy as<\/span> np\nimport<\/span> pandas as<\/span> pd\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': [25, np.nan, 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<\/span>\ndf\n\n        rating points assists rebounds\n0 NaN 25.0 5.0 11\n1 85.0 NaN 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: Ganti nilai NaN dalam kolom<\/strong><\/span><\/h3>\n
 Kode berikut menunjukkan cara mengganti nilai NaN dengan angka nol pada kolom “catatan”:<\/span><\/p>\n
 #replace NaNs with zeros in 'rating' column<\/span>\ndf[' rating<\/span> '] = df[' rating<\/span> ']. fillna<\/span> (0)\n\n#view DataFrame<\/span>\ndf\n\n\trating points assists rebounds\n0 0.0 25.0 5.0 11\n1 85.0 NaN 7.0 8\n2 0.0 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 2: Ganti nilai NaN di beberapa kolom<\/strong><\/h3>\n
 Kode berikut menunjukkan cara mengganti nilai NaN dengan angka nol pada kolom \u201cnilai\u201d dan \u201cpoin\u201d:<\/span><\/p>\n
 #replace NaNs with zeros in 'rating' and 'points' columns<\/span>\ndf[[' rating<\/span> ', ' points<\/span> ']] = df[[' rating<\/span> ', ' points<\/span> ']]. fillna<\/span> (0)\n\n#view DataFrame\n<\/span>df\n\n\trating points assists rebounds\n0 0.0 25.0 5.0 11\n1 85.0 0.0 7.0 8\n2 0.0 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 3: Ganti nilai NaN di semua kolom<\/strong><\/h3>\n
 Kode berikut menunjukkan cara mengganti nilai NaN di setiap kolom dengan angka nol:<\/span><\/p>\n
 #replace NaNs with zeros in all columns<\/span> \ndf = df. fillna<\/span> (0)\n\n#view DataFrame\n<\/span>df\n\n        rating points assists rebounds\n0 0.0 25.0 5.0 11\n1 85.0 0.0 7.0 8\n2 0.0 14.0 7.0 10\n3 88.0 16.0 0.0 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
 Anda dapat menemukan dokumentasi online lengkap untuk fungsi fillna()<\/strong> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di panda:<\/span><\/p>\n
 Cara menghitung nilai yang hilang di panda<\/a>
 Cara menghapus baris dengan nilai NaN di Pandas<\/a>
 Cara menghapus baris yang berisi nilai tertentu di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan fungsi fillna() untuk mengganti nilai NaN di DataFrame pandas. Fungsi ini menggunakan sintaks dasar berikut: #replace NaN values in one column df[‘ col1 ‘] = df[‘ col1 ‘]. fillna (0) #replace NaN values in multiple columns df[[‘ col1 ‘, ‘ col2 ‘]] = df[[‘ col1 ‘, ‘ col2 ‘]]. fillna (0) #replace […]<\/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 menggunakan Pandas fillna() untuk menggantikan nilai NaN \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi pandas fillna() untuk mengganti nilai NaN di DataFrame, beserta 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-fillna\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan Pandas fillna() untuk menggantikan nilai NaN \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi pandas fillna() untuk mengganti nilai NaN di DataFrame, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-fillna\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T00:47:19+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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/panda-fillna\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-fillna\/\",\"name\":\"Cara menggunakan Pandas fillna() untuk menggantikan nilai NaN \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T00:47:19+00:00\",\"dateModified\":\"2023-07-24T00:47:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi pandas fillna() untuk mengganti nilai NaN di DataFrame, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-fillna\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-fillna\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-fillna\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan pandas fillna() untuk mengganti nilai nan\"}]},{\"@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 menggunakan Pandas fillna() untuk menggantikan nilai NaN \u2013 Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi pandas fillna() untuk mengganti nilai NaN di DataFrame, beserta 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-fillna\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan Pandas fillna() untuk menggantikan nilai NaN \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi pandas fillna() untuk mengganti nilai NaN di DataFrame, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/panda-fillna\/","og_site_name":"Statorials","article_published_time":"2023-07-24T00:47:19+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/panda-fillna\/","url":"https:\/\/statorials.org\/id\/panda-fillna\/","name":"Cara menggunakan Pandas fillna() untuk menggantikan nilai NaN \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T00:47:19+00:00","dateModified":"2023-07-24T00:47:19+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi pandas fillna() untuk mengganti nilai NaN di DataFrame, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-fillna\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-fillna\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-fillna\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan pandas fillna() untuk mengganti nilai nan"}]},{"@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\/2028"}],"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=2028"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2028\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2028"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2028"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}