{"id":892,"date":"2023-07-28T10:05:09","date_gmt":"2023-07-28T10:05:09","guid":{"rendered":"https:\/\/statorials.org\/id\/adalah-kolom-panda\/"},"modified":"2023-07-28T10:05:09","modified_gmt":"2023-07-28T10:05:09","slug":"adalah-kolom-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/adalah-kolom-panda\/","title":{"rendered":"Cara menghitung jumlah kolom di pandas"},"content":{"rendered":"

<\/p>\n

\n

Seringkali Anda mungkin tertarik untuk menghitung jumlah satu atau lebih kolom di pandas DataFrame. Untungnya, Anda dapat melakukan ini dengan mudah di panda menggunakan fungsi sum()<\/a> .<\/span><\/p>\n

Tutorial ini menunjukkan beberapa contoh penggunaan fungsi ini.<\/span><\/p>\n

Contoh 1: Temukan jumlah satu kolom<\/strong><\/span><\/h3>\n

Misalkan kita memiliki panda DataFrame berikut:<\/span><\/p>\n

 import<\/span> pandas as<\/span> pd\nimport<\/span> numpy as<\/span> np\n\n#createDataFrame<\/span>\ndf = pd.DataFrame({'rating': [90, 85, 82, 88, 94, 90, 76, 75, 87, 86],\n                   'points': [25, 20, 14, 16, 27, 20, 12, 15, 14, 19],\n                   'assists': [5, 7, 7, 8, 5, 7, 6, 9, 9, 5],\n                   'rebounds': [np.nan, 8, 10, 6, 6, 9, 6, 10, 10, 7]})\n\n#view DataFrame<\/span> \ndf\n\n\trating points assists rebounds\n0 90 25 5 NaN\n1 85 20 7 8\n2 82 14 7 10\n3 88 16 8 6\n4 94 27 5 6\n5 90 20 7 9\n6 76 12 6 6\n7 75 15 9 10\n8 87 14 9 10\n9 86 19 5 7\n<\/strong><\/pre>\n
 Kita dapat mencari jumlah kolom berlabel \u201cpoin\u201d menggunakan sintaks berikut:<\/span><\/p>\n
 df['points']. sum<\/span> ()\n\n182<\/strong><\/pre>\n
 Fungsi sum() juga akan mengecualikan NA secara default. Misalnya, jika kita menemukan jumlah kolom \u201crebound\u201d, nilai pertama \u201cNaN\u201d akan dikeluarkan dari penghitungan:<\/span><\/p>\n
 df['rebounds']. sum<\/span> ()\n\n72.0<\/strong><\/pre>\n
 Contoh 2: Temukan jumlah beberapa kolom<\/strong><\/span><\/h3>\n
 Kita dapat menemukan jumlah beberapa kolom menggunakan sintaks berikut:<\/p>\n
 #find sum of points and rebounds columns<\/span>\ndf[['rebounds', 'points']]. sum<\/span> ()\n\nrebounds 72.0\npoints 182.0\ndtype:float64\n<\/strong><\/pre>\n
 Contoh 3: Temukan jumlah semua kolom<\/strong><\/span><\/h3>\n
 Kita juga dapat menemukan jumlah semua kolom menggunakan sintaks berikut:<\/span><\/p>\n
 #find sum of all columns in DataFrame<\/span>\ndf. sum<\/span> ()\n\nrating 853.0\npoints 182.0\nassists 68.0\nrebounds 72.0\ndtype:float64\n<\/strong><\/pre>\n
 Untuk kolom yang bukan numerik, fungsi sum() tidak akan menghitung jumlah kolom tersebut.<\/span><\/p>\n
 Anda dapat menemukan dokumentasi lengkap fungsi sum() di sini<\/a> .<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Seringkali Anda mungkin tertarik untuk menghitung jumlah satu atau lebih kolom di pandas DataFrame. Untungnya, Anda dapat melakukan ini dengan mudah di panda menggunakan fungsi sum() . Tutorial ini menunjukkan beberapa contoh penggunaan fungsi ini. Contoh 1: Temukan jumlah satu kolom Misalkan kita memiliki panda DataFrame berikut: import pandas as pd import numpy as np […]<\/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 menghitung jumlah kolom di Pandas \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara menghitung jumlah satu atau lebih kolom di pandas DataFrame.\" \/>\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\/adalah-kolom-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung jumlah kolom di Pandas \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara menghitung jumlah satu atau lebih kolom di pandas DataFrame.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/adalah-kolom-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T10:05:09+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\/adalah-kolom-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/adalah-kolom-panda\/\",\"name\":\"Cara menghitung jumlah kolom di Pandas \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T10:05:09+00:00\",\"dateModified\":\"2023-07-28T10:05:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara menghitung jumlah satu atau lebih kolom di pandas DataFrame.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/adalah-kolom-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/adalah-kolom-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/adalah-kolom-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung jumlah 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 menghitung jumlah kolom di Pandas \u2013 Statorials","description":"Penjelasan sederhana tentang cara menghitung jumlah satu atau lebih kolom di pandas DataFrame.","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\/adalah-kolom-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung jumlah kolom di Pandas \u2013 Statorials","og_description":"Penjelasan sederhana tentang cara menghitung jumlah satu atau lebih kolom di pandas DataFrame.","og_url":"https:\/\/statorials.org\/id\/adalah-kolom-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-28T10:05:09+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\/adalah-kolom-panda\/","url":"https:\/\/statorials.org\/id\/adalah-kolom-panda\/","name":"Cara menghitung jumlah kolom di Pandas \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T10:05:09+00:00","dateModified":"2023-07-28T10:05:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara menghitung jumlah satu atau lebih kolom di pandas DataFrame.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/adalah-kolom-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/adalah-kolom-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/adalah-kolom-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung jumlah 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\/892"}],"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=892"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/892\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=892"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=892"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}