{"id":2048,"date":"2023-07-23T22:48:45","date_gmt":"2023-07-23T22:48:45","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-atau\/"},"modified":"2023-07-23T22:48:45","modified_gmt":"2023-07-23T22:48:45","slug":"panda-atau","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-atau\/","title":{"rendered":"Cara menggunakan fungsi where() di pandas (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Fungsi Where()<\/strong> dapat digunakan untuk mengganti nilai tertentu di pandas DataFrame.<\/span><\/p>\n

Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n

 df. where<\/span> (cond, other=nan)\n<\/strong><\/pre>\n
 Untuk setiap nilai dalam pandas DataFrame di mana cond<\/strong> adalah True, nilai asli dipertahankan.<\/span><\/p>\n
 Untuk setiap nilai di mana cond<\/strong> adalah False, nilai asli diganti dengan nilai yang ditentukan oleh argumen lainnya<\/strong> .<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya dengan pandas DataFrame berikut:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#define DataFrame\ndf = pd. DataFrame<\/span> ({' points<\/span> ': [25, 12, 15, 14, 19, 23, 25, 29],\n                   ' assists<\/span> ': [5, 7, 7, 9, 12, 9, 9, 4],\n                   ' rebounds<\/span> ': [11, 8, 10, 6, 6, 5, 9, 12]})<\/span>\n\n#view DataFrame<\/span>\ndf\n\npoints assists rebounds\n0 25 5 11\n1 12 7 8\n2 15 7 10\n3 14 9 6\n4 19 12 6\n5 23 9 5\n6 25 9 9\n7 29 4 12<\/strong><\/pre>\n
 Contoh 1: Ganti nilai di seluruh DataFrame<\/strong><\/span><\/h3>\n
 Kode berikut menunjukkan cara menggunakan fungsi Where()<\/strong> untuk mengganti semua nilai yang tidak memenuhi kondisi tertentu di seluruh pandas DataFrame dengan nilai NaN.<\/span><\/p>\n
 #keep values that are greater than 7, but replace all others with NaN<\/span>\ndf. where<\/span> (df>7)\n\n\tpoints assists rebounds\n0 25 NaN 11.0\n1 12 NaN 8.0\n2 15 NaN 10.0\n3 14 9.0 NaN\n4 19 12.0 NaN\n5 23 9.0 NaN\n6 25 9.0 9.0\n7 29 NaN 12.0\n<\/strong><\/pre>\n
 Kita juga bisa menggunakan argumen lain<\/strong> untuk mengganti nilai dengan sesuatu selain NaN.<\/span><\/p>\n
 #keep values that are greater than 7, but replace all others with 'low'<\/span>\ndf. where<\/span> (df>7, other=' low<\/span> ')\n\n\tpoints assists rebounds\n0 25 low 11\n1 12 low 8\n2 15 low 10\n3 14 9 low\n4 19 12 low\n5 23 9 low\n6 25 9 9\n7 29 low 12\n<\/strong><\/pre>\n
 Contoh 2: Ganti nilai di kolom DataFrame tertentu<\/strong><\/span><\/h3>\n
 Kode berikut menunjukkan cara menggunakan fungsi Where()<\/strong> untuk mengganti semua nilai yang tidak memenuhi kondisi tertentu di kolom tertentu DataFrame.<\/span><\/p>\n
 #keep values greater than 15 in 'points' column, but replace others with 'low'<\/span>\ndf[' points<\/span> '] = df[' points<\/span> ']. where<\/span> (df[' points<\/span> ']>15, other=' low<\/span> ')\n\n#view DataFrame<\/span>\ndf\n\n\tpoints assists rebounds\n0 25 5 11\n1 low 7 8\n2 low 7 10\n3 low 9 6\n4 19 12 6\n5 23 9 5\n6 25 9 9\n7 29 4 12<\/strong><\/pre>\n
 Anda dapat menemukan dokumentasi online lengkap untuk fungsi pandaswhere()<\/strong> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara menggunakan fungsi umum lainnya di panda:<\/span><\/p>\n
 Cara menggunakan fungsi deskripsikan() di Pandas<\/a>
 Cara menggunakan fungsi idxmax() di Pandas<\/a>
 Cara menerapkan fungsi ke kolom yang dipilih di Pandas<\/p>\n","protected":false},"excerpt":{"rendered":"
Fungsi Where() dapat digunakan untuk mengganti nilai tertentu di pandas DataFrame. Fungsi ini menggunakan sintaks dasar berikut: df. where (cond, other=nan) Untuk setiap nilai dalam pandas DataFrame di mana cond adalah True, nilai asli dipertahankan. Untuk setiap nilai di mana cond adalah False, nilai asli diganti dengan nilai yang ditentukan oleh argumen lainnya . Contoh […]<\/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 Menggunakan Fungsi Where() di Pandas (dengan Contoh) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi Where() di pandas DataFrame, 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\/panda-atau\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan Fungsi Where() di Pandas (dengan Contoh) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi Where() di pandas DataFrame, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-atau\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T22:48: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\/panda-atau\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-atau\/\",\"name\":\"Cara Menggunakan Fungsi Where() di Pandas (dengan Contoh) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T22:48:45+00:00\",\"dateModified\":\"2023-07-23T22:48:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi Where() di pandas DataFrame, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-atau\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-atau\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-atau\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan fungsi where() di pandas (dengan contoh)\"}]},{\"@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 Menggunakan Fungsi Where() di Pandas (dengan Contoh) \u2013 Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi Where() di pandas DataFrame, 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\/panda-atau\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan Fungsi Where() di Pandas (dengan Contoh) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi Where() di pandas DataFrame, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-atau\/","og_site_name":"Statorials","article_published_time":"2023-07-23T22:48: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\/panda-atau\/","url":"https:\/\/statorials.org\/id\/panda-atau\/","name":"Cara Menggunakan Fungsi Where() di Pandas (dengan Contoh) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T22:48:45+00:00","dateModified":"2023-07-23T22:48:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi Where() di pandas DataFrame, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-atau\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-atau\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-atau\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan fungsi where() di pandas (dengan contoh)"}]},{"@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\/2048"}],"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=2048"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2048\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2048"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2048"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2048"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}