{"id":4236,"date":"2023-07-12T15:16:27","date_gmt":"2023-07-12T15:16:27","guid":{"rendered":"https:\/\/statorials.org\/id\/filter-panda-berdasarkan-nilai-kolom-tidak-sama\/"},"modified":"2023-07-12T15:16:27","modified_gmt":"2023-07-12T15:16:27","slug":"filter-panda-berdasarkan-nilai-kolom-tidak-sama","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/filter-panda-berdasarkan-nilai-kolom-tidak-sama\/","title":{"rendered":"Pandas: filter berdasarkan kolom tidak sama dengan nilai tertentu"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk memfilter DataFrame pandas yang kolomnya tidak sama dengan nilai tertentu:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Filter jika kolom tidak sama dengan nilai tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#filter rows where team column is not equal to 'Nets'<\/span>\ndf_filtered = df[df[' <span style=\"color: #ff0000;\">team<\/span> '] <span style=\"color: #800080;\">!=<\/span> ' <span style=\"color: #ff0000;\">Nets<\/span> ']\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Filter ketika kolom tidak sama dengan beberapa nilai tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #008080;\"><strong>#filter rows where team column is not equal to 'Nets', 'Mavs' or 'Kings'<\/strong><\/span>\n<strong>df_filtered = df[ <span style=\"color: #800080;\">~<\/span> df[' <span style=\"color: #ff0000;\">team<\/span> ']. <span style=\"color: #3366ff;\">isin<\/span> ([' <span style=\"color: #ff0000;\">Nets<\/span> ', ' <span style=\"color: #ff0000;\">Mavs<\/span> ', ' <span style=\"color: #ff0000;\">Kings<\/span> '])]<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dalam praktik dengan pandas DataFrame berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">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> ': ['Mavs', 'Mavs', 'Nets', 'Nets', 'Heat', 'Heat', 'Kings'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [22, 28, 35, 34, 29, 28, 23]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n    team points\n0 Mavs 22\n1 Mavs 28\n2 Nets 35\n3 Nets 34\n4 Heat 29\n5 Heat 28\n6 Kings 23\n<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Filter jika kolomnya tidak sama dengan nilai tertentu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk memfilter DataFrame agar hanya berisi baris yang kolom <strong>tim<\/strong> tidak sama dengan &#8220;Nets&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#filter rows where team column is not equal to 'Nets'<\/span>\ndf_filtered = df[df[' <span style=\"color: #ff0000;\">team<\/span> '] <span style=\"color: #800080;\">!=<\/span> ' <span style=\"color: #ff0000;\">Nets<\/span> ']\n\n<span style=\"color: #008080;\">#view filtered DataFrame<\/span>\n<span style=\"color: #008000;\">print<\/span> (df_filtered)\n\n    team points\n0 Mavs 22\n1 Mavs 28\n4 Heat 29\n5 Heat 28\n6 Kings 23\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap baris dengan nama <strong>tim<\/strong> &#8220;Nets&#8221; difilter dari DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Simbol <strong>!=<\/strong> melambangkan \u201ctidak sama\u201d pada panda.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Filter jika kolomnya tidak sama dengan beberapa nilai tertentu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk memfilter DataFrame agar hanya berisi baris dengan kolom <strong>tim<\/strong> yang tidak sama dengan &#8220;Nets&#8221;, &#8220;Mavs&#8221; atau &#8220;Kings&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #008080;\"><strong>#filter rows where team column is not equal to 'Nets', 'Mavs' or 'Kings'<\/strong><\/span>\n<strong>df_filtered = df[ <span style=\"color: #800080;\">~<\/span> df[' <span style=\"color: #ff0000;\">team<\/span> ']. <span style=\"color: #3366ff;\">isin<\/span> ([' <span style=\"color: #ff0000;\">Nets<\/span> ', ' <span style=\"color: #ff0000;\">Mavs<\/span> ', ' <span style=\"color: #ff0000;\">Kings<\/span> '])]\n\n<span style=\"color: #008080;\">#view filtered DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df_filtered)\n\n   team points\n4 Heat 29\n5 Heat 28\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap baris dengan nama <strong>tim<\/strong> &#8220;Nets&#8221;, &#8220;Mavs&#8221; atau &#8220;Kings&#8221; difilter dari DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Simbol <strong>~<\/strong> melambangkan \u201ctidak\u201d pada panda.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Dokumentasi<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi pandas <strong>isin()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.DataFrame.isin.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 panda umum lainnya:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/filter-tabel-pivot-panda\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menambahkan filter ke tabel pivot<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-tidak-mengandung\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara memfilter \u201cTidak mengandung\u201d<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/garis-filter-panda-yang-berisi-string\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara memfilter baris yang berisi string tertentu<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk memfilter DataFrame pandas yang kolomnya tidak sama dengan nilai tertentu: Metode 1: Filter jika kolom tidak sama dengan nilai tertentu #filter rows where team column is not equal to &#8216;Nets&#8217; df_filtered = df[df[&#8216; team &#8216;] != &#8216; Nets &#8216;] Metode 2: Filter ketika kolom tidak sama dengan beberapa nilai [&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: filter berdasarkan kolom tidak sama dengan nilai tertentu - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter baris DataFrame pandas berdasarkan kolom yang tidak sama dengan nilai tertentu.\" \/>\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\/filter-panda-berdasarkan-nilai-kolom-tidak-sama\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: filter berdasarkan kolom tidak sama dengan nilai tertentu - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter baris DataFrame pandas berdasarkan kolom yang tidak sama dengan nilai tertentu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/filter-panda-berdasarkan-nilai-kolom-tidak-sama\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T15:16:27+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\/filter-panda-berdasarkan-nilai-kolom-tidak-sama\/\",\"url\":\"https:\/\/statorials.org\/id\/filter-panda-berdasarkan-nilai-kolom-tidak-sama\/\",\"name\":\"Pandas: filter berdasarkan kolom tidak sama dengan nilai tertentu - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T15:16:27+00:00\",\"dateModified\":\"2023-07-12T15:16:27+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter baris DataFrame pandas berdasarkan kolom yang tidak sama dengan nilai tertentu.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/filter-panda-berdasarkan-nilai-kolom-tidak-sama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/filter-panda-berdasarkan-nilai-kolom-tidak-sama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/filter-panda-berdasarkan-nilai-kolom-tidak-sama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: filter berdasarkan kolom tidak sama dengan nilai tertentu\"}]},{\"@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: filter berdasarkan kolom tidak sama dengan nilai tertentu - Statologi","description":"Tutorial ini menjelaskan cara memfilter baris DataFrame pandas berdasarkan kolom yang tidak sama dengan nilai tertentu.","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\/filter-panda-berdasarkan-nilai-kolom-tidak-sama\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: filter berdasarkan kolom tidak sama dengan nilai tertentu - Statologi","og_description":"Tutorial ini menjelaskan cara memfilter baris DataFrame pandas berdasarkan kolom yang tidak sama dengan nilai tertentu.","og_url":"https:\/\/statorials.org\/id\/filter-panda-berdasarkan-nilai-kolom-tidak-sama\/","og_site_name":"Statorials","article_published_time":"2023-07-12T15:16:27+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\/filter-panda-berdasarkan-nilai-kolom-tidak-sama\/","url":"https:\/\/statorials.org\/id\/filter-panda-berdasarkan-nilai-kolom-tidak-sama\/","name":"Pandas: filter berdasarkan kolom tidak sama dengan nilai tertentu - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T15:16:27+00:00","dateModified":"2023-07-12T15:16:27+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter baris DataFrame pandas berdasarkan kolom yang tidak sama dengan nilai tertentu.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/filter-panda-berdasarkan-nilai-kolom-tidak-sama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/filter-panda-berdasarkan-nilai-kolom-tidak-sama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/filter-panda-berdasarkan-nilai-kolom-tidak-sama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: filter berdasarkan kolom tidak sama dengan nilai tertentu"}]},{"@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\/4236"}],"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=4236"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4236\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4236"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}