{"id":2665,"date":"2023-07-21T06:47:49","date_gmt":"2023-07-21T06:47:49","guid":{"rendered":"https:\/\/statorials.org\/id\/pandas-fillna-dengan-maksud\/"},"modified":"2023-07-21T06:47:49","modified_gmt":"2023-07-21T06:47:49","slug":"pandas-fillna-dengan-maksud","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pandas-fillna-dengan-maksud\/","title":{"rendered":"Pandas: cara mengisi nilai nan dengan rata-rata (3 contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <strong>fillna()<\/strong> untuk mengganti nilai NaN di pandas DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut tiga cara umum untuk menggunakan fitur ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Cara 1: Isikan nilai NaN pada kolom dengan rata-rata<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[' <span style=\"color: #ff0000;\">col1<\/span> '] = df[' <span style=\"color: #ff0000;\">col1<\/span> ']. <span style=\"color: #3366ff;\">fillna<\/span> (df[' <span style=\"color: #ff0000;\">col1<\/span> ']. <span style=\"color: #3366ff;\">mean<\/span> ())<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Isi nilai NaN di beberapa kolom dengan rata-rata<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[[' <span style=\"color: #ff0000;\">col1<\/span> ', ' <span style=\"color: #ff0000;\">col2<\/span> ']] = df[[' <span style=\"color: #ff0000;\">col1<\/span> ', ' <span style=\"color: #ff0000;\">col2<\/span> ']]. <span style=\"color: #3366ff;\">fillna<\/span> (df[[' <span style=\"color: #ff0000;\">col1<\/span> ',' <span style=\"color: #ff0000;\">col2<\/span> ']]. <span style=\"color: #3366ff;\">mean<\/span> ())<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Cara 3: Isi nilai NaN di semua kolom dengan rata-rata<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df = df. <span style=\"color: #3366ff;\">fillna<\/span> ( <span style=\"color: #3366ff;\">df.mean<\/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> numpy <span style=\"color: #107d3f;\">as<\/span> np\n<span style=\"color: #107d3f;\">import<\/span> pandas <span style=\"color: #107d3f;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#create DataFrame with some NaN values<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">rating<\/span> ': [np.nan, 85, np.nan, 88, 94, 90, 76, 75, 87, 86],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [25, np.nan, 14, 16, 27, 20, 12, 15, 14, 19],\n                   ' <span style=\"color: #ff0000;\">assists<\/span> ': [5, 7, 7, np.nan, 5, 7, 6, 9, 9, 5],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [11, 8, 10, 6, 6, 9, 6, 10, 10, 7]})\n<span style=\"color: #008080;\">\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<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Isikan nilai NaN pada kolom dengan rata-rata<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengisi nilai NaN pada kolom <strong>rating<\/strong> dengan nilai rata-rata kolom <strong>rating<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#fill NaNs with column mean in 'rating' column<\/span>\n<span style=\"color: #008080;\"><span style=\"color: #000000;\">df[' <span style=\"color: #ff0000;\">rating<\/span> '] = df[' <span style=\"color: #ff0000;\">rating<\/span> ']. <span style=\"color: #3366ff;\">fillna<\/span> (df[' <span style=\"color: #ff0000;\">rating<\/span> ']. <span style=\"color: #3366ff;\">mean<\/span> ())\n\n<\/span>#view updated DataFrame<\/span>\ndf\n\n\trating points assists rebounds\n0 85.125 25.0 5.0 11\n1 85,000 NaN 7.0 8\n2 85.125 14.0 7.0 10\n3 88,000 16.0 NaN 6\n4 94,000 27.0 5.0 6\n5 90,000 20.0 7.0 9\n6 76,000 12.0 6.0 6\n7 75,000 15.0 9.0 10\n8 87,000 14.0 9.0 10\n9 86,000 19.0 5.0 7\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Nilai rata-rata pada kolom <strong>rating<\/strong> adalah <strong>85.125<\/strong> , sehingga setiap nilai NaN pada kolom <strong>rating<\/strong> diisi dengan nilai tersebut.<\/span><\/p>\n<h3> <strong>Contoh 2:<\/strong> <span style=\"color: #000000;\"><strong>Isi nilai NaN di beberapa kolom dengan rata-rata<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengisi nilai NaN pada kolom <strong>rating<\/strong> dan <strong>poin<\/strong> dengan rata-rata kolomnya masing-masing:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#fill NaNs with column means in 'rating' and 'points' columns<\/span>\ndf[[' <span style=\"color: #ff0000;\">rating<\/span> ', ' <span style=\"color: #ff0000;\">points<\/span> ']] = df[[' <span style=\"color: #ff0000;\">rating<\/span> ', ' <span style=\"color: #ff0000;\">points<\/span> ']]. <span style=\"color: #3366ff;\">fillna<\/span> (df[[' <span style=\"color: #ff0000;\">rating<\/span> ',' <span style=\"color: #ff0000;\">points<\/span> ']]. <span style=\"color: #3366ff;\">mean<\/span> ())\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span>df\n\n\trating points assists rebounds\n0 85.125 25.0 5.0 11\n1 85,000 18.0 7.0 8\n2 85.125 14.0 7.0 10\n3 88,000 16.0 NaN 6\n4 94,000 27.0 5.0 6\n5 90,000 20.0 7.0 9\n6 76,000 12.0 6.0 6\n7 75,000 15.0 9.0 10\n8 87,000 14.0 9.0 10\n9 86,000 19.0 5.0 7\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Nilai NaN pada kolom <strong>nilai<\/strong> dan <strong>poin<\/strong> telah diisi dengan rata-rata kolomnya masing-masing.<\/span><\/p>\n<h3> <strong>Contoh 3: Isi nilai NaN di semua kolom dengan rata-rata<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengisi nilai NaN di setiap kolom dengan rata-rata kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#fill NaNs with column means in each column<\/span> \ndf = df. <span style=\"color: #3366ff;\">fillna<\/span> ( <span style=\"color: #3366ff;\">df.mean<\/span> ())\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span>df\n\n        rating points assists rebounds\n0 85.125 25.0 5.000000 11\n1 85,000 18.0 7,000000 8\n2 85.125 14.0 7.000000 10\n3 88,000 16.0 6.666667 6\n4 94,000 27.0 5,000000 6\n5 90,000 20.0 7,000000 9\n6 76,000 12.0 6,000000 6\n7 75,000 15.0 9,000000 10\n8 87,000 14.0 9,000000 10\n9 86,000 19.0 5,000000 7\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai NaN pada setiap kolom telah diisi dengan rata-rata kolomnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menemukan dokumentasi online lengkap untuk fungsi <strong>fillna()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.DataFrame.fillna.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-menghitung-nilai-yang-hilang\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung nilai yang hilang di panda<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jatuhkan-panda\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus baris dengan nilai NaN di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-dengan-nilai\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus baris yang berisi nilai tertentu di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi fillna() untuk mengganti nilai NaN di pandas DataFrame. Berikut tiga cara umum untuk menggunakan fitur ini: Cara 1: Isikan nilai NaN pada kolom dengan rata-rata df[&#8216; col1 &#8216;] = df[&#8216; col1 &#8216;]. fillna (df[&#8216; col1 &#8216;]. mean ()) Metode 2: Isi nilai NaN di beberapa kolom dengan rata-rata df[[&#8216; col1 &#8216;, [&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 mengisi nilai NaN dengan rata-rata (3 contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengisi nilai NaN dengan rata-rata di pandas DataFrame, 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\/pandas-fillna-dengan-maksud\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara mengisi nilai NaN dengan rata-rata (3 contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengisi nilai NaN dengan rata-rata di pandas DataFrame, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pandas-fillna-dengan-maksud\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T06:47:49+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\/pandas-fillna-dengan-maksud\/\",\"url\":\"https:\/\/statorials.org\/id\/pandas-fillna-dengan-maksud\/\",\"name\":\"Pandas: Cara mengisi nilai NaN dengan rata-rata (3 contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T06:47:49+00:00\",\"dateModified\":\"2023-07-21T06:47:49+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengisi nilai NaN dengan rata-rata di pandas DataFrame, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pandas-fillna-dengan-maksud\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pandas-fillna-dengan-maksud\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-fillna-dengan-maksud\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara mengisi nilai nan dengan rata-rata (3 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":"Pandas: Cara mengisi nilai NaN dengan rata-rata (3 contoh) - Statorials","description":"Tutorial ini menjelaskan cara mengisi nilai NaN dengan rata-rata di pandas DataFrame, 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\/pandas-fillna-dengan-maksud\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara mengisi nilai NaN dengan rata-rata (3 contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara mengisi nilai NaN dengan rata-rata di pandas DataFrame, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/pandas-fillna-dengan-maksud\/","og_site_name":"Statorials","article_published_time":"2023-07-21T06:47:49+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\/pandas-fillna-dengan-maksud\/","url":"https:\/\/statorials.org\/id\/pandas-fillna-dengan-maksud\/","name":"Pandas: Cara mengisi nilai NaN dengan rata-rata (3 contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T06:47:49+00:00","dateModified":"2023-07-21T06:47:49+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengisi nilai NaN dengan rata-rata di pandas DataFrame, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pandas-fillna-dengan-maksud\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pandas-fillna-dengan-maksud\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pandas-fillna-dengan-maksud\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara mengisi nilai nan dengan rata-rata (3 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\/2665"}],"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=2665"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2665\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}