{"id":4231,"date":"2023-07-12T16:14:30","date_gmt":"2023-07-12T16:14:30","guid":{"rendered":"https:\/\/statorials.org\/id\/nama-kolom-drop-panda-berisi\/"},"modified":"2023-07-12T16:14:30","modified_gmt":"2023-07-12T16:14:30","slug":"nama-kolom-drop-panda-berisi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/nama-kolom-drop-panda-berisi\/","title":{"rendered":"Pandas: hapus kolom jika nama berisi string tertentu"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk menghapus kolom dari pandas DataFrame yang namanya berisi string tertentu:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Hapus kolom jika nama berisi string tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">drop<\/span> (list(df. <span style=\"color: #3366ff;\">filter<\/span> (regex=' <span style=\"color: #ff0000;\">this_string<\/span> ')), axis= <span style=\"color: #008000;\">1<\/span> , inplace= <span style=\"color: #008000;\">True<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Hapus kolom jika nama berisi salah satu dari beberapa string tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">drop<\/span> (list(df. <span style=\"color: #3366ff;\">filter<\/span> (regex=' <span style=\"color: #ff0000;\">string1|string2|string3<\/span> ')), axis= <span style=\"color: #008000;\">1<\/span> , inplace= <span style=\"color: #008000;\">True<\/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_name<\/span> ': ['A', 'B', 'C', 'D', 'E', 'F'],\n                   ' <span style=\"color: #ff0000;\">team_location<\/span> ': ['AU', 'AU', 'EU', 'EU', 'AU', 'EU'],\n                   ' <span style=\"color: #ff0000;\">player_name<\/span> ': ['Andy', 'Bob', 'Chad', 'Dan', 'Ed', 'Fran'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [22, 29, 35, 30, 18, 12]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team_name team_location player_name points\n0 A AU Andy 22\n1 B AU Bob 29\n2 C EU Chad 35\n3 D EU Dan 30\n4 E TO Ed 18\n5 F EU Fran 12\n<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hapus kolom jika nama berisi string tertentu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk menghapus kolom apa pun dari DataFrame yang berisi &#8220;tim&#8221; di mana pun dalam nama kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#drop columns whose name contains 'team'\n<\/span>df. <span style=\"color: #3366ff;\">drop<\/span> (list(df. <span style=\"color: #3366ff;\">filter<\/span> (regex=' <span style=\"color: #ff0000;\">team<\/span> ')), axis= <span style=\"color: #008000;\">1<\/span> , inplace= <span style=\"color: #008000;\">True<\/span> )\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  player_name points\n0 Andy 22\n1 Bob 29\n2 Chad 35\n3 Dan 30\n4 Ed 18\n5 Fran 12\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa dua kolom yang berisi &#8220;tim&#8221; di namanya telah dihapus dari DataFrame.<\/span><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Hapus kolom jika nama berisi salah satu dari beberapa string tertentu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan sintaks berikut untuk menghapus kolom apa pun dari DataFrame yang berisi &#8220;pemain&#8221; atau &#8220;titik&#8221; di mana pun di nama kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#drop columns whose name contains 'player' or 'points'\n<\/span>df. <span style=\"color: #3366ff;\">drop<\/span> (list(df. <span style=\"color: #3366ff;\">filter<\/span> (regex=' <span style=\"color: #ff0000;\">player|points<\/span> ')), axis= <span style=\"color: #008000;\">1<\/span> , inplace= <span style=\"color: #008000;\">True<\/span> )\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team_name team_location\n0 A AU\n1 B AU\n2 C EU\n3D EU\n4 E AU\n5 F EU\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa dua kolom yang berisi &#8220;pemain&#8221; atau &#8220;poin&#8221;<\/span> <span style=\"color: #000000;\">pada namanya telah dihapus dari DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : <strong>|<\/strong> Simbol pada panda digunakan sebagai operator \u201cATAU\u201d.<\/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 umum lainnya di panda:<\/span><\/p>\n<p><a href=\"https:\/\/statorials.org\/id\/panda-menjatuhkan-kolom-pertama\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus kolom pertama di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-menjatuhkan-kolom-duplikat\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus kolom duplikat di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-menjatuhkan-semua-kolom-kecuali\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus semua kolom kecuali beberapa di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk menghapus kolom dari pandas DataFrame yang namanya berisi string tertentu: Metode 1: Hapus kolom jika nama berisi string tertentu df. drop (list(df. filter (regex=&#8217; this_string &#8216;)), axis= 1 , inplace= True ) Metode 2: Hapus kolom jika nama berisi salah satu dari beberapa string tertentu df. drop (list(df. filter [&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: hapus kolom jika nama berisi string tertentu \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus kolom di pandas DataFrame yang namanya berisi string tertentu, beserta 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\/nama-kolom-drop-panda-berisi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: hapus kolom jika nama berisi string tertentu \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus kolom di pandas DataFrame yang namanya berisi string tertentu, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/nama-kolom-drop-panda-berisi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T16:14:30+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\/nama-kolom-drop-panda-berisi\/\",\"url\":\"https:\/\/statorials.org\/id\/nama-kolom-drop-panda-berisi\/\",\"name\":\"Pandas: hapus kolom jika nama berisi string tertentu \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T16:14:30+00:00\",\"dateModified\":\"2023-07-12T16:14:30+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus kolom di pandas DataFrame yang namanya berisi string tertentu, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/nama-kolom-drop-panda-berisi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/nama-kolom-drop-panda-berisi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/nama-kolom-drop-panda-berisi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: hapus kolom jika nama berisi string 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: hapus kolom jika nama berisi string tertentu \u2013 Statorial","description":"Tutorial ini menjelaskan cara menghapus kolom di pandas DataFrame yang namanya berisi string tertentu, beserta 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\/nama-kolom-drop-panda-berisi\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: hapus kolom jika nama berisi string tertentu \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menghapus kolom di pandas DataFrame yang namanya berisi string tertentu, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/nama-kolom-drop-panda-berisi\/","og_site_name":"Statorials","article_published_time":"2023-07-12T16:14:30+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\/nama-kolom-drop-panda-berisi\/","url":"https:\/\/statorials.org\/id\/nama-kolom-drop-panda-berisi\/","name":"Pandas: hapus kolom jika nama berisi string tertentu \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T16:14:30+00:00","dateModified":"2023-07-12T16:14:30+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus kolom di pandas DataFrame yang namanya berisi string tertentu, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/nama-kolom-drop-panda-berisi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/nama-kolom-drop-panda-berisi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/nama-kolom-drop-panda-berisi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: hapus kolom jika nama berisi string 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\/4231"}],"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=4231"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4231\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4231"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}