{"id":3951,"date":"2023-07-14T13:35:06","date_gmt":"2023-07-14T13:35:06","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-menggantikan-nan-dengan-none\/"},"modified":"2023-07-14T13:35:06","modified_gmt":"2023-07-14T13:35:06","slug":"panda-menggantikan-nan-dengan-none","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-menggantikan-nan-dengan-none\/","title":{"rendered":"Pandas: cara mengganti nan dengan none"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk mengganti nilai <strong>NaN<\/strong> dengan <strong>None<\/strong> di pandas DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong>df = df. <span style=\"color: #3366ff;\">replace<\/span> (np. <span style=\"color: #3366ff;\">nan<\/span> , <span style=\"color: #008000;\">None<\/span> )\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Fungsi ini sangat berguna ketika Anda perlu mengekspor pandas DataFrame ke database yang menggunakan <strong>None<\/strong> untuk mewakili nilai yang hilang, bukan <strong>NaN<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <strong>Contoh: ganti NaN dengan None di Pandas<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki panda DataFrame berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><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;\">#createDataFrame\n<\/span>df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">A<\/span> ': [5, 6, 8, np.nan, 4, 15, 13],\n                   ' <span style=\"color: #ff0000;\">B<\/span> ': [np.nan, 12, np.nan, 10, 23, 6, 4],\n                   ' <span style=\"color: #ff0000;\">C<\/span> ': [2, 7, 6, 3, 2, 4, np.nan],\n                   ' <span style=\"color: #ff0000;\">D<\/span> ': [5, np.nan, 6, 15, 1, np.nan, 4]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n      ABCD\n0 5.0 NaN 2.0 5.0\n1 6.0 12.0 7.0 NaN\n2 8.0 NaN 6.0 6.0\n3 NaN 10.0 3.0 15.0\n4 4.0 23.0 2.0 1.0\n5 15.0 6.0 4.0 NaN\n6 13.0 4.0 NaN 4.0<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa ada beberapa nilai <strong>NaN<\/strong> di DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengganti setiap nilai <strong>NaN<\/strong> dengan <strong>None<\/strong> , kita dapat menggunakan sintaks berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#replace all NaN values with None<\/span>\ndf = df. <span style=\"color: #3366ff;\">replace<\/span> (np. <span style=\"color: #3366ff;\">nan<\/span> , <span style=\"color: #008000;\">None<\/span> )\n\n<span style=\"color: #008080;\">#view updated DataFrame<\/span>\n<span style=\"color: #008000;\">print<\/span> (df)\n\n      ABCD\n0 5.0 None 2.0 5.0\n1 6.0 12.0 7.0 None\n2 8.0 None 6.0 6.0\n3 None 10.0 3.0 15.0\n4 4.0 23.0 2.0 1.0\n5 15.0 6.0 4.0 None\n6 13.0 4.0 None 4.0\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap <strong>NaN<\/strong> di setiap kolom DataFrame telah diganti dengan <strong>None<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika Anda hanya ingin mengganti nilai <strong>NaN<\/strong> dengan <strong>Tidak Ada<\/strong> di kolom tertentu, Anda dapat menggunakan sintaks berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#replace NaN values with None in column 'B' only<\/span>\ndf[' <span style=\"color: #ff0000;\">B<\/span> '] = df[' <span style=\"color: #ff0000;\">B<\/span> ']. <span style=\"color: #3366ff;\">replace<\/span> (np. <span style=\"color: #3366ff;\">nan<\/span> , <span style=\"color: #008000;\">None<\/span> )\n\n<span style=\"color: #008080;\">#view updated DataFrame<\/span>\n<span style=\"color: #008000;\">print<\/span> (df)\n\n      ABCD\n0 5.0 None 2.0 5.0\n1 6.0 12.0 7.0 NaN\n2 8.0 None 6.0 6.0\n3 NaN 10.0 3.0 15.0\n4 4.0 23.0 2.0 1.0\n5 15.0 6.0 4.0 NaN\n6 13.0 4.0 NaN 4.0\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai <strong>NaN<\/strong> telah diubah menjadi <strong>Tidak Ada<\/strong> di kolom &#8220;B&#8221; saja.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/panda-ganti-nan-dengan-nol\/\" target=\"_blank\" rel=\"noopener\">Cara mengganti nilai NaN dengan nol di Pandas<\/a><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\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-menggantikan-nilai\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti nilai tertentu di Pandas<\/a><br \/> Cara memfilter Pandas DataFrame berdasarkan nilai kolom<br \/> <a href=\"https:\/\/statorials.org\/id\/isi-panda-multi-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara mengisi nilai NA untuk beberapa kolom di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk mengganti nilai NaN dengan None di pandas DataFrame: df = df. replace (np. nan , None ) Fungsi ini sangat berguna ketika Anda perlu mengekspor pandas DataFrame ke database yang menggunakan None untuk mewakili nilai yang hilang, bukan NaN . Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam [&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: Bagaimana cara mengganti NaN dengan None - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengganti nilai NaN dengan nilai None di pandas DataFrame, dengan sebuah 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-menggantikan-nan-dengan-none\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Bagaimana cara mengganti NaN dengan None - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengganti nilai NaN dengan nilai None di pandas DataFrame, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-menggantikan-nan-dengan-none\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T13:35:06+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-menggantikan-nan-dengan-none\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-menggantikan-nan-dengan-none\/\",\"name\":\"Pandas: Bagaimana cara mengganti NaN dengan None - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T13:35:06+00:00\",\"dateModified\":\"2023-07-14T13:35:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengganti nilai NaN dengan nilai None di pandas DataFrame, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-menggantikan-nan-dengan-none\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-menggantikan-nan-dengan-none\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-menggantikan-nan-dengan-none\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara mengganti nan dengan none\"}]},{\"@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: Bagaimana cara mengganti NaN dengan None - Statologi","description":"Tutorial ini menjelaskan cara mengganti nilai NaN dengan nilai None di pandas DataFrame, dengan sebuah 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-menggantikan-nan-dengan-none\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Bagaimana cara mengganti NaN dengan None - Statologi","og_description":"Tutorial ini menjelaskan cara mengganti nilai NaN dengan nilai None di pandas DataFrame, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/panda-menggantikan-nan-dengan-none\/","og_site_name":"Statorials","article_published_time":"2023-07-14T13:35:06+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-menggantikan-nan-dengan-none\/","url":"https:\/\/statorials.org\/id\/panda-menggantikan-nan-dengan-none\/","name":"Pandas: Bagaimana cara mengganti NaN dengan None - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T13:35:06+00:00","dateModified":"2023-07-14T13:35:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengganti nilai NaN dengan nilai None di pandas DataFrame, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-menggantikan-nan-dengan-none\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-menggantikan-nan-dengan-none\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-menggantikan-nan-dengan-none\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara mengganti nan dengan none"}]},{"@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\/3951"}],"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=3951"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3951\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}