{"id":4024,"date":"2023-07-14T02:37:24","date_gmt":"2023-07-14T02:37:24","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-memilih-kolom-berdasarkan-kecocokan-sebagian\/"},"modified":"2023-07-14T02:37:24","modified_gmt":"2023-07-14T02:37:24","slug":"panda-memilih-kolom-berdasarkan-kecocokan-sebagian","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-memilih-kolom-berdasarkan-kecocokan-sebagian\/","title":{"rendered":"Pandas: cara memilih kolom berdasarkan kecocokan sebagian"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk memilih kolom di pandas DataFrame berdasarkan kecocokan sebagian:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Pilih kolom berdasarkan kecocokan sebagian<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #3366ff;\"><span style=\"color: #008080;\">#select columns that contain 'team'<\/span>\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">loc<\/span> [:, df. <span style=\"color: #3366ff;\">columns<\/span> . <span style=\"color: #3366ff;\">str<\/span> . <span style=\"color: #3366ff;\">contains<\/span> (' <span style=\"color: #ff0000;\">team<\/span> ')]\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Pilih kolom berdasarkan beberapa kecocokan parsial<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #3366ff;\"><span style=\"color: #008080;\">#select columns that contain 'team' or 'rebounds'\n<\/span><span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">loc<\/span> [:, df. <span style=\"color: #3366ff;\">columns<\/span> . <span style=\"color: #3366ff;\">str<\/span> . <span style=\"color: #3366ff;\">contains<\/span> (' <span style=\"color: #ff0000;\">team|rebounds<\/span> ')]<\/span>\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dengan pandas DataFrame berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <b><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team_name<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'],\n                   ' <span style=\"color: #ff0000;\">team_points<\/span> ': [5, 7, 7, 9, 12, 9, 9, 4],\n                   ' <span style=\"color: #ff0000;\">assists<\/span> ': [11, 8, 10, 6, 6, 5, 9, 12],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [6, 7, 7, 6, 10, 12, 10, 9]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team_name team_points assists rebounds\n0 A 5 11 6\n1 To 7 8 7\n2 To 7 10 7\n3 to 9 6 6\n4 B 12 6 10\n5 B 9 5 12\n6 B 9 9 10\n7 B 4 12 9\n<\/b><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Pilih kolom berdasarkan kecocokan sebagian<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara memilih semua kolom di pandas DataFrame yang berisi &#8220;tim&#8221; di nama kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #3366ff;\"><span style=\"color: #008080;\">#select columns that contain 'team'<\/span>\n<span style=\"color: #000000;\">df_team_cols = df. <span style=\"color: #3366ff;\">loc<\/span> [:, df. <span style=\"color: #3366ff;\">columns<\/span> . <span style=\"color: #3366ff;\">str<\/span> . <span style=\"color: #3366ff;\">contains<\/span> (' <span style=\"color: #ff0000;\">team<\/span> ')]\n\n<span style=\"color: #008080;\">#view results\n<\/span><span style=\"color: #008000;\">print<\/span> (df_team_cols)\n\n  team_name team_points\n0 to 5\n1 to 7\n2 to 7\n3 to 9\n4 B 12\n5 B 9\n6 B 9\n7 B 4\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kedua kolom dengan nama &#8220;tim&#8221; dikembalikan.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Pilih kolom berdasarkan beberapa kecocokan parsial<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara memilih semua kolom di pandas DataFrame yang berisi &#8220;tim&#8221; atau &#8220;pentalan&#8221; di nama kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #3366ff;\"><span style=\"color: #008080;\">#select columns that contain 'team' or 'rebounds'<\/span>\n<span style=\"color: #000000;\">df_team_rebs = df. <span style=\"color: #3366ff;\">loc<\/span> [:, df. <span style=\"color: #3366ff;\">columns<\/span> . <span style=\"color: #3366ff;\">str<\/span> . <span style=\"color: #3366ff;\">contains<\/span> (' <span style=\"color: #ff0000;\">team|rebounds<\/span> ')]\n\n<span style=\"color: #008080;\">#view results\n<\/span><span style=\"color: #008000;\">print<\/span> (df_team_rebs)\n\n  team_name team_points rebounds\n0 to 5 6\n1 To 7 7\n2 to 7 7\n3 to 9 6\n4 B 12 10\n5 B 9 12\n6 B 9 10\n7 B 4 9\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Semua kolom dengan nama &#8220;tim&#8221; atau &#8220;rebound&#8221; dikembalikan.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : <strong>|<\/strong> operator mewakili &#8220;ATAU&#8221; di panda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menggunakan operator ini sebanyak yang Anda inginkan untuk menemukan kecocokan string parsial sebanyak yang Anda inginkan.<\/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 operasi umum lainnya di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/pandas-memilih-kolom-berdasarkan-nama\/\" target=\"_blank\" rel=\"noopener\">Cara memilih kolom berdasarkan nama di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-pilih-kolom-berdasarkan-indeks\/\" target=\"_blank\" rel=\"noopener\">Cara memilih kolom berdasarkan indeks di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-memilih-kolom-berdasarkan-jenis\/\" target=\"_blank\" rel=\"noopener\">Cara memilih kolom berdasarkan tipe data di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk memilih kolom di pandas DataFrame berdasarkan kecocokan sebagian: Metode 1: Pilih kolom berdasarkan kecocokan sebagian #select columns that contain &#8216;team&#8217; df. loc [:, df. columns . str . contains (&#8216; team &#8216;)] Metode 2: Pilih kolom berdasarkan beberapa kecocokan parsial #select columns that contain &#8216;team&#8217; or &#8216;rebounds&#8217; df. loc [&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 berdasarkan kecocokan sebagian - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memilih kolom di pandas DataFrame berdasarkan kecocokan sebagian, termasuk 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-memilih-kolom-berdasarkan-kecocokan-sebagian\/\" \/>\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 berdasarkan kecocokan sebagian - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memilih kolom di pandas DataFrame berdasarkan kecocokan sebagian, termasuk contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-memilih-kolom-berdasarkan-kecocokan-sebagian\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T02:37:24+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-memilih-kolom-berdasarkan-kecocokan-sebagian\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-memilih-kolom-berdasarkan-kecocokan-sebagian\/\",\"name\":\"Pandas: Cara memilih kolom berdasarkan kecocokan sebagian - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T02:37:24+00:00\",\"dateModified\":\"2023-07-14T02:37:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memilih kolom di pandas DataFrame berdasarkan kecocokan sebagian, termasuk contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-memilih-kolom-berdasarkan-kecocokan-sebagian\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-memilih-kolom-berdasarkan-kecocokan-sebagian\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-memilih-kolom-berdasarkan-kecocokan-sebagian\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara memilih kolom berdasarkan kecocokan sebagian\"}]},{\"@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 berdasarkan kecocokan sebagian - Statorial","description":"Tutorial ini menjelaskan cara memilih kolom di pandas DataFrame berdasarkan kecocokan sebagian, termasuk 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-memilih-kolom-berdasarkan-kecocokan-sebagian\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara memilih kolom berdasarkan kecocokan sebagian - Statorial","og_description":"Tutorial ini menjelaskan cara memilih kolom di pandas DataFrame berdasarkan kecocokan sebagian, termasuk contoh.","og_url":"https:\/\/statorials.org\/id\/panda-memilih-kolom-berdasarkan-kecocokan-sebagian\/","og_site_name":"Statorials","article_published_time":"2023-07-14T02:37:24+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-memilih-kolom-berdasarkan-kecocokan-sebagian\/","url":"https:\/\/statorials.org\/id\/panda-memilih-kolom-berdasarkan-kecocokan-sebagian\/","name":"Pandas: Cara memilih kolom berdasarkan kecocokan sebagian - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T02:37:24+00:00","dateModified":"2023-07-14T02:37:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memilih kolom di pandas DataFrame berdasarkan kecocokan sebagian, termasuk contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-memilih-kolom-berdasarkan-kecocokan-sebagian\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-memilih-kolom-berdasarkan-kecocokan-sebagian\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-memilih-kolom-berdasarkan-kecocokan-sebagian\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara memilih kolom berdasarkan kecocokan sebagian"}]},{"@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\/4024"}],"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=4024"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4024\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4024"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4024"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4024"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}