{"id":3227,"date":"2023-07-18T14:10:40","date_gmt":"2023-07-18T14:10:40","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-mengisi-kolom-tertentu\/"},"modified":"2023-07-18T14:10:40","modified_gmt":"2023-07-18T14:10:40","slug":"panda-mengisi-kolom-tertentu","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-mengisi-kolom-tertentu\/","title":{"rendered":"Pandas: cara menggunakan fillna() dengan kolom tertentu"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut dengan <strong>fillna()<\/strong> untuk mengganti nilai NaN di kolom tertentu dari pandas DataFrame:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Gunakan fillna() dengan kolom tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[' <span style=\"color: #008000;\">col1<\/span> '] = df[' <span style=\"color: #008000;\">col1<\/span> ']. <span style=\"color: #3366ff;\">fillna<\/span> (0)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Gunakan fillna() dengan beberapa kolom tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[[' <span style=\"color: #008000;\">col1<\/span> ', ' <span style=\"color: #008000;\">col2<\/span> ']] = df[[' <span style=\"color: #008000;\">col1<\/span> ', ' <span style=\"color: #008000;\">col2<\/span> ']]. <span style=\"color: #3366ff;\">fillna<\/span> (0)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menggunakan fungsi ini 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> ({'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<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: Gunakan fillna() dengan kolom tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menggunakan <strong>fillna()<\/strong> untuk mengganti nilai NaN dengan angka nol hanya di kolom &#8220;catatan&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#replace NaNs with zeros in 'rating' column<\/span>\ndf[' <span style=\"color: #008000;\">rating<\/span> '] = df[' <span style=\"color: #008000;\">rating<\/span> ']. <span style=\"color: #3366ff;\">fillna<\/span> (0)\n<span style=\"color: #008080;\">\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<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai NaN diganti hanya di kolom &#8220;catatan&#8221; dan semua kolom lainnya dibiarkan utuh.<\/span><\/p>\n<h3> <strong>Contoh 2: Gunakan fillna<\/strong> <span style=\"color: #000000;\"><strong>() dengan beberapa kolom tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menggunakan <strong>fillna()<\/strong> untuk mengganti nilai NaN dengan angka nol di kolom &#8220;nilai&#8221; dan &#8220;poin&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#replace NaNs with zeros in 'rating' and 'points' columns<\/span>\ndf[[' <span style=\"color: #008000;\">rating<\/span> ', ' <span style=\"color: #008000;\">points<\/span> ']] = df[[' <span style=\"color: #008000;\">rating<\/span> ', ' <span style=\"color: #008000;\">points<\/span> ']]. <span style=\"color: #3366ff;\">fillna<\/span> (0)\n\n<span style=\"color: #008080;\">#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<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai NaN telah diganti di kolom &#8220;nilai&#8221; dan &#8220;poin&#8221; tetapi kolom lainnya tetap utuh.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas <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 metode berikut dengan fillna() untuk mengganti nilai NaN di kolom tertentu dari pandas DataFrame: Metode 1: Gunakan fillna() dengan kolom tertentu df[&#8216; col1 &#8216;] = df[&#8216; col1 &#8216;]. fillna (0) Metode 2: Gunakan fillna() dengan beberapa kolom tertentu df[[&#8216; col1 &#8216;, &#8216; col2 &#8216;]] = df[[&#8216; col1 &#8216;, &#8216; col2 &#8216;]]. fillna [&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 menggunakan fillna() dengan kolom tertentu \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi fillna() di panda untuk mengganti nilai di kolom tertentu, 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-mengisi-kolom-tertentu\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara menggunakan fillna() dengan kolom tertentu \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi fillna() di panda untuk mengganti nilai di kolom tertentu, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-mengisi-kolom-tertentu\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T14:10:40+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-mengisi-kolom-tertentu\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-mengisi-kolom-tertentu\/\",\"name\":\"Pandas: Cara menggunakan fillna() dengan kolom tertentu \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T14:10:40+00:00\",\"dateModified\":\"2023-07-18T14:10:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi fillna() di panda untuk mengganti nilai di kolom tertentu, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-mengisi-kolom-tertentu\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-mengisi-kolom-tertentu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-mengisi-kolom-tertentu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menggunakan fillna() dengan kolom tertentu\"}]},{\"@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 menggunakan fillna() dengan kolom tertentu \u2013 Statorial","description":"Tutorial ini menjelaskan cara menggunakan fungsi fillna() di panda untuk mengganti nilai di kolom tertentu, 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-mengisi-kolom-tertentu\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menggunakan fillna() dengan kolom tertentu \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi fillna() di panda untuk mengganti nilai di kolom tertentu, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/panda-mengisi-kolom-tertentu\/","og_site_name":"Statorials","article_published_time":"2023-07-18T14:10:40+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-mengisi-kolom-tertentu\/","url":"https:\/\/statorials.org\/id\/panda-mengisi-kolom-tertentu\/","name":"Pandas: Cara menggunakan fillna() dengan kolom tertentu \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T14:10:40+00:00","dateModified":"2023-07-18T14:10:40+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi fillna() di panda untuk mengganti nilai di kolom tertentu, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-mengisi-kolom-tertentu\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-mengisi-kolom-tertentu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-mengisi-kolom-tertentu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menggunakan fillna() dengan kolom tertentu"}]},{"@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\/3227"}],"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=3227"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3227\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}