{"id":1651,"date":"2023-07-25T12:40:45","date_gmt":"2023-07-25T12:40:45","guid":{"rendered":"https:\/\/statorials.org\/id\/earl-python\/"},"modified":"2023-07-25T12:40:45","modified_gmt":"2023-07-25T12:40:45","slug":"earl-python","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/earl-python\/","title":{"rendered":"Cara menjalankan fungsi countif dengan python"},"content":{"rendered":"

<\/p>\n

\n

Seringkali Anda mungkin ingin menghitung hanya jumlah baris dalam pandas DataFrame yang memenuhi kriteria tertentu.<\/span><\/p>\n

Untungnya, hal ini mudah dilakukan dengan menggunakan sintaks dasar berikut:<\/span><\/p>\n

 sum(df. column_name<\/span> == some_value<\/span> )\n<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan sintaks ini dalam praktiknya pada bingkai data berikut:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame\n<\/span>df = pd. DataFrame<\/span> ({' x<\/span> ': [3, 4, 5, 6, 7, 8, 9, 10, 10, 12, 13],\n                   ' y<\/span> ': [3, 4, 5, 7, 9, 13, 15, 19, 23, 24, 29]})\n\n#view head of DataFrame\n<\/span>df. head<\/span> ()\n\nx y\n0 3 3\n1 4 4\n2 5 5\n3 6 7\n4 7 9\n<\/b><\/span><\/pre>\n
 Contoh 1: Hitung baris yang sama dengan nilai tertentu<\/strong><\/span><\/h3>\n
 Kode berikut menunjukkan cara menghitung jumlah baris yang variabel x sama dengan 10:<\/span><\/p>\n
 sum( df.x<\/span> == 10<\/span> )\n\n2\n<\/strong><\/pre>\n
 Kode berikut menunjukkan cara menghitung jumlah baris dimana variabel x sama dengan 10 atau<\/em> variabel y sama dengan 5:<\/span><\/p>\n
 sum((df. x<\/span> == 10<\/span> ) | (df. y<\/span> == 5<\/span> ))\n\n3<\/strong><\/pre>\n
 Kode berikut menunjukkan cara menghitung jumlah baris yang variabel x tidak<\/em> sama dengan 10:<\/span><\/p>\n
 sum( df.x<\/span> != 10<\/span> )\n\n9<\/strong><\/pre>\n
 Contoh 2: menghitung baris yang lebih besar atau sama dengan nilai tertentu<\/strong><\/span><\/h3>\n
 Kode berikut menunjukkan cara menghitung jumlah baris yang x lebih besar dari 10:<\/span><\/p>\n
 sum( df.x<\/span> > 10<\/span> ) \n\n2<\/strong><\/pre>\n
 Kode berikut menunjukkan cara menghitung jumlah baris yang x lebih kecil atau sama dengan 7:<\/span><\/p>\n
 sum(df. x<\/span> <= 7<\/span> )\n \n5<\/strong><\/pre>\n
 Contoh 3: Hitung garis di antara dua nilai<\/strong><\/span><\/h3>\n
 Kode berikut menunjukkan cara menghitung jumlah baris dengan x antara 10 dan 20:<\/span><\/p>\n
 sum((df. x<\/span> >= 5<\/span> ) & (df. x<\/span> <= 10<\/span> ))\n\n7<\/strong><\/pre>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Pandas: cara mencari perbedaan antara dua garis<\/a>
 Pandas: cara menghapus baris yang berisi string tertentu<\/a>
 Pandas: Cara menghapus baris duplikat di DataFrame<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Seringkali Anda mungkin ingin menghitung hanya jumlah baris dalam pandas DataFrame yang memenuhi kriteria tertentu. Untungnya, hal ini mudah dilakukan dengan menggunakan sintaks dasar berikut: sum(df. column_name == some_value ) Contoh berikut menunjukkan cara menggunakan sintaks ini dalam praktiknya pada bingkai data berikut: import pandas as pd #createDataFrame df = pd. DataFrame ({‘ x ‘: […]<\/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 menjalankan fungsi COUNTIF dengan Python - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menjalankan fungsi COUNTIF dengan Python, 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\/earl-python\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menjalankan fungsi COUNTIF dengan Python - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menjalankan fungsi COUNTIF dengan Python, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/earl-python\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T12:40:45+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\/earl-python\/\",\"url\":\"https:\/\/statorials.org\/id\/earl-python\/\",\"name\":\"Cara menjalankan fungsi COUNTIF dengan Python - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T12:40:45+00:00\",\"dateModified\":\"2023-07-25T12:40:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menjalankan fungsi COUNTIF dengan Python, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/earl-python\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/earl-python\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/earl-python\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menjalankan fungsi countif dengan python\"}]},{\"@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 COUNTIF dengan Python - Statorial","description":"Tutorial ini menjelaskan cara menjalankan fungsi COUNTIF dengan Python, 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\/earl-python\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menjalankan fungsi COUNTIF dengan Python - Statorial","og_description":"Tutorial ini menjelaskan cara menjalankan fungsi COUNTIF dengan Python, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/earl-python\/","og_site_name":"Statorials","article_published_time":"2023-07-25T12:40:45+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\/earl-python\/","url":"https:\/\/statorials.org\/id\/earl-python\/","name":"Cara menjalankan fungsi COUNTIF dengan Python - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T12:40:45+00:00","dateModified":"2023-07-25T12:40:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menjalankan fungsi COUNTIF dengan Python, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/earl-python\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/earl-python\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/earl-python\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menjalankan fungsi countif dengan python"}]},{"@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\/1651"}],"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=1651"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1651\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}