{"id":3727,"date":"2023-07-15T21:54:45","date_gmt":"2023-07-15T21:54:45","guid":{"rendered":"https:\/\/statorials.org\/id\/pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain\/"},"modified":"2023-07-15T21:54:45","modified_gmt":"2023-07-15T21:54:45","slug":"pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain\/","title":{"rendered":"Pandas: buat kolom baru menggunakan beberapa kondisi if else"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk membuat kolom baru di pandas DataFrame menggunakan beberapa kondisi if else:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#define conditions\n<\/span>conditions = [\n    (df[' <span style=\"color: #ff0000;\">column1<\/span> '] == ' <span style=\"color: #ff0000;\">A<\/span> ') &amp; (df[' <span style=\"color: #ff0000;\">column2<\/span> '] &lt; <span style=\"color: #008000;\">20<\/span> ),\n    (df[' <span style=\"color: #ff0000;\">column1<\/span> '] == ' <span style=\"color: #ff0000;\">A<\/span> ') &amp; (df[' <span style=\"color: #ff0000;\">column2<\/span> '] &gt;= <span style=\"color: #008000;\">20<\/span> ),\n    (df[' <span style=\"color: #ff0000;\">column1<\/span> '] == ' <span style=\"color: #ff0000;\">B<\/span> ') &amp; (df[' <span style=\"color: #ff0000;\">column2<\/span> '] &lt; <span style=\"color: #008000;\">20<\/span> ),\n    (df[' <span style=\"color: #ff0000;\">column1<\/span> '] == ' <span style=\"color: #ff0000;\">B<\/span> ') &amp; (df[' <span style=\"color: #ff0000;\">column2<\/span> '] &gt;= <span style=\"color: #008000;\">20<\/span> )\n]\n\n<span style=\"color: #008080;\">#define results\n<\/span>results = [' <span style=\"color: #ff0000;\">result1<\/span> ', ' <span style=\"color: #ff0000;\">result2<\/span> ', ' <span style=\"color: #ff0000;\">result3<\/span> ', ' <span style=\"color: #ff0000;\">result4<\/span> ']\n\n<span style=\"color: #008080;\">#create new column based on conditions in column1 and column2\n<\/span>df[' <span style=\"color: #ff0000;\">new_column<\/span> '] = np. <span style=\"color: #3366ff;\">select<\/span> (conditions, results)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini membuat kolom bernama <strong>new_column<\/strong> yang nilainya didasarkan pada nilai <strong>kolom1<\/strong> dan <strong>kolom2<\/strong> di DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Membuat Kolom Baru Menggunakan Beberapa Kondisi If Else di Pandas<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang berbagai pemain bola basket:<\/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\n<\/span>df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [15, 18, 22, 24, 12, 17, 20, 28]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team points\n0 to 15\n1 to 18\n2 to 22\n3 to 24\n4 B 12\n5 B 17\n6 B 20\n7 B 28\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Sekarang katakanlah kita ingin membuat kolom baru bernama <strong>class<\/strong> yang mengklasifikasikan setiap pemain ke dalam salah satu dari empat grup berikut:<\/span><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Bad_A<\/strong> jika timnya A dan poin &lt;20<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Baik_A<\/strong> jika timnya A dan poin \u2265 20<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Bad_B<\/strong> jika timnya B dan poin &lt;20<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Baik_B<\/strong> jika timnya B dan poin \u2265 20<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008000;\">import<\/span> numpy <span style=\"color: #008000;\">as<\/span> np<\/span>\n\n#define conditions\n<\/span>conditions = [\n    (df[' <span style=\"color: #ff0000;\">team<\/span> '] == ' <span style=\"color: #ff0000;\">A<\/span> ') &amp; (df[' <span style=\"color: #ff0000;\">points<\/span> '] &lt; <span style=\"color: #008000;\">20<\/span> ),\n    (df[' <span style=\"color: #ff0000;\">team<\/span> '] == ' <span style=\"color: #ff0000;\">A<\/span> ') &amp; (df[' <span style=\"color: #ff0000;\">points<\/span> '] &gt;= <span style=\"color: #008000;\">20<\/span> ),\n    (df[' <span style=\"color: #ff0000;\">team<\/span> '] == ' <span style=\"color: #ff0000;\">B<\/span> ') &amp; (df[' <span style=\"color: #ff0000;\">points<\/span> '] &lt; <span style=\"color: #008000;\">20<\/span> ),\n    (df[' <span style=\"color: #ff0000;\">team<\/span> '] == ' <span style=\"color: #ff0000;\">B<\/span> ') &amp; (df[' <span style=\"color: #ff0000;\">points<\/span> '] &gt;= <span style=\"color: #008000;\">20<\/span> )\n]\n\n<span style=\"color: #008080;\">#define results\n<\/span>results = [' <span style=\"color: #ff0000;\">Bad_A<\/span> ', ' <span style=\"color: #ff0000;\">Good_A<\/span> ', ' <span style=\"color: #ff0000;\">Bad_B<\/span> ', ' <span style=\"color: #ff0000;\">Good_B<\/span> ']\n\n<span style=\"color: #008080;\">#create new column based on conditions in column1 and column2\n<\/span>df[' <span style=\"color: #ff0000;\">class<\/span> '] = np. <span style=\"color: #3366ff;\">select<\/span> (conditions, results)\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team points class\n0 A 15 Bad_A\n1 A 18 Bad_A\n2 A 22 Good_A\n3 A 24 Good_A\n4 B 12 Bad_B\n5 B 17 Bad_B\n6 B 20 Good_B\n7 B 28 Good_B<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kolom baru bernama <strong>class<\/strong> menampilkan peringkat setiap pemain berdasarkan nilai pada kolom <strong>tim<\/strong> dan <strong>poin<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi NumPy <strong>select()<\/strong> <a href=\"https:\/\/numpy.org\/doc\/stable\/reference\/generated\/numpy.select.html\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/panda-membuat-kolom-boolean-berdasarkan-kondisi\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara membuat kolom boolean berdasarkan kondisi<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-menghitung-nilai-di-kolom-dengan-kondisi\/\" target=\"_blank\" rel=\"noopener\">Pandas : Cara menghitung nilai pada kolom dengan syarat<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pandas-dikelompokkan-berdasarkan-hitungan-dengan-syarat\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara menggunakan Groupby dan menghitung secara kondisional<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk membuat kolom baru di pandas DataFrame menggunakan beberapa kondisi if else: #define conditions conditions = [ (df[&#8216; column1 &#8216;] == &#8216; A &#8216;) &amp; (df[&#8216; column2 &#8216;] &lt; 20 ), (df[&#8216; column1 &#8216;] == &#8216; A &#8216;) &amp; (df[&#8216; column2 &#8216;] &gt;= 20 ), (df[&#8216; column1 &#8216;] == &#8216; [&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: buat kolom baru menggunakan beberapa kondisi If Else \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat kolom baru di pandas DataFrame menggunakan beberapa kondisi if else, termasuk sebuah 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\/pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: buat kolom baru menggunakan beberapa kondisi If Else \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat kolom baru di pandas DataFrame menggunakan beberapa kondisi if else, termasuk sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T21:54: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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain\/\",\"url\":\"https:\/\/statorials.org\/id\/pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain\/\",\"name\":\"Pandas: buat kolom baru menggunakan beberapa kondisi If Else \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T21:54:45+00:00\",\"dateModified\":\"2023-07-15T21:54:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat kolom baru di pandas DataFrame menggunakan beberapa kondisi if else, termasuk sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: buat kolom baru menggunakan beberapa kondisi if else\"}]},{\"@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: buat kolom baru menggunakan beberapa kondisi If Else \u2013 Statorials","description":"Tutorial ini menjelaskan cara membuat kolom baru di pandas DataFrame menggunakan beberapa kondisi if else, termasuk sebuah 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\/pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: buat kolom baru menggunakan beberapa kondisi If Else \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara membuat kolom baru di pandas DataFrame menggunakan beberapa kondisi if else, termasuk sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain\/","og_site_name":"Statorials","article_published_time":"2023-07-15T21:54:45+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain\/","url":"https:\/\/statorials.org\/id\/pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain\/","name":"Pandas: buat kolom baru menggunakan beberapa kondisi If Else \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T21:54:45+00:00","dateModified":"2023-07-15T21:54:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat kolom baru di pandas DataFrame menggunakan beberapa kondisi if else, termasuk sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pandas-membuat-kolom-baru-berdasarkan-beberapa-kondisi-jika-lain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: buat kolom baru menggunakan beberapa kondisi if else"}]},{"@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\/3727"}],"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=3727"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3727\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3727"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3727"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3727"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}