{"id":3859,"date":"2023-07-15T03:19:01","date_gmt":"2023-07-15T03:19:01","guid":{"rendered":"https:\/\/statorials.org\/id\/cari-string-dalam-kerangka-data-pandas\/"},"modified":"2023-07-15T03:19:01","modified_gmt":"2023-07-15T03:19:01","slug":"cari-string-dalam-kerangka-data-pandas","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/cari-string-dalam-kerangka-data-pandas\/","title":{"rendered":"Pandas: cari string di semua kolom dataframe"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks berikut untuk mencari string tertentu di setiap kolom pandas DataFrame dan memfilter baris yang berisi string di setidaknya satu kolom:<\/span><\/p>\n

 #define filter\n<\/span>mask = np. column_stack<\/span> ([df[col]. str<\/span> . contains<\/span> (r \" my_string<\/span> \", na= False<\/span> ) for<\/span> col in<\/span> df])\n<\/span>\n#filter for rows where any column contains 'my_string'\n<\/span>df. loc<\/span> [mask. any<\/span> (axis= 1<\/span> )]<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: mencari string di semua kolom Pandas DataFrame<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang peran pertama dan peran kedua dari berbagai pemain bola basket dalam sebuah tim:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame\ndf = pd. DataFrame<\/span> ({' player<\/span> ': ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H'],\n                   ' first_role<\/span> ': ['P Guard', 'P Guard', 'S Guard', 'S Forward',\n                                  'P Forward', 'Center', 'Center', 'Center'],\n                   ' second_role<\/span> ': ['S Guard', 'S Guard', 'Forward', 'S Guard',\n                                   'S Guard', 'S Forward', 'P Forward', 'P Forward']})\n\n#view DataFrame\n<\/span>print<\/span> (df)\n\n  player first_role second_role\n0 AP Guard S Guard\n1 BP Guard S Guard\n2 CS Guard Forward\n3DS Forward S Guard\n4 EP Forward S Guard\n5 F Center S Forward\n6 G Center P Forward\n7 H Center P Forward<\/span><\/span><\/strong><\/pre>\n
 Kode berikut menunjukkan cara memfilter pandas DataFrame untuk baris di mana string “Penjaga” muncul di kolom mana pun:<\/span><\/p>\n
 import<\/span> numpy as<\/span> np\n\n#define filter\n<\/span>mask = np. column_stack<\/span> ([df[col]. str<\/span> . contains<\/span> (r \" Guard<\/span> \", na= False<\/span> ) for<\/span> col in<\/span> df])\n\n#filter for rows where any column contains 'Guard'\n<\/span>df. loc<\/span> [mask. any<\/span> (axis= 1<\/span> )]\n\n        player first_role second_role\n0 A P Guard S Guard\n1 B P Guard S Guard\n2 C S Guard Forward\n3 D S Forward S Guard\n4 E P Forward S Guard\n<\/span><\/span><\/strong><\/pre>\n
 Perhatikan bahwa setiap baris DataFrame yang dihasilkan berisi string “Penjaga” di setidaknya satu kolom.<\/span><\/p>\n
 Anda juga dapat memfilter baris yang salah satu dari beberapa stringnya muncul di setidaknya satu kolom dengan menggunakan operator “ATAU” ( |<\/strong> ) di panda.<\/span><\/p>\n
 Misalnya, kode berikut memperlihatkan cara memfilter baris di mana “P Guard” atau “Center” muncul di setidaknya satu kolom:<\/span><\/p>\n
 import<\/span> numpy as<\/span> np\n\n#define filter\n<\/span>mask = np. column_stack<\/span> ([df[col]. str<\/span> . contains<\/span> (r \" P Guard|Center<\/span> \", na= False<\/span> ) for<\/span> col in<\/span> df])\n\n#filter for rows where any column contains 'P Guard' or 'Center'\n<\/span>df. loc<\/span> [mask. any<\/span> (axis= 1<\/span> )]\n\n        player first_role second_role\n0 A P Guard S Guard\n1 B P Guard S Guard\n5 F Center S Forward\n6 G Center P Forward\n7 H Center P Forward\n<\/span><\/span><\/strong><\/pre>\n
 Perhatikan bahwa setiap baris dalam DataFrame yang dihasilkan berisi “P Guard” atau “Center” di setidaknya satu kolom.<\/span><\/p>\n
 Catatan<\/strong> : Penting untuk menyertakan argumen na=False<\/strong> dalam fungsi mengandung()<\/strong> jika tidak, Anda akan mengalami kesalahan<\/a> jika nilai NaN ada di DataFrame.<\/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 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 mencari string tertentu di setiap kolom pandas DataFrame dan memfilter baris yang berisi string di setidaknya satu kolom: #define filter mask = np. column_stack ([df[col]. str . contains (r ” my_string “, na= False ) for col in df]) #filter for rows where any column contains ‘my_string’ df. loc […]<\/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":"\nPandas: Temukan string di semua kolom DataFrame - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mencari string tertentu di setiap kolom 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\/cari-string-dalam-kerangka-data-pandas\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Temukan string di semua kolom DataFrame - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mencari string tertentu di setiap kolom Pandas DataFrame, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/cari-string-dalam-kerangka-data-pandas\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T03:19:01+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\/cari-string-dalam-kerangka-data-pandas\/\",\"url\":\"https:\/\/statorials.org\/id\/cari-string-dalam-kerangka-data-pandas\/\",\"name\":\"Pandas: Temukan string di semua kolom DataFrame - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T03:19:01+00:00\",\"dateModified\":\"2023-07-15T03:19:01+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mencari string tertentu di setiap kolom Pandas DataFrame, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/cari-string-dalam-kerangka-data-pandas\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/cari-string-dalam-kerangka-data-pandas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/cari-string-dalam-kerangka-data-pandas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cari string di semua kolom dataframe\"}]},{\"@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: Temukan string di semua kolom DataFrame - Statorials","description":"Tutorial ini menjelaskan cara mencari string tertentu di setiap kolom 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\/cari-string-dalam-kerangka-data-pandas\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Temukan string di semua kolom DataFrame - Statorials","og_description":"Tutorial ini menjelaskan cara mencari string tertentu di setiap kolom Pandas DataFrame, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/cari-string-dalam-kerangka-data-pandas\/","og_site_name":"Statorials","article_published_time":"2023-07-15T03:19:01+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\/cari-string-dalam-kerangka-data-pandas\/","url":"https:\/\/statorials.org\/id\/cari-string-dalam-kerangka-data-pandas\/","name":"Pandas: Temukan string di semua kolom DataFrame - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T03:19:01+00:00","dateModified":"2023-07-15T03:19:01+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mencari string tertentu di setiap kolom Pandas DataFrame, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/cari-string-dalam-kerangka-data-pandas\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/cari-string-dalam-kerangka-data-pandas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/cari-string-dalam-kerangka-data-pandas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cari string di semua kolom dataframe"}]},{"@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\/3859"}],"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=3859"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3859\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}