{"id":978,"date":"2023-07-28T03:04:44","date_gmt":"2023-07-28T03:04:44","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-menghitung-nilai-yang-hilang\/"},"modified":"2023-07-28T03:04:44","modified_gmt":"2023-07-28T03:04:44","slug":"panda-menghitung-nilai-yang-hilang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-menghitung-nilai-yang-hilang\/","title":{"rendered":"Cara menghitung nilai yang hilang di pandas dataframe"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin menghitung jumlah nilai yang hilang dalam pandas DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menunjukkan beberapa contoh cara menghitung nilai yang hilang menggunakan DataFrame berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #107d3f;\">import<\/span> pandas <span style=\"color: #107d3f;\">as<\/span> pd\n<span style=\"color: #107d3f;\">import<\/span> numpy <span style=\"color: #107d3f;\">as<\/span> np\n\n<span style=\"color: #008080;\">#create DataFrame with some missing values<\/span>\ndf = pd.DataFrame({'a': [4, np.nan, np.nan, 7, 8, 12],\n                   'b': [np.nan, 6, 8, 14, 29, np.nan],\n                   'c': [11, 8, 10, 6, 6, np.nan]})\n\n<span style=\"color: #008080;\">#view DataFrame<\/span>\n<span style=\"color: #3366ff;\">print<\/span> (df)\n\n      ABC\n0 4.0 NaN 11.0\n1 NaN 6.0 8.0\n2 NaN 8.0 10.0\n3 7.0 14.0 6.0\n4 8.0 29.0 6.0\n5 12.0 NaN NaN\n<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Hitung total nilai yang hilang di seluruh DataFrame<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menghitung jumlah total nilai yang hilang di seluruh DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">isnull<\/span> (). <span style=\"color: #3366ff;\">sum<\/span> (). <span style=\"color: #3366ff;\">sum<\/span> ()\n\n5<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa ada total <strong>5<\/strong> nilai yang hilang.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Hitung total nilai yang hilang per kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menghitung jumlah total nilai yang hilang di setiap kolom DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">isnull<\/span> (). <span style=\"color: #3366ff;\">sum<\/span> ()\n\nat 2\nb 2\nc 1\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Kolom \u201ca\u201d memiliki <strong>2<\/strong> nilai yang hilang.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kolom \u201cb\u201d memiliki <strong>2<\/strong> nilai yang hilang.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kolom \u201cc\u201d memiliki <strong>1<\/strong> nilai yang hilang.<\/span><\/li>\n<\/ul>\n<p> Anda juga dapat menampilkan jumlah nilai yang hilang sebagai persentase dari keseluruhan kolom:<\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">isnull<\/span> (). <span style=\"color: #3366ff;\">sum<\/span> ()\/ <span style=\"color: #008000;\">len<\/span> (df)* <span style=\"color: #008000;\">100<\/span>\n\na 33.333333\nb 33.333333\nc 16.666667\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>33,33%<\/strong> nilai pada kolom \u201ca\u201d hilang.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>33,33%<\/strong> nilai pada kolom \u201cb\u201d hilang.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>16,67%<\/strong> nilai pada kolom \u201cc\u201d hilang.<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Hitung total nilai yang hilang per baris<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menghitung jumlah total nilai yang hilang di setiap baris DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">isnull<\/span> (). <span style=\"color: #3366ff;\">sum<\/span> (axis= <span style=\"color: #008000;\">1<\/span> )\n\n0 1\n1 1\n2 1\n30\n4 0\n5 2<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Baris 1 memiliki <strong>1<\/strong> nilai yang hilang.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris 2 memiliki <strong>1<\/strong> nilai yang hilang.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris 3 memiliki <strong>1<\/strong> nilai yang hilang.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris 4 memiliki <strong>0<\/strong> nilai yang hilang.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris 5 memiliki <strong>0<\/strong> nilai yang hilang.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris 6 memiliki <strong>2<\/strong> nilai yang hilang.<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/panda-tunggal-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara menemukan nilai unik di beberapa kolom di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/buat-panda-berdasarkan-kolom\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara membuat kolom baru berdasarkan kondisi di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin menghitung jumlah nilai yang hilang dalam pandas DataFrame. Tutorial ini menunjukkan beberapa contoh cara menghitung nilai yang hilang menggunakan DataFrame berikut: import pandas as pd import numpy as np #create DataFrame with some missing values df = pd.DataFrame({&#8216;a&#8217;: [4, np.nan, np.nan, 7, 8, 12], &#8216;b&#8217;: [np.nan, 6, 8, 14, 29, np.nan], [&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>Cara menghitung nilai yang hilang di DataFrame Pandas \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara menghitung nilai yang hilang di pandas DataFrame, termasuk 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-menghitung-nilai-yang-hilang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung nilai yang hilang di DataFrame Pandas \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara menghitung nilai yang hilang di pandas DataFrame, termasuk beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-menghitung-nilai-yang-hilang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T03:04:44+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-menghitung-nilai-yang-hilang\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-menghitung-nilai-yang-hilang\/\",\"name\":\"Cara menghitung nilai yang hilang di DataFrame Pandas \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T03:04:44+00:00\",\"dateModified\":\"2023-07-28T03:04:44+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara menghitung nilai yang hilang di pandas DataFrame, termasuk beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-menghitung-nilai-yang-hilang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-menghitung-nilai-yang-hilang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-menghitung-nilai-yang-hilang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung nilai yang hilang di pandas dataframe\"}]},{\"@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 menghitung nilai yang hilang di DataFrame Pandas \u2013 Statorials","description":"Penjelasan sederhana tentang cara menghitung nilai yang hilang di pandas DataFrame, termasuk 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-menghitung-nilai-yang-hilang\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung nilai yang hilang di DataFrame Pandas \u2013 Statorials","og_description":"Penjelasan sederhana tentang cara menghitung nilai yang hilang di pandas DataFrame, termasuk beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-menghitung-nilai-yang-hilang\/","og_site_name":"Statorials","article_published_time":"2023-07-28T03:04:44+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-menghitung-nilai-yang-hilang\/","url":"https:\/\/statorials.org\/id\/panda-menghitung-nilai-yang-hilang\/","name":"Cara menghitung nilai yang hilang di DataFrame Pandas \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T03:04:44+00:00","dateModified":"2023-07-28T03:04:44+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara menghitung nilai yang hilang di pandas DataFrame, termasuk beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-menghitung-nilai-yang-hilang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-menghitung-nilai-yang-hilang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-menghitung-nilai-yang-hilang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung nilai yang hilang di pandas dataframe"}]},{"@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\/978"}],"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=978"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/978\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=978"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=978"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=978"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}