{"id":1367,"date":"2023-07-26T16:40:45","date_gmt":"2023-07-26T16:40:45","guid":{"rendered":"https:\/\/statorials.org\/id\/kolom-jumlah-panda-dengan-syarat\/"},"modified":"2023-07-26T16:40:45","modified_gmt":"2023-07-26T16:40:45","slug":"kolom-jumlah-panda-dengan-syarat","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kolom-jumlah-panda-dengan-syarat\/","title":{"rendered":"Pandas: cara menambahkan kolom berdasarkan suatu kondisi"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menjumlahkan nilai kolom di pandas DataFrame berdasarkan kondisi:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">loc<\/span> [df[' <span style=\"color: #008000;\">col1<\/span> '] == <span style=\"color: #008000;\">some_value<\/span> , ' <span style=\"color: #008000;\">col2<\/span> ']. <span style=\"color: #3366ff;\">sum<\/span> ()\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan beberapa contoh penggunaan praktis sintaks ini menggunakan pandas 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\n<span style=\"color: #008080;\">#createDataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #008000;\">team<\/span> ': ['A', 'A', 'A', 'B', 'B', 'C'],\n                   ' <span style=\"color: #008000;\">conference<\/span> ': ['East', 'East', 'East', 'West', 'West', 'East'],\n                   ' <span style=\"color: #008000;\">points<\/span> ': [11, 8, 10, 6, 6, 5],\n                   ' <span style=\"color: #008000;\">rebounds<\/span> ': [7, 7, 6, 9, 12, 8]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n        team conference points rebounds\n0 A East 11 7\n1 A East 8 7\n2 A East 10 6\n3 B West 6 9\n4 B West 6 12\n5 C East 5 8<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Tambahkan kolom berdasarkan suatu kondisi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mencari jumlah poin untuk baris di mana tim sama dengan &#8220;A&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">loc<\/span> [df[' <span style=\"color: #008000;\">team<\/span> '] == ' <span style=\"color: #008000;\">A<\/span> ', ' <span style=\"color: #008000;\">points<\/span> ']. <span style=\"color: #3366ff;\">sum<\/span> ()\n\n29<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Tambahkan kolom berdasarkan beberapa kondisi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mencari jumlah poin untuk garis di mana tim sama dengan &#8220;A&#8221; <em>dan<\/em> konferensi sama dengan &#8220;Timur&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">loc<\/span> [(df[' <span style=\"color: #008000;\">team<\/span> '] == ' <span style=\"color: #008000;\">A<\/span> ') &amp; (df[' <span style=\"color: #008000;\">conference<\/span> '] == ' <span style=\"color: #008000;\">East<\/span> '), ' <span style=\"color: #008000;\">points<\/span> ']. <span style=\"color: #3366ff;\">sum<\/span> ()\n\n29<\/strong><\/pre>\n<h3> <strong>Contoh 3: Tambahkan kolom berdasarkan salah satu dari beberapa kondisi<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mencari jumlah poin untuk garis yang timnya sama dengan &#8220;A&#8221; <i>atau<\/i> &#8220;B&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">loc<\/span> [df[' <span style=\"color: #008000;\">team<\/span> ']. <span style=\"color: #3366ff;\">isin<\/span> ([' <span style=\"color: #008000;\">A<\/span> ',' <span style=\"color: #008000;\">B<\/span> ']), ' <span style=\"color: #008000;\">dots<\/span> ']. <span style=\"color: #3366ff;\">sum<\/span> ()\n\n41<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Anda dapat menemukan tutorial panda lainnya di halaman ini .<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk menjumlahkan nilai kolom di pandas DataFrame berdasarkan kondisi: df. loc [df[&#8216; col1 &#8216;] == some_value , &#8216; col2 &#8216;]. sum () Tutorial ini memberikan beberapa contoh penggunaan praktis sintaks ini menggunakan pandas DataFrame berikut: import pandas as pd #createDataFrame df = pd. DataFrame ({&#8216; team &#8216;: [&#8216;A&#8217;, &#8216;A&#8217;, &#8216;A&#8217;, [&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>Pandas: Cara menambahkan kolom berdasarkan kondisi - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan nilai kolom pandas berdasarkan suatu kondisi, 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\/kolom-jumlah-panda-dengan-syarat\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara menambahkan kolom berdasarkan kondisi - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan nilai kolom pandas berdasarkan suatu kondisi, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kolom-jumlah-panda-dengan-syarat\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T16: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\/kolom-jumlah-panda-dengan-syarat\/\",\"url\":\"https:\/\/statorials.org\/id\/kolom-jumlah-panda-dengan-syarat\/\",\"name\":\"Pandas: Cara menambahkan kolom berdasarkan kondisi - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T16:40:45+00:00\",\"dateModified\":\"2023-07-26T16:40:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan nilai kolom pandas berdasarkan suatu kondisi, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kolom-jumlah-panda-dengan-syarat\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kolom-jumlah-panda-dengan-syarat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kolom-jumlah-panda-dengan-syarat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menambahkan kolom berdasarkan suatu kondisi\"}]},{\"@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":"Pandas: Cara menambahkan kolom berdasarkan kondisi - Statorial","description":"Tutorial ini menjelaskan cara menambahkan nilai kolom pandas berdasarkan suatu kondisi, 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\/kolom-jumlah-panda-dengan-syarat\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menambahkan kolom berdasarkan kondisi - Statorial","og_description":"Tutorial ini menjelaskan cara menambahkan nilai kolom pandas berdasarkan suatu kondisi, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/kolom-jumlah-panda-dengan-syarat\/","og_site_name":"Statorials","article_published_time":"2023-07-26T16: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\/kolom-jumlah-panda-dengan-syarat\/","url":"https:\/\/statorials.org\/id\/kolom-jumlah-panda-dengan-syarat\/","name":"Pandas: Cara menambahkan kolom berdasarkan kondisi - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T16:40:45+00:00","dateModified":"2023-07-26T16:40:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan nilai kolom pandas berdasarkan suatu kondisi, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kolom-jumlah-panda-dengan-syarat\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kolom-jumlah-panda-dengan-syarat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kolom-jumlah-panda-dengan-syarat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menambahkan kolom berdasarkan suatu kondisi"}]},{"@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\/1367"}],"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=1367"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1367\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}