{"id":2380,"date":"2023-07-22T12:59:53","date_gmt":"2023-07-22T12:59:53","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-ganti-nan-dengan-thong\/"},"modified":"2023-07-22T12:59:53","modified_gmt":"2023-07-22T12:59:53","slug":"panda-ganti-nan-dengan-thong","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-ganti-nan-dengan-thong\/","title":{"rendered":"Pandas: cara mengganti nilai nan dengan string"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk mengganti nilai NaN dengan string di pandas DataFrame:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Ganti nilai NaN dengan string di seluruh DataFrame<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">fillna<\/span> ('', inplace= <span style=\"color: #008000;\">True<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Ganti nilai NaN dengan string di kolom tertentu<\/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> ('')<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: Ganti nilai NaN dengan string di kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">col1<\/span> = df. <span style=\"color: #3366ff;\">col1<\/span> . <span style=\"color: #3366ff;\">fillna<\/span> ('')<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dengan pandas DataFrame berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n<span style=\"color: #008000;\">import<\/span> numpy <span style=\"color: #008000;\">as<\/span> np\n\n<span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#create DataFrame with some NaN values\n<\/span>df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [np.nan, 11, 7, 7, 8, 6, 14, 15],\n                   ' <span style=\"color: #ff0000;\">assists<\/span> ': [5, np.nan, 7, 9, 12, 9, 9, 4],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [11, 8, 10, np.nan, 6, 5, 9, np.nan]})<\/span>\n\n<span style=\"color: #008080;\">#view DataFrame<\/span>\n<span style=\"color: #000000;\">df\n\nteam points assists rebounds\n0 A NaN 5.0 11.0\n1 A 11.0 NaN 8.0\n2 A 7.0 7.0 10.0\n3 A 7.0 9.0 NaN\n4 B 8.0 12.0 6.0\n5 B 6.0 9.0 5.0\n6 B 14.0 9.0 9.0\n7 B 15.0 4.0 NaN\n<\/span><\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Metode 1: Ganti nilai NaN dengan string di seluruh DataFrame<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengganti setiap nilai NaN di seluruh DataFrame dengan string kosong:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#replace NaN values in all columns with empty string\n<\/span>df. <span style=\"color: #3366ff;\">fillna<\/span> ('', inplace= <span style=\"color: #008000;\">True<\/span> )\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span>df\n\n\tteam points assists rebounds\n0 A 5.0 11.0\n1 A 11.0 8.0\n2 A 7.0 7.0 10.0\n3 A 7.0 9.0\t\n4 B 8.0 12.0 6.0\n5 B 6.0 9.0 5.0\n6 B 14.0 9.0 9.0\n7B 15.0 4.0\t\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap nilai NaN di setiap kolom telah diganti dengan string kosong.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Metode 2: Ganti nilai NaN dengan string di kolom tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengganti nilai NaN di kolom tertentu dengan string tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#replace NaN values in 'points' and 'rebounds' columns with 'none'\n<\/span>df[[' <span style=\"color: #ff0000;\">points<\/span> ', ' <span style=\"color: #ff0000;\">rebounds<\/span> ']] = df[[' <span style=\"color: #ff0000;\">points<\/span> ', ' <span style=\"color: #ff0000;\">rebounds<\/span> ']]. <span style=\"color: #3366ff;\">fillna<\/span> (' <span style=\"color: #ff0000;\">none<\/span> ')\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span>df\n\n        team points assists rebounds\n0 A none 5.0 11.0\n1 A 11.0 NaN 8.0\n2 A 7.0 7.0 10.0\n3 A 7.0 9.0 none\n4 B 8.0 12.0 6.0\n5 B 6.0 9.0 5.0\n6 B 14.0 9.0 9.0\n7 B 15.0 4.0 none\t\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai NaN di kolom &#8220;poin&#8221; dan &#8220;rebound&#8221; telah diganti dengan string &#8220;tidak ada&#8221;, tetapi nilai NaN di kolom &#8220;bantuan&#8221; tetap tidak berubah.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Metode 3: Ganti nilai NaN dengan string di kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengganti nilai NaN di kolom dengan string tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#replace NaN values in 'points' column with 'zero'\n<\/span>df. <span style=\"color: #3366ff;\">points<\/span> = df. <span style=\"color: #3366ff;\">points<\/span> . <span style=\"color: #3366ff;\">fillna<\/span> (' <span style=\"color: #ff0000;\">zero<\/span> ')\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span>df\n\n\tteam points assists rebounds\n0 To zero 5.0 11.0\n1 A 11.0 NaN 8.0\n2 A 7.0 7.0 10.0\n3 A 7.0 9.0 NaN\n4 B 8.0 12.0 6.0\n5 B 6.0 9.0 5.0\n6 B 14.0 9.0 9.0\n7 B 15.0 4.0 NaN\t\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai NaN di kolom &#8220;poin&#8221; diganti dengan string &#8220;nol&#8221;, tetapi nilai NaN di kolom &#8220;assist&#8221; dan &#8220;rebound&#8221; tetap tidak berubah.<\/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\/pandas-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mengganti nilai pada kolom berdasarkan kondisi<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-ganti-nan-dengan-nol\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mengganti nilai NaN dengan nol<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-menghitung-nilai-yang-hilang\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menghitung nilai yang hilang di DataFrame<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk mengganti nilai NaN dengan string di pandas DataFrame: Metode 1: Ganti nilai NaN dengan string di seluruh DataFrame df. fillna (&#8221;, inplace= True ) Metode 2: Ganti nilai NaN dengan string di kolom tertentu df[[&#8216; col1 &#8216;, &#8216; col2 &#8216;]] = df[[&#8216; col1 &#8216;, &#8216; col2 &#8216;]]. fillna (&#8221;) [&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 mengganti nilai NaN dengan string - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengganti nilai NaN di pandas DataFrame dengan string tertentu, 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\/panda-ganti-nan-dengan-thong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara mengganti nilai NaN dengan string - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengganti nilai NaN di pandas DataFrame dengan string tertentu, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-ganti-nan-dengan-thong\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T12:59:53+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-ganti-nan-dengan-thong\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-ganti-nan-dengan-thong\/\",\"name\":\"Pandas: Cara mengganti nilai NaN dengan string - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T12:59:53+00:00\",\"dateModified\":\"2023-07-22T12:59:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengganti nilai NaN di pandas DataFrame dengan string tertentu, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-ganti-nan-dengan-thong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-ganti-nan-dengan-thong\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-ganti-nan-dengan-thong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara mengganti nilai nan dengan string\"}]},{\"@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 mengganti nilai NaN dengan string - Statorials","description":"Tutorial ini menjelaskan cara mengganti nilai NaN di pandas DataFrame dengan string tertentu, 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\/panda-ganti-nan-dengan-thong\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara mengganti nilai NaN dengan string - Statorials","og_description":"Tutorial ini menjelaskan cara mengganti nilai NaN di pandas DataFrame dengan string tertentu, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-ganti-nan-dengan-thong\/","og_site_name":"Statorials","article_published_time":"2023-07-22T12:59:53+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-ganti-nan-dengan-thong\/","url":"https:\/\/statorials.org\/id\/panda-ganti-nan-dengan-thong\/","name":"Pandas: Cara mengganti nilai NaN dengan string - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T12:59:53+00:00","dateModified":"2023-07-22T12:59:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengganti nilai NaN di pandas DataFrame dengan string tertentu, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-ganti-nan-dengan-thong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-ganti-nan-dengan-thong\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-ganti-nan-dengan-thong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara mengganti nilai nan dengan string"}]},{"@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\/2380"}],"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=2380"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2380\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}