{"id":4371,"date":"2023-07-11T15:20:37","date_gmt":"2023-07-11T15:20:37","guid":{"rendered":"https:\/\/statorials.org\/id\/pandas-ada-di-beberapa-kolom\/"},"modified":"2023-07-11T15:20:37","modified_gmt":"2023-07-11T15:20:37","slug":"pandas-ada-di-beberapa-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pandas-ada-di-beberapa-kolom\/","title":{"rendered":"Pandas: cara menggunakan isin untuk banyak kolom"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan metode berikut dengan fungsi pandas isin()<\/strong> untuk memfilter berdasarkan beberapa kolom di pandas DataFrame:<\/span><\/p>\n

Metode 1: Filter ketika beberapa kolom sama dengan nilai tertentu<\/strong><\/span><\/p>\n

 df = df[df[[' team<\/span> ', ' position<\/span> ']]. isin<\/span> ([' A<\/span> ',' Guard<\/span> ']). all<\/span> (axis= 1<\/span> )]\n<\/strong><\/pre>\n
 Contoh khusus ini memfilter DataFrame untuk baris dengan kolom tim<\/strong> sama dengan “A” dan<\/b> kolom posisi<\/strong> sama dengan “Penjaga”.<\/span><\/p>\n
 Metode 2: Filter jika setidaknya satu kolom sama dengan nilai tertentu<\/strong><\/span><\/p>\n
 df = df[df[[' team<\/span> ', ' position<\/span> ']]. isin<\/span> ([' A<\/span> ',' Guard<\/span> ']). any<\/span> (axis= 1<\/span> )]<\/strong><\/pre>\n
 Contoh khusus ini memfilter DataFrame untuk baris dengan kolom tim<\/strong> sama dengan “A” atau<\/b> kolom posisi<\/strong> sama dengan “Penjaga”.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan setiap metode dalam praktik dengan pandas DataFrame berikut:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame\n<\/span>df = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'],\n                   ' position<\/span> ': ['Guard', 'Guard', 'Forward', 'Forward',\n                                'Guard', 'Guard', 'Forward', 'Forward'],\n                   ' points<\/span> ': [11, 18, 10, 22, 26, 35, 19, 12]})\n                   \n#view DataFrame\n<\/span>print<\/span> (df)\n\n  team position points\n0 A Guard 11\n1 A Guard 18\n2 A Forward 10\n3 A Forward 22\n4 B Guard 26\n5 B Guard 35\n6 B Forward 19\n7 B Forward 12<\/strong><\/pre>\n
 Contoh 1: Filter jika beberapa kolom sama dengan nilai tertentu<\/strong><\/span><\/h2>\n
 Kita dapat menggunakan sintaks berikut untuk memfilter DataFrame agar hanya berisi baris dengan kolom tim<\/strong> sama dengan “A” dan<\/b> kolom posisi<\/strong> sama dengan “Penjaga”.<\/span><\/p>\n
 #filter rows where team column is 'A' and position column is 'Guard'<\/span>\ndf = df[df[[' team<\/span> ', ' position<\/span> ']]. isin<\/span> ([' A<\/span> ',' Guard<\/span> ']). all<\/span> (axis= 1<\/span> )]\n\n#view filtered DataFrame<\/span>\nprint<\/span> (df)\n\n  team position points\n0 A Guard 11\n1 A Guard 18\n<\/strong><\/pre>\n
 Perhatikan bahwa hanya baris dengan kolom tim<\/strong> sama dengan “A” dan<\/b> kolom posisi<\/strong> sama dengan “Penjaga” yang tetap berada dalam DataFrame yang difilter.<\/span><\/p>\n
 Contoh 2: Filter jika setidaknya satu kolom sama dengan nilai tertentu<\/strong><\/span><\/h2>\n
 Kita dapat menggunakan sintaks berikut untuk memfilter DataFrame agar hanya berisi baris dengan kolom tim<\/strong> sama dengan “A” atau<\/b> kolom posisi<\/strong> sama dengan “Penjaga”.<\/span><\/p>\n
 #filter rows where team column is 'A' or position column is 'Guard'<\/span>\ndf = df[df[[' team<\/span> ', ' position<\/span> ']]. isin<\/span> ([' A<\/span> ',' Guard<\/span> ']). any<\/span> (axis= 1<\/span> )]\n\n#view filtered DataFrame<\/span>\nprint<\/span> (df)\n\n  team position points\n0 A Guard 11\n1 A Guard 18\n2 A Forward 10\n3 A Forward 22\n4 B Guard 26\n5 B Guard 35\n<\/strong><\/pre>\n
 Perhatikan bahwa hanya baris dengan kolom tim<\/strong> sama dengan “A” atau<\/b> kolom posisi<\/strong> sama dengan “Penjaga” yang tetap berada dalam DataFrame yang difilter.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi pandas isin()<\/strong> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di panda:<\/span><\/p>\n
 Pandas: Cara menambahkan filter ke tabel pivot<\/a>
 Pandas: Cara memfilter \u201cTidak mengandung\u201d<\/a>
 Pandas: cara memfilter baris yang berisi string tertentu<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan metode berikut dengan fungsi pandas isin() untuk memfilter berdasarkan beberapa kolom di pandas DataFrame: Metode 1: Filter ketika beberapa kolom sama dengan nilai tertentu df = df[df[[‘ team ‘, ‘ position ‘]]. isin ([‘ A ‘,’ Guard ‘]). all (axis= 1 )] Contoh khusus ini memfilter DataFrame untuk baris dengan kolom tim […]<\/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":"\nPandas: Cara menggunakan isin untuk banyak kolom - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi isin() dengan beberapa kolom di pandas DataFrame, termasuk contohnya.\" \/>\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-ada-di-beberapa-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara menggunakan isin untuk banyak kolom - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi isin() dengan beberapa kolom di pandas DataFrame, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pandas-ada-di-beberapa-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T15:20:37+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-ada-di-beberapa-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/pandas-ada-di-beberapa-kolom\/\",\"name\":\"Pandas: Cara menggunakan isin untuk banyak kolom - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T15:20:37+00:00\",\"dateModified\":\"2023-07-11T15:20:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi isin() dengan beberapa kolom di pandas DataFrame, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pandas-ada-di-beberapa-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pandas-ada-di-beberapa-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-ada-di-beberapa-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menggunakan isin untuk banyak kolom\"}]},{\"@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 menggunakan isin untuk banyak kolom - Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi isin() dengan beberapa kolom di pandas DataFrame, termasuk contohnya.","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-ada-di-beberapa-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menggunakan isin untuk banyak kolom - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi isin() dengan beberapa kolom di pandas DataFrame, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/pandas-ada-di-beberapa-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-11T15:20:37+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-ada-di-beberapa-kolom\/","url":"https:\/\/statorials.org\/id\/pandas-ada-di-beberapa-kolom\/","name":"Pandas: Cara menggunakan isin untuk banyak kolom - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T15:20:37+00:00","dateModified":"2023-07-11T15:20:37+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi isin() dengan beberapa kolom di pandas DataFrame, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pandas-ada-di-beberapa-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pandas-ada-di-beberapa-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pandas-ada-di-beberapa-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menggunakan isin untuk banyak kolom"}]},{"@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\/4371"}],"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=4371"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4371\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}