{"id":1735,"date":"2023-07-25T05:02:59","date_gmt":"2023-07-25T05:02:59","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-dengan-nilai\/"},"modified":"2023-07-25T05:02:59","modified_gmt":"2023-07-25T05:02:59","slug":"panda-menjatuhkan-baris-dengan-nilai","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-dengan-nilai\/","title":{"rendered":"Pandas: cara menghapus baris yang mengandung nilai tertentu"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menghapus baris di pandas DataFrame yang berisi nilai tertentu di kolom tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#drop rows that contain specific 'value' in 'column_name'<\/span>\ndf = df[df. <span style=\"color: #3366ff;\">column_name<\/span> <span style=\"color: #993300;\">!=<\/span> <span style=\"color: #008000;\">value<\/span> ]\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menghapus baris dalam pandas DataFrame yang berisi nilai apa pun dalam daftar tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#define values<\/span>\nvalues = [value1, value2, value3, ...]\n\n<span style=\"color: #008080;\">#drop rows that contain any value in the list\n<\/span>df = df[df. <span style=\"color: #3366ff;\">column_name<\/span> . <span style=\"color: #3366ff;\">isin<\/span> (values) <span style=\"color: #993300;\">==<\/span> <span style=\"color: #008000;\">False<\/span> ]<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Hapus baris yang berisi nilai tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menghapus semua baris yang berisi nilai tertentu dalam kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><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', 'Lakers', 'Spurs', 'Cavs'],\n                   ' <span style=\"color: #ff0000;\">name<\/span> ': ['Dirk', 'Kobe', 'Tim', 'Lebron'],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [11, 7, 14, 7],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [26, 31, 22, 29]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n        team name rebound points\n0 Mavs Dirk 11 26\n1 Lakers Kobe 7 31\n2 Spurs Tim 14 22\n3 Cavs LeBron 7 29\n\n<span style=\"color: #008080;\">#drop any rows that have 7 in the rebounds column\n<\/span>df = df[df. <span style=\"color: #3366ff;\">rebounds<\/span> <span style=\"color: #993300;\">!=<\/span> <span style=\"color: #008000;\">7<\/span> ]\n\n<span style=\"color: #008080;\">#view resulting DataFrame<\/span>\ndf\n\n        team name rebound points\n0 Mavs Dirk 11 26\n2 Spurs Tim 14 22<\/strong><\/span><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Hapus Baris yang Berisi Nilai dalam Daftar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menghapus semua baris dari DataFrame yang berisi nilai dalam daftar:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><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', 'Lakers', 'Spurs', 'Cavs'],\n                   ' <span style=\"color: #ff0000;\">name<\/span> ': ['Dirk', 'Kobe', 'Tim', 'Lebron'],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [11, 7, 14, 7],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [26, 31, 22, 29]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n        team name rebound points\n0 Mavs Dirk 11 26\n1 Lakers Kobe 7 31\n2 Spurs Tim 14 22\n3 Cavs LeBron 7 29\n\n<span style=\"color: #008080;\">#define list of values<\/span>\nvalues = [7, 11]\n\n<span style=\"color: #008080;\">#drop any rows that have 7 or 11 in the rebounds column\n<\/span>df = df[df. <span style=\"color: #3366ff;\">rebounds<\/span> . <span style=\"color: #3366ff;\">isin<\/span> (values) <span style=\"color: #993300;\">==<\/span> <span style=\"color: #008000;\">False<\/span> ]\n\n<span style=\"color: #008080;\">#view resulting DataFrame<\/span>\ndf\n\n        team name rebound points\n2 Spurs Tim 14 22<\/strong><\/span><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Hapus Baris yang Mengandung Nilai Tertentu di Beberapa Kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menghapus baris dari DataFrame yang berisi nilai tertentu di salah satu dari beberapa kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><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', 'Lakers', 'Spurs', 'Cavs'],\n                   ' <span style=\"color: #ff0000;\">name<\/span> ': ['Dirk', 'Kobe', 'Tim', 'Lebron'],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [11, 7, 14, 7],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [26, 31, 22, 29]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n        team name rebound points\n0 Mavs Dirk 11 26\n1 Lakers Kobe 7 31\n2 Spurs Tim 14 22\n3 Cavs LeBron 7 29\n\n<span style=\"color: #008080;\">#drop any rows that have 11 in the rebounds column or 31 in the points column\n<\/span>df = df[(df. <span style=\"color: #3366ff;\">rebounds<\/span> <span style=\"color: #993300;\">!=<\/span> <span style=\"color: #008000;\">11<\/span> ) &amp; (df. <span style=\"color: #3366ff;\">points<\/span> <span style=\"color: #993300;\">!=<\/span> <span style=\"color: #008000;\">31<\/span> )]\n\n<span style=\"color: #008080;\">#view resulting DataFrame\n<\/span>df\n\nteam name rebound points\n2 Spurs Tim 14 22\n3 Cavs LeBron 7 29\n<\/strong><\/span><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-demi-indeks\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus baris berdasarkan indeks di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-menjatuhkan-kolom-demi-indeks\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus kolom berdasarkan indeks di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-yang-berisi-string\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus baris yang berisi string tertentu di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk menghapus baris di pandas DataFrame yang berisi nilai tertentu di kolom tertentu: #drop rows that contain specific &#8216;value&#8217; in &#8216;column_name&#8217; df = df[df. column_name != value ] Anda dapat menggunakan sintaks berikut untuk menghapus baris dalam pandas DataFrame yang berisi nilai apa pun dalam daftar tertentu: #define values values [&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: cara menghapus baris yang mengandung nilai tertentu<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus baris dari pandas DataFrame yang berisi nilai tertentu, termasuk 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-menjatuhkan-baris-dengan-nilai\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: cara menghapus baris yang mengandung nilai tertentu\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus baris dari pandas DataFrame yang berisi nilai tertentu, termasuk beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-dengan-nilai\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T05:02:59+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-menjatuhkan-baris-dengan-nilai\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-dengan-nilai\/\",\"name\":\"Pandas: cara menghapus baris yang mengandung nilai tertentu\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T05:02:59+00:00\",\"dateModified\":\"2023-07-25T05:02:59+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus baris dari pandas DataFrame yang berisi nilai tertentu, termasuk beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-dengan-nilai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-dengan-nilai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-dengan-nilai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menghapus baris yang mengandung 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: cara menghapus baris yang mengandung nilai tertentu","description":"Tutorial ini menjelaskan cara menghapus baris dari pandas DataFrame yang berisi nilai tertentu, termasuk 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-menjatuhkan-baris-dengan-nilai\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: cara menghapus baris yang mengandung nilai tertentu","og_description":"Tutorial ini menjelaskan cara menghapus baris dari pandas DataFrame yang berisi nilai tertentu, termasuk beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-dengan-nilai\/","og_site_name":"Statorials","article_published_time":"2023-07-25T05:02:59+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-menjatuhkan-baris-dengan-nilai\/","url":"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-dengan-nilai\/","name":"Pandas: cara menghapus baris yang mengandung nilai tertentu","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T05:02:59+00:00","dateModified":"2023-07-25T05:02:59+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus baris dari pandas DataFrame yang berisi nilai tertentu, termasuk beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-dengan-nilai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-dengan-nilai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-dengan-nilai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menghapus baris yang mengandung 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\/1735"}],"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=1735"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1735\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1735"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}