{"id":4237,"date":"2023-07-12T15:05:54","date_gmt":"2023-07-12T15:05:54","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-memilih-garis-di-antara-nilai\/"},"modified":"2023-07-12T15:05:54","modified_gmt":"2023-07-12T15:05:54","slug":"panda-memilih-garis-di-antara-nilai","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-memilih-garis-di-antara-nilai\/","title":{"rendered":"Pandas: cara memilih baris di antara dua nilai"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk memilih baris dalam pandas DataFrame di mana kolom berada di antara dua nilai tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df_filtered = df[df[' <span style=\"color: #ff0000;\">points<\/span> ']. <span style=\"color: #3366ff;\">between<\/span> ( <span style=\"color: #008000;\">25<\/span> , <span style=\"color: #008000;\">35<\/span> )]\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini memilih semua baris yang nilainya di kolom poin <strong>antara<\/strong> 25 dan 35.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin memilih baris yang nilainya di kolom poin <strong>bukan antara<\/strong> 25 dan 35, Anda bisa menambahkan tanda gelombang ( <strong>~<\/strong> ) sebelum nama kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df_filtered = df[ <span style=\"color: #800080;\">~<\/span> df[' <span style=\"color: #ff0000;\">points<\/span> ']. <span style=\"color: #3366ff;\">between<\/span> ( <span style=\"color: #008000;\">25<\/span> , <span style=\"color: #008000;\">35<\/span> )]<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: pilih baris antara dua nilai di Pandas<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang poin yang dicetak oleh pemain bola basket dari tim berbeda:<\/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<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['Mavs', 'Mavs', 'Nets', 'Nets', 'Heat', 'Heat', 'Kings'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [22, 28, 35, 34, 29, 28, 23]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n    team points\n0 Mavs 22\n1 Mavs 28\n2 Nets 35\n3 Nets 34\n4 Heat 29\n5 Heat 28\n6 Kings 23\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk memilih hanya baris dari DataFrame yang nilai kolom <b>poinnya<\/b> <strong>antara<\/strong> 25 dan 35:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#select rows where value in points column is between 25 and 35\n<span style=\"color: #000000;\">df_filtered = df[df[' <span style=\"color: #ff0000;\">points<\/span> ']. <span style=\"color: #3366ff;\">between<\/span> ( <span style=\"color: #008000;\">25<\/span> , <span style=\"color: #008000;\">35<\/span> )]\n<\/span>\n#view filtered DataFrame\n<span style=\"color: #000000;\"><span style=\"color: #008000;\">print<\/span> (df_filtered)\n\n   team points\n1 Mavs 28\n2 Nets 35\n3 Nets 34\n4 Heat 29\n5 Heat 28\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya baris yang nilainya di kolom poin antara 25 dan 35 yang dipilih.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa fungsi <strong>antara()<\/strong> <em>menyertakan<\/em> nilai di batas bawah dan atas.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, pemain dengan nilai poin 35 disertakan dalam DataFrame yang difilter.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin memilih hanya baris yang nilainya di kolom poin <strong>bukan antara<\/strong> 25 dan 35, kita bisa menambahkan tanda gelombang ( <strong>~<\/strong> ) sebelum nama kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#select rows where value in points column is not between 25 and 35\n<span style=\"color: #000000;\">df_filtered = df[ <span style=\"color: #800080;\">~<\/span> df[' <span style=\"color: #ff0000;\">points<\/span> ']. <span style=\"color: #3366ff;\">between<\/span> ( <span style=\"color: #008000;\">25<\/span> , <span style=\"color: #008000;\">35<\/span> )]\n<\/span>\n#view filtered DataFrame\n<span style=\"color: #000000;\"><span style=\"color: #008000;\">print<\/span> (df_filtered)\n\n    team points\n0 Mavs 22\n6 Kings 23<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya baris yang nilainya di kolom poin bukan antara 25 dan 35 yang dipilih.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas <strong>between()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.Series.between.html\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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-memilih-baris-atau-dua-kolom-yang-sama\/\" target=\"_blank\" rel=\"noopener\">Pandas: pilih baris yang dua kolomnya sama<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pandas-memilih-baris-berdasarkan-seri-boolean\/\" target=\"_blank\" rel=\"noopener\">Pandas: pilih baris dari DataFrame menggunakan seri boolean<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-memilih-baris-dengan-nan\/\" target=\"_blank\" rel=\"noopener\">Pandas: pilih baris dengan nilai NaN<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk memilih baris dalam pandas DataFrame di mana kolom berada di antara dua nilai tertentu: df_filtered = df[df[&#8216; points &#8216;]. between ( 25 , 35 )] Contoh khusus ini memilih semua baris yang nilainya di kolom poin antara 25 dan 35. Jika Anda ingin memilih baris yang nilainya di [&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 garis di antara dua nilai \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memilih baris yang kolomnya berada di antara dua nilai tertentu, dengan sebuah 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-garis-di-antara-nilai\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara memilih garis di antara dua nilai \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memilih baris yang kolomnya berada di antara dua nilai tertentu, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-memilih-garis-di-antara-nilai\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T15:05:54+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-garis-di-antara-nilai\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-memilih-garis-di-antara-nilai\/\",\"name\":\"Pandas: Cara memilih garis di antara dua nilai \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T15:05:54+00:00\",\"dateModified\":\"2023-07-12T15:05:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memilih baris yang kolomnya berada di antara dua nilai tertentu, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-memilih-garis-di-antara-nilai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-memilih-garis-di-antara-nilai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-memilih-garis-di-antara-nilai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara memilih baris di antara dua nilai\"}]},{\"@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 garis di antara dua nilai \u2013 Statorial","description":"Tutorial ini menjelaskan cara memilih baris yang kolomnya berada di antara dua nilai tertentu, dengan sebuah 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-garis-di-antara-nilai\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara memilih garis di antara dua nilai \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara memilih baris yang kolomnya berada di antara dua nilai tertentu, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/panda-memilih-garis-di-antara-nilai\/","og_site_name":"Statorials","article_published_time":"2023-07-12T15:05:54+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-garis-di-antara-nilai\/","url":"https:\/\/statorials.org\/id\/panda-memilih-garis-di-antara-nilai\/","name":"Pandas: Cara memilih garis di antara dua nilai \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T15:05:54+00:00","dateModified":"2023-07-12T15:05:54+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memilih baris yang kolomnya berada di antara dua nilai tertentu, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-memilih-garis-di-antara-nilai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-memilih-garis-di-antara-nilai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-memilih-garis-di-antara-nilai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara memilih baris di antara dua nilai"}]},{"@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\/4237"}],"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=4237"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4237\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}