{"id":3430,"date":"2023-07-17T12:55:29","date_gmt":"2023-07-17T12:55:29","guid":{"rendered":"https:\/\/statorials.org\/id\/pandas-pilih-kolom-yang-berisi-string\/"},"modified":"2023-07-17T12:55:29","modified_gmt":"2023-07-17T12:55:29","slug":"pandas-pilih-kolom-yang-berisi-string","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pandas-pilih-kolom-yang-berisi-string\/","title":{"rendered":"Pandas: cara memilih kolom yang berisi string tertentu"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk memilih kolom yang berisi string tertentu di pandas DataFrame:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Pilih kolom yang berisi string tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">filter<\/span> (regex=' <span style=\"color: #ff0000;\">string1<\/span> ')\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Pilih kolom yang berisi salah satu dari beberapa string<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">filter<\/span> (regex=' <span style=\"color: #ff0000;\">string1|string2|string3<\/span> ')<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode ini dalam praktik dengan pandas DataFrame berikut:<\/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;\">mavs<\/span> ': [10, 12, 14, 15, 19, 22, 27],\n                   ' <span style=\"color: #ff0000;\">cavs<\/span> ': [18, 22, 19, 14, 14, 11, 20],\n                   ' <span style=\"color: #ff0000;\">hornets<\/span> ': [5, 7, 7, 9, 12, 9, 14],\n                   ' <span style=\"color: #ff0000;\">spurs<\/span> ': [10, 12, 14, 13, 13, 19, 22],\n                   ' <span style=\"color: #ff0000;\">net<\/span> ': [10, 14, 25, 22, 25, 17, 12]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n   mavs cavs hornets spurs nets\n0 10 18 5 10 10\n1 12 22 7 12 14\n2 14 19 7 14 25\n3 15 14 9 13 22\n4 19 14 12 13 25\n5 22 11 9 19 17\n6 27 20 14 22 12\n<\/strong><\/span><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Pilih kolom yang berisi string tertentu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menggunakan fungsi <b>filter()<\/b> untuk memilih hanya kolom yang berisi string &#8220;avs&#8221; di suatu tempat di namanya:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#select columns that contain 'avs' in the name\n<\/span>df2 = df. <span style=\"color: #3366ff;\">filter<\/span> (regex=' <span style=\"color: #ff0000;\">avs<\/span> ')\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df2)\n\n   mavs cavs\n0 10 18\n1 12 22\n2 14 19\n3 15 14\n4 19 14\n5 22 11\n6 27 20\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Hanya kolom dengan nama &#8220;avs&#8221; yang dikembalikan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam hal ini, &#8220;mavs&#8221; dan &#8220;cavs&#8221; adalah satu-satunya kolom yang dikembalikan.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Pilih kolom yang berisi salah satu dari beberapa string<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menggunakan fungsi <b>filter()<\/b> untuk memilih hanya kolom yang berisi &#8220;avs&#8221; atau &#8220;ets&#8221; di suatu tempat di namanya:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#select columns that contain 'avs' in the name\n<\/span>df2 = df. <span style=\"color: #3366ff;\">filter<\/span> (regex=' <span style=\"color: #ff0000;\">avs|ets<\/span> ')\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df2)\n\n   mavs cavs hornets nets\n0 10 18 5 10\n1 12 22 7 14\n2 14 19 7 25\n3 15 14 9 22\n4 19 14 12 25\n5 22 11 9 17\n6 27 20 14 12<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Hanya kolom dengan nama &#8220;avs&#8221; atau &#8220;ets&#8221; yang dikembalikan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa bilah vertikal ( <strong>|<\/strong> ) adalah operator &#8221; <strong>OR<\/strong> &#8221; di panda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk merangkai sebanyak mungkin operator \u201cATAU\u201d ini untuk memilih kolom yang berisi salah satu dari banyak string berbeda.<\/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-bergerak-dari-tulang-belakang-ke-depan\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara memindahkan kolom di depan DataFrame<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-kolom-berisi-string\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara memeriksa apakah kolom berisi string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-menambahkan-kolom-kosong\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menambahkan kolom kosong ke DataFrame (3 contoh)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk memilih kolom yang berisi string tertentu di pandas DataFrame: Metode 1: Pilih kolom yang berisi string tertentu df. filter (regex=&#8217; string1 &#8216;) Metode 2: Pilih kolom yang berisi salah satu dari beberapa string df. filter (regex=&#8217; string1|string2|string3 &#8216;) Contoh berikut menunjukkan cara menggunakan masing-masing metode ini dalam praktik dengan [&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 memilih kolom yang berisi string tertentu - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memilih kolom yang berisi string tertentu 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-pilih-kolom-yang-berisi-string\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara memilih kolom yang berisi string tertentu - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memilih kolom yang berisi string tertentu di pandas DataFrame, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pandas-pilih-kolom-yang-berisi-string\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T12:55:29+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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-pilih-kolom-yang-berisi-string\/\",\"url\":\"https:\/\/statorials.org\/id\/pandas-pilih-kolom-yang-berisi-string\/\",\"name\":\"Pandas: Cara memilih kolom yang berisi string tertentu - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T12:55:29+00:00\",\"dateModified\":\"2023-07-17T12:55:29+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memilih kolom yang berisi string tertentu di pandas DataFrame, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pandas-pilih-kolom-yang-berisi-string\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pandas-pilih-kolom-yang-berisi-string\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-pilih-kolom-yang-berisi-string\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara memilih kolom yang 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: Cara memilih kolom yang berisi string tertentu - Statorial","description":"Tutorial ini menjelaskan cara memilih kolom yang berisi string tertentu 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-pilih-kolom-yang-berisi-string\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara memilih kolom yang berisi string tertentu - Statorial","og_description":"Tutorial ini menjelaskan cara memilih kolom yang berisi string tertentu di pandas DataFrame, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/pandas-pilih-kolom-yang-berisi-string\/","og_site_name":"Statorials","article_published_time":"2023-07-17T12:55:29+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/pandas-pilih-kolom-yang-berisi-string\/","url":"https:\/\/statorials.org\/id\/pandas-pilih-kolom-yang-berisi-string\/","name":"Pandas: Cara memilih kolom yang berisi string tertentu - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T12:55:29+00:00","dateModified":"2023-07-17T12:55:29+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memilih kolom yang berisi string tertentu di pandas DataFrame, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pandas-pilih-kolom-yang-berisi-string\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pandas-pilih-kolom-yang-berisi-string\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pandas-pilih-kolom-yang-berisi-string\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara memilih kolom yang 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\/3430"}],"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=3430"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3430\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}