{"id":2215,"date":"2023-07-23T05:37:32","date_gmt":"2023-07-23T05:37:32","guid":{"rendered":"https:\/\/statorials.org\/id\/tidak-ada-panda\/"},"modified":"2023-07-23T05:37:32","modified_gmt":"2023-07-23T05:37:32","slug":"tidak-ada-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tidak-ada-panda\/","title":{"rendered":"Cara menggunakan filter \u201cnot in\u201d di pandas (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks berikut untuk melakukan filter “NOT IN” di pandas DataFrame:<\/span><\/p>\n

 df[ ~<\/span> df[' col_name<\/span> ']. isin<\/span> (values_list)]\n<\/strong><\/pre>\n
 Perhatikan bahwa nilai dalam Values_list<\/strong> dapat berupa nilai numerik atau nilai karakter.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh 1: Lakukan filter \u201cNON IN\u201d dengan kolom<\/strong><\/span><\/h2>\n
 Kode berikut menunjukkan cara memfilter pandas DataFrame untuk baris di mana nama tim tidak ada dalam daftar nama:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame\ndf = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'A', 'B', 'B', 'B', 'B', 'C', 'C'],\n                   ' 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]})\n\n#define list of teams we don't want\n<\/span>values_list = [' A<\/span> ', ' B<\/span> ']\n<\/span>\n#filter for rows where team name is not in list\n<\/span>df[ ~<\/span> df[' team<\/span> ']. isin<\/span> (values_list)]\n\n        team points assists rebounds\n6 C 25 9 9\n7 C 29 4 12\n<\/span><\/span><\/span><\/span><\/strong><\/pre>\n
 Dan kode berikut menunjukkan cara memfilter DataFrame pandas untuk baris yang kolom “titik” tidak berisi nilai tertentu:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame\ndf = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'A', 'B', 'B', 'B', 'B', 'C', 'C'],\n                   ' 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]})\n\n#define list of values we don't want\n<\/span>values_list = [12, 15, 25]\n\n#filter for rows where team name is not in list\n<\/span>df[ ~<\/span> df[' team<\/span> ']. isin<\/span> (values_list)]\n\n\tteam points assists rebounds\n3 B 14 9 6\n4 B 19 12 6\n5 B 23 9 5\n7 C 29 4 12\n<\/span><\/span><\/strong><\/pre>\n
 Contoh 2: Lakukan filter \u201cNON IN\u201d dengan beberapa kolom<\/strong><\/span><\/h2>\n
 Kode berikut menunjukkan cara memfilter pandas DataFrame untuk baris di mana nama tim tertentu tidak ada di salah satu dari beberapa kolom:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame\ndf = pd. DataFrame<\/span> ({' star_team<\/span> ': ['A', 'A', 'B', 'B', 'B', 'B', 'C', 'C'],\n                   ' backup_team<\/span> ': ['B', 'B', 'C', 'C', 'D', 'D', 'D', 'E'],\n                   ' 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]})\n\n#define list of teams we don't want\n<\/span>values_list = [' C<\/span> ', ' E<\/span> ']\n\n#filter for rows where team name is not in one of several columns\n<\/span>df[ ~<\/span> df[[' star_team<\/span> ', ' backup_team<\/span> ']]. isin<\/span> (values_list). any<\/span> (axis= 1<\/span> )] \n\n        star_team backup_team points assists rebounds\n0 A B 25 5 11\n1 A B 12 7 8\n4 B D 19 12 6\n5 B D 23 9 5<\/span><\/span><\/strong><\/pre>\n
 Perhatikan bahwa kami memfilter setiap baris di mana tim “C” atau “E” muncul di kolom “star_team” atau di kolom “backup_team”.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan operasi pemfilteran umum lainnya di panda:<\/span><\/p>\n
 Cara menggunakan \u201cIs Not Null\u201d di Pandas<\/a>
 Cara memfilter Pandas DataFrame berdasarkan nilai kolom
 Cara memfilter baris Pandas DataFrame berdasarkan tanggal
 Cara memfilter Pandas DataFrame pada berbagai kondisi<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks berikut untuk melakukan filter “NOT IN” di pandas DataFrame: df[ ~ df[‘ col_name ‘]. isin (values_list)] Perhatikan bahwa nilai dalam Values_list dapat berupa nilai numerik atau nilai karakter. Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh 1: Lakukan filter \u201cNON IN\u201d dengan kolom Kode berikut menunjukkan cara memfilter pandas […]<\/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 filter "NOT IN" di Pandas (dengan contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan filter "tidak dalam" 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\/tidak-ada-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan filter "NOT IN" di Pandas (dengan contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan filter "tidak dalam" di pandas DataFrame, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tidak-ada-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T05:37:32+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\/tidak-ada-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/tidak-ada-panda\/\",\"name\":\"Cara menggunakan filter "NOT IN" di Pandas (dengan contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T05:37:32+00:00\",\"dateModified\":\"2023-07-23T05:37:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan filter "tidak dalam" di pandas DataFrame, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tidak-ada-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tidak-ada-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tidak-ada-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan filter \u201cnot in\u201d 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 filter "NOT IN" di Pandas (dengan contoh) - Statorials","description":"Tutorial ini menjelaskan cara melakukan filter "tidak dalam" 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\/tidak-ada-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan filter "NOT IN" di Pandas (dengan contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara melakukan filter "tidak dalam" di pandas DataFrame, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/tidak-ada-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-23T05:37:32+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\/tidak-ada-panda\/","url":"https:\/\/statorials.org\/id\/tidak-ada-panda\/","name":"Cara menggunakan filter "NOT IN" di Pandas (dengan contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T05:37:32+00:00","dateModified":"2023-07-23T05:37:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan filter "tidak dalam" di pandas DataFrame, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tidak-ada-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tidak-ada-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tidak-ada-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan filter \u201cnot in\u201d 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\/2215"}],"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=2215"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2215\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}