{"id":2186,"date":"2023-07-23T08:31:06","date_gmt":"2023-07-23T08:31:06","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-memilih-baris-berdasarkan-nilai-kolom\/"},"modified":"2023-07-23T08:31:06","modified_gmt":"2023-07-23T08:31:06","slug":"panda-memilih-baris-berdasarkan-nilai-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-memilih-baris-berdasarkan-nilai-kolom\/","title":{"rendered":"Pandas: cara memilih baris berdasarkan nilai kolom"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan salah satu metode berikut untuk memilih baris dalam pandas DataFrame berdasarkan nilai kolom:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Pilih Baris yang Kolomnya Sama dengan Nilai Tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong>df. <span style=\"color: #3366ff;\">loc<\/span> [df[' <span style=\"color: #ff0000;\">col1<\/span> '] <span style=\"color: #800080;\">==<\/span> value]\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Pilih baris dimana nilai kolom ditemukan dalam daftar nilai<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong>df. <span style=\"color: #3366ff;\">loc<\/span> [df[' <span style=\"color: #ff0000;\">col1<\/span> ']. <span style=\"color: #3366ff;\">isin<\/span> ([value1, value2, value3, ...])]<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: Pilih Baris Berdasarkan Beberapa Kondisi Kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong>df. <span style=\"color: #3366ff;\">loc<\/span> [(df[' <span style=\"color: #ff0000;\">col1<\/span> '] <span style=\"color: #800080;\">==<\/span> value) <span style=\"color: #800080;\">&amp;<\/span> (df[' <span style=\"color: #ff0000;\">col2<\/span> '] <span style=\"color: #800080;\">&lt;<\/span> value)]\n<\/strong><\/span><\/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;\"> <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> ': ['A', 'A', 'B', 'B', 'B', 'C', 'C', 'C'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [5, 7, 7, 9, 12, 9, 9, 4],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [11, 8, 10, 6, 6, 5, 9, 12],\n                   ' <span style=\"color: #ff0000;\">blocks<\/span> ': [4, 7, 7, 6, 5, 8, 9, 10]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n\tteam points rebound blocks\n0 A 5 11 4\n1 To 7 8 7\n2 B 7 10 7\n3 B 9 6 6\n4 B 12 6 5\n5 C 9 5 8\n6 C 9 9 9\n7 C 4 12 10\n<\/strong><\/span><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Metode 1: Pilih Baris yang Kolomnya Sama dengan Nilai Tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara memilih setiap baris DataFrame dengan kolom &#8220;poin&#8221; sama dengan 7:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#select rows where 'points' column is equal to 7\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">loc<\/span> [df[' <span style=\"color: #ff0000;\">points<\/span> '] <span style=\"color: #800080;\">==<\/span> 7]\n\n\tteam points rebound blocks\n1 To 7 8 7\n2 B 7 10 7\n<\/span><\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Metode 2: Pilih baris dimana nilai kolom ditemukan dalam daftar nilai<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara memilih setiap baris DataFrame dengan kolom &#8220;poin&#8221; sama dengan 7, 9, atau 12:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#select rows where 'points' column is equal to 7\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">loc<\/span> [df[' <span style=\"color: #ff0000;\">points<\/span> ']. <span style=\"color: #3366ff;\">isin<\/span> ([7, 9, 12])]\n\n        team points rebound blocks\n1 To 7 8 7\n2 B 7 10 7\n3 B 9 6 6\n4 B 12 6 5\n5 C 9 5 8\n6 C 9 9 9<\/span><\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Metode 3: Pilih Baris Berdasarkan Beberapa Kondisi Kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara memilih setiap baris DataFrame dengan kolom &#8220;tim&#8221; sama dengan &#8220;B&#8221; dan kolom &#8220;poin&#8221; lebih besar dari 8:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#select rows where 'team' is equal to 'B' and points is greater than 8\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">loc<\/span> [(df[' <span style=\"color: #ff0000;\">team<\/span> '] <span style=\"color: #800080;\">==<\/span> ' <span style=\"color: #ff0000;\">B<\/span> ') <span style=\"color: #800080;\">&amp;<\/span> (df[' <span style=\"color: #ff0000;\">points<\/span> '] <span style=\"color: #800080;\">&gt;<\/span> 8)]\n\n\tteam points rebound blocks\n3 B 9 6 6\n4 B 12 6 5<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya dua garis dimana tim sama dengan &#8220;B&#8221; dan &#8220;poin&#8221; lebih besar dari 8 yang dikembalikan.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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\/panda-memilih-baris-berdasarkan-indeks\/\" target=\"_blank\" rel=\"noopener\">Cara memilih baris berdasarkan indeks di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/garis-tunggal-panda\/\" target=\"_blank\" rel=\"noopener\">Cara memilih satu baris di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-menemukan-nilai-kolom-mana-pun\/\" target=\"_blank\" rel=\"noopener\">Cara memilih baris yang nilainya muncul di kolom mana pun di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan salah satu metode berikut untuk memilih baris dalam pandas DataFrame berdasarkan nilai kolom: Metode 1: Pilih Baris yang Kolomnya Sama dengan Nilai Tertentu df. loc [df[&#8216; col1 &#8216;] == value] Metode 2: Pilih baris dimana nilai kolom ditemukan dalam daftar nilai df. loc [df[&#8216; col1 &#8216;]. isin ([value1, value2, value3, &#8230;])] Metode [&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 baris berdasarkan nilai kolom \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memilih baris berdasarkan nilai kolom di panda, dengan 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-memilih-baris-berdasarkan-nilai-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara memilih baris berdasarkan nilai kolom \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memilih baris berdasarkan nilai kolom di panda, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-memilih-baris-berdasarkan-nilai-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T08:31:06+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-baris-berdasarkan-nilai-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-memilih-baris-berdasarkan-nilai-kolom\/\",\"name\":\"Pandas: Cara memilih baris berdasarkan nilai kolom \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T08:31:06+00:00\",\"dateModified\":\"2023-07-23T08:31:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memilih baris berdasarkan nilai kolom di panda, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-memilih-baris-berdasarkan-nilai-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-memilih-baris-berdasarkan-nilai-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-memilih-baris-berdasarkan-nilai-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara memilih baris berdasarkan nilai kolom\"}]},{\"@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 baris berdasarkan nilai kolom \u2013 Statorials","description":"Tutorial ini menjelaskan cara memilih baris berdasarkan nilai kolom di panda, dengan 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-memilih-baris-berdasarkan-nilai-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara memilih baris berdasarkan nilai kolom \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara memilih baris berdasarkan nilai kolom di panda, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-memilih-baris-berdasarkan-nilai-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-23T08:31:06+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-baris-berdasarkan-nilai-kolom\/","url":"https:\/\/statorials.org\/id\/panda-memilih-baris-berdasarkan-nilai-kolom\/","name":"Pandas: Cara memilih baris berdasarkan nilai kolom \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T08:31:06+00:00","dateModified":"2023-07-23T08:31:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memilih baris berdasarkan nilai kolom di panda, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-memilih-baris-berdasarkan-nilai-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-memilih-baris-berdasarkan-nilai-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-memilih-baris-berdasarkan-nilai-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara memilih baris berdasarkan nilai kolom"}]},{"@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\/2186"}],"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=2186"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2186\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}