{"id":1933,"date":"2023-07-24T09:55:04","date_gmt":"2023-07-24T09:55:04","guid":{"rendered":"https:\/\/statorials.org\/id\/jumlah-panda\/"},"modified":"2023-07-24T09:55:04","modified_gmt":"2023-07-24T09:55:04","slug":"jumlah-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jumlah-panda\/","title":{"rendered":"Cara menjalankan fungsi sumif di pandas"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menemukan jumlah baris dalam pandas DataFrame yang memenuhi kriteria tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #000000;\"><span style=\"color: #008080;\">#find sum of each column, grouped by one column<\/span>\n<b>df. <span style=\"color: #3366ff;\">groupby<\/span> (' <span style=\"color: #ff0000;\">group_column<\/span> '). <span style=\"color: #3366ff;\">sum<\/span> () \n<\/b>\n<span style=\"color: #008080;\">#find sum of one specific column, grouped by one column<\/span>\n<b>df. <span style=\"color: #3366ff;\">groupby<\/span> (' <span style=\"color: #ff0000;\">group_column<\/span> ')[' <span style=\"color: #ff0000;\">sum_column<\/span> ']. <span style=\"color: #3366ff;\">sum<\/span> ()<\/b>\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaks ini dengan bingkai data berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #000000;\"><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame\n<\/span>df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['a', 'a', 'b', 'b', 'b', 'c', 'c'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [5, 8, 14, 18, 5, 7, 7],\n                   ' <span style=\"color: #ff0000;\">assists<\/span> ': [8, 8, 9, 3, 8, 7, 4],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [1, 2, 2, 1, 0, 4, 1]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n\tteam points assists rebounds\n0 to 5 8 1\n1 to 8 8 2\n2 b 14 9 2\n3 b 18 3 1\n4 b 5 8 0\n5 c 7 7 4\n6 c 7 4 1\n<\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Jalankan fungsi SUMIF pada kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mencari jumlah poin untuk setiap tim:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">groupby<\/span> (' <span style=\"color: #ff0000;\">team<\/span> ')[' <span style=\"color: #ff0000;\">points<\/span> ']. <span style=\"color: #3366ff;\">sum<\/span> ()\n\nteam\nat 13\nb 37\nc 14<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Tim &#8216;a&#8217; mencetak total <strong>13<\/strong> poin<\/span><\/li>\n<li> <span style=\"color: #000000;\">Tim &#8216;b&#8217; mencetak total <strong>37<\/strong> poin<\/span><\/li>\n<li> <span style=\"color: #000000;\">Tim &#8216;c&#8217; mencetak total <strong>14<\/strong> poin<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Jalankan fungsi SUMIF pada beberapa kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mencari jumlah poin dan rebound untuk setiap tim:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">groupby<\/span> (' <span style=\"color: #ff0000;\">team<\/span> ')[[' <span style=\"color: #ff0000;\">points<\/span> ', ' <span style=\"color: #ff0000;\">rebounds<\/span> ']]. <span style=\"color: #3366ff;\">sum<\/span> ()\n\n<\/span>rebound points\nteam\t\t\nat 13 3\nb 37 3\nc 14 5\n<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Jalankan fungsi SUMIF di semua kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menemukan jumlah semua kolom dalam bingkai data untuk setiap tim:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #000000;\"><b>df. <span style=\"color: #3366ff;\">groupby<\/span> (' <span style=\"color: #ff0000;\">team<\/span> '). <span style=\"color: #3366ff;\">sum<\/span> ()\n\n\tpoints assists rebounds\nteam\t\t\t\na 13 16 3\nb 37 20 3\nc 14 11 5\n<\/b><\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/earl-python\/\" target=\"_blank\" rel=\"noopener\">Cara menjalankan fungsi COUNTIF di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-nomor\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung penampakan kelompok pada panda<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/maks-per-kelompok-panda\/\" target=\"_blank\" rel=\"noopener\">Bagaimana menemukan nilai maksimal per grup di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk menemukan jumlah baris dalam pandas DataFrame yang memenuhi kriteria tertentu: #find sum of each column, grouped by one column df. groupby (&#8216; group_column &#8216;). sum () #find sum of one specific column, grouped by one column df. groupby (&#8216; group_column &#8216;)[&#8216; sum_column &#8216;]. sum () Contoh berikut menunjukkan cara [&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 menjalankan fungsi SUMIF di Pandas \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menjalankan fungsi SUMIF di Pandas, 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\/jumlah-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menjalankan fungsi SUMIF di Pandas \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menjalankan fungsi SUMIF di Pandas, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jumlah-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T09:55:04+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\/jumlah-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/jumlah-panda\/\",\"name\":\"Cara menjalankan fungsi SUMIF di Pandas \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T09:55:04+00:00\",\"dateModified\":\"2023-07-24T09:55:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menjalankan fungsi SUMIF di Pandas, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jumlah-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jumlah-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jumlah-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menjalankan fungsi sumif 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 menjalankan fungsi SUMIF di Pandas \u2013 Statorials","description":"Tutorial ini menjelaskan cara menjalankan fungsi SUMIF di Pandas, 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\/jumlah-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menjalankan fungsi SUMIF di Pandas \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menjalankan fungsi SUMIF di Pandas, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/jumlah-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-24T09:55:04+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\/jumlah-panda\/","url":"https:\/\/statorials.org\/id\/jumlah-panda\/","name":"Cara menjalankan fungsi SUMIF di Pandas \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T09:55:04+00:00","dateModified":"2023-07-24T09:55:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menjalankan fungsi SUMIF di Pandas, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jumlah-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jumlah-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jumlah-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menjalankan fungsi sumif 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\/1933"}],"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=1933"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1933\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1933"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1933"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}