{"id":4310,"date":"2023-07-12T02:38:12","date_gmt":"2023-07-12T02:38:12","guid":{"rendered":"https:\/\/statorials.org\/id\/permintaan-panda-tidak-masuk\/"},"modified":"2023-07-12T02:38:12","modified_gmt":"2023-07-12T02:38:12","slug":"permintaan-panda-tidak-masuk","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/permintaan-panda-tidak-masuk\/","title":{"rendered":"Pandas: cara menggunakan metode isin() dengan metode query()"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin menggunakan fungsi <strong>isin()<\/strong> dalam metode <strong>query()<\/strong> di panda untuk memfilter baris dalam DataFrame di mana kolom berisi nilai dalam daftar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">query<\/span> (' <span style=\"color: #ff0000;\">team in [\"A\", \"B\", \"D\"]<\/span> ')<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri khusus ini memfilter baris dari Pandas DataFrame dengan kolom <strong>tim<\/strong> sama dengan A, B, atau D.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Kita perlu menggunakan <strong>in<\/strong> alih-alih <strong>isin<\/strong> saat menggunakan metode pandas <strong>query()<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Gunakan metode query() untuk memfilter nilai dalam daftar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #107d3f;\">import<\/span> pandas <span style=\"color: #107d3f;\">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> ': ['A', 'A', 'B', 'B', 'C', 'C', 'D', 'E'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [18, 22, 19, 14, 14, 11, 20, 28],\n                   ' <span style=\"color: #ff0000;\">assists<\/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\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team points assists rebounds\n0 A 18 5 11\n1 to 22 7 8\n2 B 19 7 10\n3 B 14 9 6\n4 C 14 12 6\n5 C 11 9 5\n6 D 20 9 9\n7 E 28 4 12<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin mencari baris yang nilai kolom <strong>timnya<\/strong> sama dengan A, B, atau D.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#query for rows where team is in list of specific teams\n<\/span>df. <span style=\"color: #3366ff;\">query<\/span> (' <span style=\"color: #ff0000;\">team in [\"A\", \"B\", \"D\"]<\/span> ')\n\n\tteam points assists rebounds\n0 A 18 5 11\n1 to 22 7 8\n2 B 19 7 10\n3 B 14 9 6\n6 D 20 9 9<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa fungsi <strong>query()<\/strong> mengembalikan semua baris yang nilai di kolom <strong>tim<\/strong> sama dengan A, B, atau D.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa kita dapat menyimpan daftar nama tim dalam sebuah variabel dan kemudian mereferensikan variabel tersebut dalam fungsi <strong>query()<\/strong> menggunakan operator <strong>@<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create variable to hold specific team names\n<span style=\"color: #000000;\">team_names = [\" <span style=\"color: #ff0000;\">A<\/span> \", \" <span style=\"color: #ff0000;\">B<\/span> \", \" <span style=\"color: #ff0000;\">D<\/span> \"]<\/span><\/span>\n\n<span style=\"color: #008080;\">#query for rows where team is equal to a team name in team_names variable\n<\/span>df. <span style=\"color: #3366ff;\">query<\/span> (' <span style=\"color: #ff0000;\">team in @team_names<\/span> ')\n\n\tteam points assists rebounds\n0 A 18 5 11\n1 to 22 7 8\n2 B 19 7 10\n3 B 14 9 6\n6 D 20 9 92\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri mengembalikan semua baris di DataFrame di mana <strong>tim<\/strong> sama dengan salah satu nama tim yang disimpan dalam variabel <strong>team_names<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hasil kueri ini cocok dengan contoh sebelumnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas <strong>query()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.DataFrame.query.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-memfilter-garis-berdasarkan-panjang-string\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara memfilter baris berdasarkan panjang string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-dengan-syarat\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menghapus baris berdasarkan kondisi<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tidak-ada-panda\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menggunakan filter \u201cNO IN\u201d.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin menggunakan fungsi isin() dalam metode query() di panda untuk memfilter baris dalam DataFrame di mana kolom berisi nilai dalam daftar. Anda dapat menggunakan sintaks berikut untuk melakukan ini: df. query (&#8216; team in [&#8220;A&#8221;, &#8220;B&#8221;, &#8220;D&#8221;] &#8216;) Kueri khusus ini memfilter baris dari Pandas DataFrame dengan kolom tim sama dengan A, [&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 menggunakan isin() dengan metode query() - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi isin() dalam kueri pandas, beserta 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\/permintaan-panda-tidak-masuk\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara menggunakan isin() dengan metode query() - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi isin() dalam kueri pandas, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/permintaan-panda-tidak-masuk\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T02:38:12+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\/permintaan-panda-tidak-masuk\/\",\"url\":\"https:\/\/statorials.org\/id\/permintaan-panda-tidak-masuk\/\",\"name\":\"Pandas: Cara menggunakan isin() dengan metode query() - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T02:38:12+00:00\",\"dateModified\":\"2023-07-12T02:38:12+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi isin() dalam kueri pandas, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/permintaan-panda-tidak-masuk\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/permintaan-panda-tidak-masuk\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/permintaan-panda-tidak-masuk\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menggunakan metode isin() dengan metode query()\"}]},{\"@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 menggunakan isin() dengan metode query() - Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi isin() dalam kueri pandas, beserta 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\/permintaan-panda-tidak-masuk\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menggunakan isin() dengan metode query() - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi isin() dalam kueri pandas, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/permintaan-panda-tidak-masuk\/","og_site_name":"Statorials","article_published_time":"2023-07-12T02:38:12+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\/permintaan-panda-tidak-masuk\/","url":"https:\/\/statorials.org\/id\/permintaan-panda-tidak-masuk\/","name":"Pandas: Cara menggunakan isin() dengan metode query() - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T02:38:12+00:00","dateModified":"2023-07-12T02:38:12+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi isin() dalam kueri pandas, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/permintaan-panda-tidak-masuk\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/permintaan-panda-tidak-masuk\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/permintaan-panda-tidak-masuk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menggunakan metode isin() dengan metode query()"}]},{"@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\/4310"}],"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=4310"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4310\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4310"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4310"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}