{"id":3884,"date":"2023-07-14T23:46:31","date_gmt":"2023-07-14T23:46:31","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-jika-nilainya-di-kolom-lalu\/"},"modified":"2023-07-14T23:46:31","modified_gmt":"2023-07-14T23:46:31","slug":"panda-jika-nilainya-di-kolom-lalu","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-jika-nilainya-di-kolom-lalu\/","title":{"rendered":"Pandas: rumus untuk \u201cjika nilai di kolom maka\u201d"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut di panda untuk menetapkan nilai ke kolom berdasarkan nilai kolom lain:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #3366ff;\"><span style=\"color: #000000;\">df[' <span style=\"color: #ff0000;\">new<\/span> '] = df[' <span style=\"color: #ff0000;\">col<\/span> ']. <span style=\"color: #3366ff;\">map<\/span> ( <span style=\"color: #008000;\">lambda<\/span> x: ' <span style=\"color: #ff0000;\">new1<\/span> ' <span style=\"color: #008000;\">if<\/span> ' <span style=\"color: #ff0000;\">A<\/span> ' <span style=\"color: #008000;\">in<\/span> x <span style=\"color: #008000;\">else<\/span> ' <span style=\"color: #ff0000;\">new2<\/span> ' <span style=\"color: #008000;\">if<\/span> ' <span style=\"color: #ff0000;\">B<\/span> ' <span style=\"color: #008000;\">in<\/span> x <span style=\"color: #008000;\">else<\/span> '')\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Sintaks khusus ini akan membuat kolom baru bernama \u201cbaru\u201d yang akan mengambil nilai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>new1<\/strong> jika nilai di <strong>col<\/strong> sama dengan A.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>new2<\/strong> jika nilai di <strong>col<\/strong> sama dengan B.<\/span><\/li>\n<li> <span style=\"color: #000000;\">String kosong jika nilai dalam <strong>col<\/strong> sama dengan nilai lainnya.<\/span><\/li>\n<\/ul>\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: Menggunakan Rumus \u201cJika Nilai di Kolom Maka\u201d 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;\"> <b><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B', 'C', 'C'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [14, 22, 25, 34, 30, 12, 10, 18]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team points\n0 to 14\n1 to 22\n2 to 25\n3 to 34\n4 B 30\n5 B 12\n6 C 10\n7 C 18\n<\/b><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Sekarang misalkan kita ingin membuat kolom baru bernama <strong>city<\/strong> yang nilainya bergantung pada nilai terkait di kolom <strong>tim<\/strong> .<\/span><\/span><\/p>\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: #3366ff;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#create new column called city whose values depend on values in team column\n<\/span>df[' <span style=\"color: #ff0000;\">city<\/span> '] = df[' <span style=\"color: #ff0000;\">team<\/span> ']. <span style=\"color: #3366ff;\">map<\/span> ( <span style=\"color: #008000;\">lambda<\/span> x: ' <span style=\"color: #ff0000;\">Atlanta<\/span> ' <span style=\"color: #008000;\">if<\/span> ' <span style=\"color: #ff0000;\">A<\/span> ' <span style=\"color: #008000;\">in<\/span> x <span style=\"color: #008000;\">else<\/span> ' <span style=\"color: #ff0000;\">Boston<\/span> ' <span style=\"color: #008000;\">if<\/span> ' <span style=\"color: #ff0000;\">B<\/span> ' <span style=\"color: #008000;\">in<\/span> x <span style=\"color: #008000;\">else<\/span> '')\n\n<span style=\"color: #008080;\">#view updated DataFrame                            \n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team points city\n0 A 14 Atlanta\n1 to 22 Atlanta\n2 to 25 Atlanta\n3 to 34 Atlanta\n4 B 30 Boston\n5 B 12 Boston\n6 C 10         \n7 C 18       \n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Sintaks khusus ini membuat kolom baru bernama <strong>city<\/strong> yang mengambil nilai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><b>Atlanta<\/b> jika nilai <b>tim<\/b> sama dengan A.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Boston<\/strong> jika nilai <b>tim<\/b> sama dengan B.<\/span><\/li>\n<li> <span style=\"color: #000000;\">String kosong jika nilai dalam <b>tim<\/b> sama dengan nilai lainnya.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa dalam contoh ini kami menggunakan string kosong setelah pernyataan <strong>else<\/strong> terakhir untuk membiarkan nilai yang tidak memenuhi kondisi apa pun tetap kosong.<\/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 operasi umum lainnya di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/panda-mendapatkan-indeks-baris\/\" target=\"_blank\" rel=\"noopener\">Pandas: dapatkan indeks baris yang kolomnya cocok dengan nilainya<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pandas-pilih-kolom-yang-berisi-string\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara memilih kolom yang berisi string tertentu<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-kolom-berisi-string\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara memeriksa apakah kolom berisi string<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut di panda untuk menetapkan nilai ke kolom berdasarkan nilai kolom lain: df[&#8216; new &#8216;] = df[&#8216; col &#8216;]. map ( lambda x: &#8216; new1 &#8216; if &#8216; A &#8216; in x else &#8216; new2 &#8216; if &#8216; B &#8216; in x else &#8221;) Sintaks khusus ini akan membuat kolom baru [&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: Rumus untuk &quot;Jika nilai di kolom Maka&quot; - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus &quot;jika nilai di kolom maka&quot; di panda, dengan 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\/panda-jika-nilainya-di-kolom-lalu\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Rumus untuk &quot;Jika nilai di kolom Maka&quot; - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus &quot;jika nilai di kolom maka&quot; di panda, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-jika-nilainya-di-kolom-lalu\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T23:46:31+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\/panda-jika-nilainya-di-kolom-lalu\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-jika-nilainya-di-kolom-lalu\/\",\"name\":\"Pandas: Rumus untuk &quot;Jika nilai di kolom Maka&quot; - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T23:46:31+00:00\",\"dateModified\":\"2023-07-14T23:46:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan rumus &quot;jika nilai di kolom maka&quot; di panda, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-jika-nilainya-di-kolom-lalu\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-jika-nilainya-di-kolom-lalu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-jika-nilainya-di-kolom-lalu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: rumus untuk \u201cjika nilai di kolom maka\u201d\"}]},{\"@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: Rumus untuk &quot;Jika nilai di kolom Maka&quot; - Statorial","description":"Tutorial ini menjelaskan cara menggunakan rumus &quot;jika nilai di kolom maka&quot; di panda, dengan 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\/panda-jika-nilainya-di-kolom-lalu\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Rumus untuk &quot;Jika nilai di kolom Maka&quot; - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan rumus &quot;jika nilai di kolom maka&quot; di panda, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/panda-jika-nilainya-di-kolom-lalu\/","og_site_name":"Statorials","article_published_time":"2023-07-14T23:46:31+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\/panda-jika-nilainya-di-kolom-lalu\/","url":"https:\/\/statorials.org\/id\/panda-jika-nilainya-di-kolom-lalu\/","name":"Pandas: Rumus untuk &quot;Jika nilai di kolom Maka&quot; - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T23:46:31+00:00","dateModified":"2023-07-14T23:46:31+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan rumus &quot;jika nilai di kolom maka&quot; di panda, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-jika-nilainya-di-kolom-lalu\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-jika-nilainya-di-kolom-lalu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-jika-nilainya-di-kolom-lalu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: rumus untuk \u201cjika nilai di kolom maka\u201d"}]},{"@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\/3884"}],"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=3884"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3884\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}