{"id":1361,"date":"2023-07-26T17:12:24","date_gmt":"2023-07-26T17:12:24","guid":{"rendered":"https:\/\/statorials.org\/id\/isi-panda-multi-kolom\/"},"modified":"2023-07-26T17:12:24","modified_gmt":"2023-07-26T17:12:24","slug":"isi-panda-multi-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/isi-panda-multi-kolom\/","title":{"rendered":"Cara mengisi nilai na untuk beberapa kolom di pandas"},"content":{"rendered":"

<\/p>\n

\n

Fungsi pandas fillna()<\/a> berguna untuk mengisi nilai yang hilang pada kolom pandas DataFrame.<\/span><\/p>\n

Tutorial ini memberikan beberapa contoh penggunaan fungsi ini untuk mengisi nilai yang hilang untuk beberapa kolom di pandas DataFrame berikut:<\/span><\/p>\n

 import<\/span> pandas as<\/span> pd\nimport<\/span> numpy as<\/span> np\n\n#createDataFrame\ndf = pd. DataFrame<\/span> ({'team': ['A', np. nan<\/span> , 'B', 'B', 'B', 'C', 'C', 'C'],\n                   'points': [25, np. no<\/span> , 15, np. no<\/span> , 19, 23, 25, 29],\n                   'assists': [5, 7, 7, 9, 12, 9, np. no<\/span> , 4],\n                   'rebounds': [11, 8, 10, 6, 6, 5, 9, 12]})<\/span>\n\n#view DataFrame\nprint<\/span> (df)\n\n  team points assists rebounds\n0 A 25.0 5.0 11\n1 NaN NaN 7.0 8\n2 B 15.0 7.0 10\n3 B NaN 9.0 6\n4 B 19.0 12.0 6\n5 C 23.0 9.0 5\n6 C 25.0 NaN 9\n7 C 29.0 4.0 12<\/span>\n<\/span><\/strong><\/pre>\n
 Contoh 1: Isi nilai yang hilang di semua kolom<\/strong><\/span><\/h3>\n
 Kode berikut menunjukkan cara mengisi nilai yang hilang dengan nol untuk semua<\/em> kolom di DataFrame:<\/span><\/p>\n
 #replace all missing values with zero<\/span>\ndf. fillna<\/span> (value= 0<\/span> ,inplace= True<\/span> )\n\n#view DataFrame\n<\/span>print<\/span> (df) \n\n  team points assists rebounds\n0 A 25.0 5.0 11\n1 0 0.0 7.0 8\n2 B 15.0 7.0 10\n3 B 0.0 9.0 6\n4 B 19.0 12.0 6\n5 C 23.0 9.0 5\n6 C 25.0 0.0 9\n7 C 29.0 4.0 12<\/strong><\/pre>\n
 Contoh 2: Isi nilai yang hilang untuk beberapa kolom<\/strong><\/span><\/h3>\n
 Kode berikut menunjukkan cara mengisi nilai yang hilang dengan nol hanya untuk kolom titik dan pembantu DataFrame:<\/span><\/p>\n
 #replace missing values in points and assists columns with zero<\/span>\ndf[['points', 'assists']] = df[['points', 'assists']]. fillna<\/span> (value= 0<\/span> )\n\n#view DataFrame\n<\/span>print<\/span> (df) \n\n  team points assists rebounds\n0 A 25.0 5.0 11\n1 NaN 0.0 7.0 8\n2 B 15.0 7.0 10\n3 B 0.0 9.0 6\n4 B 19.0 12.0 6\n5 C 23.0 9.0 5\n6 C 25.0 0.0 9\n7 C 29.0 4.0 12\n<\/strong><\/pre>\n
 Contoh 3: Isi nilai yang hilang dari beberapa kolom dengan nilai berbeda<\/strong><\/span><\/h3>\n
 Kode berikut menunjukkan cara mengisi nilai yang hilang di tiga kolom berbeda dengan tiga nilai berbeda:<\/span><\/p>\n
 #replace missing values in three columns with three different values<\/span>\ndf. fillna<\/span> ({'team': ' Unknown<\/span> ', 'points': 0<\/span> , 'assists': ' zero<\/span> '}, inplace= True<\/span> )\n\n#view DataFrame\n<\/span>print<\/span> (df)\n\n      team points assists rebounds\n0 A 25.0 5 11\n1 Unknown 0.0 7 8\n2 B 15.0 7 10\n3 B 0.0 9 6\n4 B 19.0 12 6\n5 C 23.0 9 5\n6 C 25.0 zero 9\n7 C 29.0 4 12\n<\/strong><\/pre>\n
 Perhatikan bahwa setiap nilai yang hilang di tiga kolom telah diganti dengan nilai unik.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Fungsi pandas fillna() berguna untuk mengisi nilai yang hilang pada kolom pandas DataFrame. Tutorial ini memberikan beberapa contoh penggunaan fungsi ini untuk mengisi nilai yang hilang untuk beberapa kolom di pandas DataFrame berikut: import pandas as pd import numpy as np #createDataFrame df = pd. DataFrame ({‘team’: [‘A’, np. nan , ‘B’, ‘B’, ‘B’, ‘C’, […]<\/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 mengisi nilai NA untuk beberapa kolom di Pandas<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengisi nilai NA untuk beberapa kolom di pandas DataFrame, 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\/isi-panda-multi-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengisi nilai NA untuk beberapa kolom di Pandas\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengisi nilai NA untuk beberapa kolom di pandas DataFrame, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/isi-panda-multi-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T17:12:24+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\/isi-panda-multi-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/isi-panda-multi-kolom\/\",\"name\":\"Cara mengisi nilai NA untuk beberapa kolom di Pandas\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T17:12:24+00:00\",\"dateModified\":\"2023-07-26T17:12:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengisi nilai NA untuk beberapa kolom di pandas DataFrame, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/isi-panda-multi-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/isi-panda-multi-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/isi-panda-multi-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengisi nilai na untuk beberapa kolom di pandas\"}]},{\"@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 mengisi nilai NA untuk beberapa kolom di Pandas","description":"Tutorial ini menjelaskan cara mengisi nilai NA untuk beberapa kolom di pandas DataFrame, 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\/isi-panda-multi-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengisi nilai NA untuk beberapa kolom di Pandas","og_description":"Tutorial ini menjelaskan cara mengisi nilai NA untuk beberapa kolom di pandas DataFrame, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/isi-panda-multi-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-26T17:12:24+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\/isi-panda-multi-kolom\/","url":"https:\/\/statorials.org\/id\/isi-panda-multi-kolom\/","name":"Cara mengisi nilai NA untuk beberapa kolom di Pandas","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T17:12:24+00:00","dateModified":"2023-07-26T17:12:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengisi nilai NA untuk beberapa kolom di pandas DataFrame, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/isi-panda-multi-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/isi-panda-multi-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/isi-panda-multi-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengisi nilai na untuk beberapa kolom di pandas"}]},{"@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\/1361"}],"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=1361"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1361\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}